What's new in version 3.5

This version introduces many new features and a lot of improvements.

Key Features in Toad Data Modeler version 3.5

  • Physical Model
  • Logical Model
  • Support for various databases - DB2 v 9.7 (LUW), DB2 v 9.5 (LUW), DB2 v 9 (LUW), DB2 UDB v 8 (LUW), MS Access 2000-2003, MS SQL Server 2008, MS SQL Server 2005, MS SQL Server 2000, MySQL 5.1, MySQL 5, Oracle 11g, Oracle 10g, Oracle 9i, PostgreSQL 8.4, PostgreSQL 8.3, PostgreSQL 8.2, PostgreSQL 8.1, Sybase ASE 15, Sybase ASE 12.5.
  • Reverse Engineering
  • DDL/SQL Script Generation
  • Import from SQL Script - DB2 v 9.7 (LUW), DB2 v 9.5 (LUW), MS SQL Server 2005 and 2008, MySQL 5.0 and 5.1, Oracle 9i, Oracle 10g and Oracle 11g
  • Alter Script Generation - Oracle 9i, Oracle 10g, Oracle 11g, MySQL 5.0 and MySQL 5.1, MS SQL Server 2005, MS SQL Server 2008, PostgreSQL 8.1, 8.2, 8.3, 8.4, DB2 UDB 8, DB2 v9, DB2 v9.5 and DB2 v9.7
  • HTML/RTF/PDF Reports
  • XML/XSLT based Reports
  • XSD Generation (metadata only)
  • Version Manager
  • Model Explorer
  • Mode Merge
  • Model Compare
  • Model Verification
  • Macros
  • Application Variables
  • Templates
  • Default Values
  • 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.5

  • Support on Microsoft Windows 7 32-bit and 7 64-bit operating system
  • Support for DB 2 LUW 9.7
  • Support for PostgreSQL 8.4
  • Templates now allow users to use pre-defined templates, customizable templates or Toad templates to save time and give you greater flexibility.
  • Application Variables allowing users to use them for:
    - defining default values (e.g. relationship names - <%ParentTableName%>_<%ChildTableName%>),
    - user templates created in Template Editor,
    - properties that contain SQL code (SQL, Before Script, After Script etc.)
  • Object Viewer has been enhanced, allowing for quick searching of objects in the model and easier access to editing of model properties
  • Naming conventions have been updated to allow for the deployment and management of naming standards to save time.
  • Default Values dialog has been simplified significantly so users can define default values for new objects of their models comfortably.
  • Macros functionality has been enhanced by possibility to use visual components for creation of macros. Also, users are allowed to add their macro to pop-up menu of particular object and use enhanced scripting functionality while creating macros. New sample macros Infer Relationships and Alphabetic Autolayout are available in Macros menu.
  • Alter Script generation enhancements greatly reduces the steps and time needed to compare a model to a database and generate an alter script.
    Reverse Engineering Wizard has been updated by new options such as Reload Aliases, Divide Objects on Workspace by User/Schema and improved Filter functionality.
  • SQL/DDL Script Generation offers new enhancements such as possibility to drop keys (primary, alternate), indexes, relationships and triggers outside the Create Table statement OR possibility to generate keys, indexes or triggers without the necessity to generate tables or views and more. Users can change order of generated objects from the DDL Script Generation dialog directly.
  • The new version brings great new GUI enhancements such as insert of image to Workspace (WS), highlighting key attributes and selecting a color for them, possibility to select parent and child objects on the WS at one jump, option to set the same size of selected objects on the WS and much more.

Upgrade and Compatibility

Toad Data Modeler 3.5 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: NorthAmerica, Western Europe and Latin America, Central and Eastern Europe, Far-East Asia, Japan.