What's new in version 3.2

Toad Data Modeler version 3.0 was a significant increase in the capabilities in comparison to Toad Data Modeler 2. Toad Data Modeler version 3.0 was written from scratch. The latest version 3.2 contains many new features and useful enhancements.

Key Features in Toad Data Modeler version 3.2

  • Physical Model
  • Logical Model
  • Support for various databases - DB2 UDB v 8 (LUW), DB2 v. 9 (LUW), MS Access 2000-2003, MS SQL Server 2005, MS SQL Server 2000, MySQL 5, Oracle 11g, Oracle 10g, Oracle 9i, PostgreSQL 8.2, PostgreSQL 8.1, Sybase ASE 15, Sybase ASE 12.5.
  • Reverse Engineering
  • DDL/SQL Script Generation
  • Import from SQL Script - Oracle 11g, Oracle 10g, Oracle 9i
  • Alter Script Generation - Oracle 11g, Oracle 10g, Oracle 9i.
  • HTML/RTF Reports
  • Version Manager
  • Model Explorer
  • Mode Merge
  • Model Compare
  • Model Verification
  • Package Explorer
  • Script Explorer
  • Autolayout
  • Workspaces and Designers
  • Editable Forms
  • Dockable Panes
  • Modeless Dialogs/Forms
  • Categories
  • Message Explorer
  • Undo/Redo
  • To Do List
  • Zoom, Loupe, Model Overview
  • Support for Unicode and more

New Features in Toad Data Modeler v. 3.2.4.3

  • Support for Oracle 11g
  • Support for MS Access 2000/2002/2003
  • Import from SQL Script (Oracle only) – You can now load a model from SQL script using the Reverse Engineering Wizard. If a typo or unknown command is found in the SQL script, the RE Wizard will highlight the error to bring it to your attention.
  • Enhanced Live Reverse Engineering from SQL Script
  • SQL code generation by SCHEMA/USER – Toad Data Modeler users can now select ‘User’ or ‘Schema’ and generate SQL script for objects with the selected User or Schema.
  • Optimization of Memory Consumption
  • Faster Performance of Large Models
  • Enhanced Detection of Errors
  • Simplified model conversion and merge
  • Unicode HTML/RTF reports
  • Additional GUI and performance enhancements

Known issues

  • Reverse Engineering - Toad Data Modeler is not compatible with Oracle 11 Client. Please use TCP/IP connection (recommended) or Oracle 10g Client for reverse engineering.

Upgrade and Compatibility

Toad Data Modeler 3.2 allows you to open *.DM2 and *.DMX files of Toad Data Modeler 2. (DMX file is a DM2 file in XML format.) This applies only to models of database systems that are supported by both applications - Toad Data Modeler 2 and Toad Data Modeler version 3.
It is not possible to open models created in Toad Data Modeler 3 in Toad Data Modeler 2.

Global Operations

This release is Unicode-enabled and supports any character set. In this release, all product components should be configured to use the same or compatible character encodings and should be installed to use the same locale and regional options. This release is targeted to support operations in the following regions: North America, Western Europe and Latin America, Central and Eastern Europe, Far-East Asia, Japan.