New in Toad Data Modeler
Version 7.2
IBM DB2 LUW 11.5 is now supported
Database settings are placed in Settings | Options | Model | Physical Model | DB2 | DB2 v.11.5 (LUW)
Reverse Engineering from a database and SQL file, Change Script and DDL Generation are supported
NOTE: Reverse engineering from a SQL file is currently supported at the level of DB2 11.1.
Microsoft SQL Server 2019 is now fully supported
Database settings are placed in Settings | Options | Model | Physical Model | Microsoft SQL Server | Microsoft SQL Server 2019
Reverse Engineering from a database and SQL file, Change Script and DDL Generation are supported
Microsoft Access 2019 and Office 365
Toad Data Modeler now support Microsoft Access 2007 up to 2019, including the version supplied with Microsoft Office 365
PostgreSQL 12 is now fully supported
Database settings are placed in Settings | Options | Model | Physical Model | PostgreSQL | PostgreSQL 12
Reverse Engineering from a database and SQL file, Change Script and DDL Generation are supported
version 7.1
Oracle 19c is now fully supported
- Database settings are placed in Settings | Options | Model | Physical Model | Oracle | Oracle 19c
- Reverse Engineering, Change Script, and DDL Script Generation are supported
PostgreSQL 11 is now fully supported
- Database settings are placed in Settings | Options | Model | Physical Model | PostgreSQL | PostgreSQL 11
- Reverse Engineering, Change Script, and DDL Script Generation are supported
version 7.0
General features
Model Explorer
• It is now possible to use Ctrl + C to copy and Ctrl + V to paste in Model Explorer
Support for Not Null value in IDEF1X notation
• Select IDEF1X in View | Notation
• Optional attributes that are not null and not part of a primary key are now displayed when IDEF1X notation is used
Database features
Support for Oracle 18c
• Support for Reverse Engineering from a SQL/DDL file has been enhanced
Support for MySQL 8.0
• MySQL 8.0 is now fully supported. Toad Data Modeler supports MySQL 8.0.13 and newer
• Database settings are placed in Settings | Options | Model | Physical Model | MySQL | MySQL 8.0
• Reverse Engineering from a database and SQL file, Change Script, and DDL Script Generation are supported
• Management of users and roles has been enhanced
• Design and layout of Attribute properties has been improved
• New verification tests have been added
Support for Amazon Aurora PostgreSQL 9.5
• Support for Reverse Engineering from a SQL/DDL file has been added