We recently released the latest version of Toad Data Modeler (6.3) and I wanted to share with you what’s new.

As ever, we make sure we always support the latest database platforms and add new ones where there is demand. For details on all our supported platforms, click this link to see a full list.

Database Platforms

  • Aurora MySQL 5.6 – fully supports MySQL 5.6 databases operated in the Amazon Aurora cloud engine.
  • IBM DB2 11.1 – we’ve implemented changes for functions and procedures as well as adding new datatypes (BINARY, VARBINARY, BINARY VARYING, BOOLEAN).
  • Microsoft Access – we’ve added the ability to generate names in brackets as well as generation of captions. There is a new option in the DDL Script Generation options to set these values.


New Features

You can now create application variables for your relationships, check constraints and key constraints. This will ensure naming consistency during future model changes.

Application variables can be defined in the Properties dialogs for:

  • Physical Model Explorer
  • Designer
  • DDL Script and Change Script Generators
  • Reports (check the Resolve Application Variables setting in the Report Wizard options)

Changes can be viewed in the model by right-clicking a relationship and selecting Refresh Application Variables.

In Toad Data Modeler 6.3, you can now change the order in which objects are generated:

  • After each CREATE TABLE statement
  • Inside a CREATE TABLE statement

Select Model | Order of Generated Objects to set your desired order:

  • 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

Changing the order of generated objects

We’ve added some flexibility over how you can use Workspaces by enabling you to copy layouts to different workspaces in your models. This will copy all your formatting, shapes, lines as well as positions and dimensions of your database objects to another workspace.

Right-click into your Designer and select Workspace Layout | Copy Workspace Layout to to copy the layout to a different workspace.

You can also right-click and object in your model and select Copy Object Layout to to copy its specific layout to a different workspace.

Copying the layout of an entity to a different workspace


Additional Enhancements

We’ve made some enhancements to Workspaces so that you can 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.

Changing Display Mode to “Full Names”

You can now display two types of Notes for objects in your physical data model – Notes and Technical Notes. These can be applied to entities, relations, views, materialized views, inheritances, entity attributes and view relations.

Double-click an object and select Notes to fill in your notes and technical notes.

Adding notes to an entity

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 if it has been set to Disabled).

Notes hints being displayed for an Entity

For more information on Toad Data Modeler 6.3, check out the Release Notes.

Don’t forget we have a lot of information on Toad Data Modeler on our Toad Community website: Toad World. Here you can participate in discussions, download products, read blogs and view videos and get access to other related resources.

Hope you enjoy using Toad Data Modeler 6.3!

About the Author

John Pocknell

John Pocknell is a senior market strategist at Quest Software and part of the Information Management business unit. Based at the European headquarters in the U.K., John is responsible for synthesising analyst data and customer interviews in order to create and evangelise solutions-based stories and messaging which relate to major IT initiatives for our extensive portfolio of database products, worldwide. He has been with Quest Software since 2000, working in the database design, development and deployment product areas and spent over 10 years as product manager for the Toad product line. John has been successfully evangelising Toad and other database solutions at various conferences and user groups around the world for the last 19 years as well as writing blogs and technical papers both internally and for the media. John has worked in IT for more than 30 years, most of that time in Oracle application design and development. He is a qualified aeronautical engineer with more than 10 years of experience in provisioning IT consultancy services and implementing quality assurance systems to ISO 9001.

Start the discussion at forums.toadworld.com