What's new in version 3.1

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.1 contains many new features and useful enhancements.

Key Features in Toad Data Modeler version 3

• Physical Model
• Logical Model
• Support for various databases - DB2 UDB v 8 (LUW), DB2 v. 9 (LUW), MS SQL Server 2005, MS SQL Server 2000, MySQL 5, Oracle 10g, Oracle 9i, PostgreSQL 8.2, PostgreSQL 8.1, Sybase ASE 15, Sybase ASE 12.5.
• Reverse Engineering
• DDL/SQL Script Generation
• Alter Script Generation - 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.1.5

• Support for DB 2 v. 9 (LUW) 
• Support for DB2 UDB v. 8 (LUW)
• Support on Microsoft Windows XP 64bit and Microsoft Vista
• Direct Import of TDM2 Models (.DM2 files) - See the Open dialog | Files of Type box | new item ‘TDM2 Models in binary format (*.dm2)’.
• Object Types and Properties (OTPs) - New option enabling you to select objects and properties on various forms, define default settings, and store and load defined settings.
• Available OTPs - New option for experts interested in writing their own support for new database system or for people who like to enhance existing support for selected database system. (Settings menu, Expert Mode enabled)
• Toad for Oracle Integration - New options for Toad for Oracle users:
  - Opening Toad for Oracle Projects (File menu)
  - Importing Toad for Oracle ER Diagrams (File menu)
  - Reverse Engineering from Integrated Toads Object Palette (Live RE) (File menu)
  - Toad for Oracle Aliases (in Reverse Engineering Wizard and Connections tab)
  - Toad for Oracle Icons (View menu | Icons Theme)
• LIVE Reverse Engineering - This new feature represents another way of reverse engineering of particular objects or can be used as a simple model update (limited). (File menu | Connections)
• Schema/Owner/Database Assignment - Option to assign schema/owner to your model at one jump or remove existing schema from your model. (Model menu)
• Generation of Alter Reports - Possibility to generate a report with changes between two models from the Convertor and Comparator dialogs. (Basic report only.)
• Test Model, Repair Model - Options to test and repair models. (Application View model context menu, Expert Mode enabled)
• Materialized Views support - Supported for databases: Oracle 10g and 9i, DB 2 v. 9 (LUW), DB2 UDB v. 8 (LUW). (Model menu)

Updates to Toad Data Modeler v. 3.1.5

• Expert Mode - Expert Mode (Settings menu | Options | General) includes functions and options for more advanced users (Script Explorer, Package Explorer, Version Manager etc.)
• Verify Model  - Possibility to save settings for verification of particular model (new Save Settings button).
• Main Menu - Filtering menu items accordingly to the ability of current model (database).
• Object Oriented Reverse Engineering - Now TDM 3 offers you two different methods of reverse engineering - bulk loading of objects and loading of even one particular object or a group of selected objects.
• Enhanced Reverse Engineering Wizard - Toad for Oracle Aliases available, new steps added (e.g. What to Reverse), possibility to save selected options within an alias etc.
• New Format of Aliases - Format of aliases has been changed. Newly created aliases will have extension .txa.
  (Used to be .tta.) A warning message will appear in case you have any aliases in old format. The message will ask you if you like to convert the old aliases to the new format. We recommend you to do so.
• Convertor - New interface in the Convertor dialog, saving the dialog properties. (New combo-boxes, Execute and Generate Report buttons, OTPs tabs.)
• Oracle database - Reverse Engineering – Partitioning Information for Tables and Indexes are loaded now.
• Metamodel - Possibility to add abstract classes into Metamodel.
• GUI Changes:
  • New default layout of the application – with Model Explorer, Application View and Message Explorer.
    
  • Automatic docking of Model Explorer and Message Explorer.
  • Form caption as window title displayed.
  • Displaying hourglass during the script generation, model verification, model merge, compare, convert etc. processes.
  • HTML/RTF Reports - Saving user settings for report generation within a model.
  • Centered default position of editable forms.
  • Minimize Forms - Option to minimize all undocked forms and dialogs.
  • OK+Add button in Object Properties dialogs for quick adding of new items (e.g. Attribute Properties dialog).
    
  • Correct object order when using the Tab key.
  • Improved possibility of finding objects in Designer. – New options in the Find dialog (CTRL + F).
  • Quick navigation in the Object Navigator box in Properties dialog by pressing key in the keyboard.
  • Improved navigation on editable forms – link to parent object (e.g. in Attribute Properties dialog, see the new button Open Parent Form).
  • Drag and drop of multiple attributes in Designer.
  • Possibility to close a model when closing its last Designer.
  • PER model - New options in Designer to add all child or parent entities to WS: Fill Parent Objects, Fill Child Objects, Fill Parent and Child Objects.
  • Error in Script opens particular script. (Expert Mode enabled)
  • Help navigation - see Help buttons in dialogs.

Upgrade and Compatibility

Toad Data Modeler 3 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