Chat now with support
Chat with Support

Toad Data Modeler 6.3 - Release Notes

Release Notes

Toad® Data Modeler 6.3

Toad® Data Modeler 6.3

Release Notes

Monday, September 11, 2017

These release notes provide information about the Toad® Data Modeler release.

About Toad Data Modeler

Toad Data Modeler helps organizations create, maintain and document their database systems with an easy-to-use graphical interface into new or existing database structures. Toad Data Modeler enables users to reverse engineer database structures, update models, design and generate SQL, compare models and generate alter scripts, create HTML or RTF reports, in addition to versioning of database designs and creation of to-do lists.

Toad Data Modeler 6.3 is a minor release, with enhanced features and functionality. See New features and Resolved issues for more information.

Toad Data Modeler is released in 32-bit and 64-bit versions. The 64-bit version of the application has a significantly higher memory limit which should resolve several common issues incl. out of memory errors, which occurred when working with complex models.

However, in order to reverse engineer databases that require a client you need a corresponding version of the client, i.e. 32-bit or 64-bit.

New Features

Release Notes > New Features

New in Toad Data Modeler 6.3

General features

Application Variables

  • Application variables in Names/Captions are now fully supported for relationships, check constraints and key constraints in Physical Model Explorer, Designer, DDL Script and Change Script Generators, and in Reports
  • Set your application variables in Properties dialogs
  • Check Resolve Application Variables in Report Wizard | Options to use variables in Report Generation
  • Right-click a relationship in Model Explorer and select Refresh Application Variables to reload any changes

Relationship Order

  • From Toad Data Modeler 6.3 it is now possible to generate relations also:
    • After each CREATE TABLE statement
    • Inside CREATE TABLE statement
  • Select Model | Order of Generated Objects to set the desired order of entities:
    • Move Parent Entity before Child Entity - lists each parent entity before their respective child entities
    • Move Child Entity after Parent Entity - lists all child entities after their parent entities

Workspace Layout Copy

  • With Toad Data Modeler 6.3 you can easily copy layouts to different workspaces in your models
  • You can copy all formatting, shapes, lines and positions and dimensions of database objects to another workspace
  • Right-click into your Designer and select Workspace Layout | Copy Workspace Layout to to copy the layout into a different workspace
  • Right-click an object in your model and select Copy Object Layout to to copy its specific layout to a different workspace

Database features

For more information on supported databases see the list of Supported database platforms

Support for Aurora MySQL 5.6

  • Toad Data Modeler 6.3 now fully supports MySQL 5.6 databases operated in the cloud engine Amazon Aurora

Support for IBM DB2 11.1

  • Toad Data Modeler 6.3 now supports the latest IBM DB2 11.1
  • Changes for functions and procedures have been implemented
  • New datatypes (BINARY, VARBINARY, BINARY VARYING, BOOLEAN) have been implemented

Microsoft Access Enhancements

Generation of names in brackets

  • Check Delimited Identifiers in DDL Script Generation | Detail Settings to generate all names in brackets
  • If unchecked names will be generated without brackets with exception of names that include spaces

Generation of captions

  • Check Generate Captions in DDL Script Generation | Detail Settings for MS Access models


Workspace Enhancements

  • In order to distinguish between similarly named entities full names can now be displayed in Workspace Properties. Select what you want to display in View | Display Mode or using the main Display toolbar in Toad Data Modeler:

Display of Short Notes in Designer

  • You now can use two types of Notes for objects in your models
  • For entities, relations, view, materialized views, inheritances, entity attributes and view relations you can use Notes and Technical Notes for physical models
  • Double-click an object and select Notes to fill in your notes and technical notes

  • You can control what is displayed in a popup hint in both physical and logical models in Designer in Settings | Options | Graphics

  • When you hover over an object header you will see a note, technical note or nothing in case it has been set to Disabled

  • Double-click an entity, relation, inheritance or entity attribute to set Descriptions and Technical Descriptions in logical models

Line Breaking for Descriptions in Logical Models

  • You now can set maximum width for Descriptions in Designer. Names of longer descriptions are broken into multiple lines
  • Select Descriptions in Settings | Options | Logical Model | Entity in order to display them in Designer and adjust their maximum width in pixels

Change Script Generation Enhancements

  • Uncheck Grant Option in Generate Change Script | Select Object Types | Detailed Settings | Permissions to Objects to omit generation of Grants

Resolved Issues

Release Notes > Resolved Issues

The following is a list of issues addressed in this release.

Resolved Issue Issue ID
Renaming non TDM files in Application now functions correctly 3472
You now can uncheck Grant Option in Generate Change Script | Select Object Types | Detailed Settings | Permissions to Objects in order not to generate grants to objects 1468
Application Variables are now supported for Default Constraint Name for MS SQL Server and MS SQL Azure Database. It is now possible to enter Default Constraint Name for Domains or use Application Variables 3137
Application Variables are now supported for NotNull Constraint Names in Oracle models 2369
It is now possible to un/check Generate Captions in DDL Script Generation | Detail Settings for MS Access models 2816
Child entities will not inherit autoincrement property of Attribute when autoincrement property has been set for their parent entities in MySQL models 3028/3914979-1
Varchar data type was changed to character varying (n) for PostgreSQL models 9.1 and higher 3144/3964938-1
Full names of entities can now be displayed in Workspace Properties 3448
Fit to Screen now works correctly 3514/4092720-1
It is now possible to generate brackets for all MS Access names 3253
Short notes can now be displayed in Designer 3456/4076973-1
Long entity descriptions are now broken into multiple lines for logical models 3334
Saving in Actions dialog has been improved 3303
Date fields in ToDo list are now sorted correctly 3513/4091031-1
Removal of shortcuts during uninstallation of TDM now works as expected 1501
Added support for Windows Server 2016 2939/3876391-1
Generation of NULL statements in column definitions in SAP ASE now works correctly 3583/4103589-1
Reverse Engineering of Sequences in PostgreSQL now works correctly 3520/4092742-1
It is now possible to copy layouts to other models 3216/4011390-1
Performance of TDM when copying objects in Workspace was improved 3308
Display of TDM at high DPIs was improved 3249/4037301-1
DDL script generation on MySQL with primary keys when domains are used now works correctly 3427/3905031-1

Known Issues

Release Notes > Known Issues

The following is a list of issues, including those attributed to third-party products, known to exist at the time of release.

Issue Issue ID
PEREntityPG92 record in Reference Guide is not correct TDM-3351
Self Service Tools
Knowledge Base
Notifications & Alerts
Product Support
Software Downloads
Technical Documentation
User Forums
Video Tutorials
RSS Feed
Contact Us
Licensing Assistance
Technical Support
View All
Related Documents