Introduction
Toad Data Modeler helps organizations create, maintain and document their database systems with an easy-to-use graphical interface.
With Toad Data Modeler you can:
- Create database structures visually (Logical, Universal and Physical Entity Relationship Diagrams - ERD)
- Create ERD for various target database systems (Oracle Database, SQL Server, DB2, MySQL, PostgreSQL and more, see Supported Databases)
- Reverse engineer already existing database structures and see them in a form of a diagram
- Add logical data to your diagrams and describe existing database structures better
- Verify model, get a list of Errors, Warnings and Hints and use Quick Fixes to correct issues
- Automatically generate SQL code for selected target database
- Generate detailed documentation in HTML, RTF or PDF format
- Export database structures to Microsoft Excel and edit comments, notes and other model item properties
- Synchronize models with already existing databases (using Change Script Generation and Update Model features) and much more
Benefits
Toad Data Modeler allows you to:
- Reduce errors in development
- Significantly improve your productivity
- Visualize your database structures and get better understanding of your existing databases
- Verify your work automatically
- Generate very detailed HTML, RTF or PDF reports
- Work with existing database structures
- Keep existing database structures up-to-date
Key Features
- Physical Model, Universal Model (Generic Relational Model) and Logical Model
- Support for Various Databases
- Reverse Engineering
- Version Control System (support for Apache Subversion and Git) and Internal Version Manager
- Projects for storing models and additional documentation
- SQL/DDL Script Generation
- HTML/RTF Reports (including Alter reports)
- Model Merge, Model Compare
- Model Verification
- Autolayout
- Refactoring Utility
- Automation
- Customization and Scripting
- Templates, Gallery, Default Values, Application Variables, Macros
- Undo/Redo
- To-Do List
- Zoom, Loupe, Model Overview features and many more...
Toad Data Modeler delivers increased level of efficiency, quality and comfort to all database professionals.
New in this Release
Database features
IBM DB2 LUW 11.5
- 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
- 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
- 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
Product Improvement Program
To prioritize enhancements in future releases, Toad Data Modeler collects data about the use of its different features, and periodically, this data is communicated back to us. Initially, this usage data includes an IP address. Upon its receipt at a temporary server in the U.S.A., the IP address is removed, and then the anonymous data is aggregated before it is sent to our servers in California. Our product team analyses the aggregated data to understand our user community’s preferences and common practices. This analysis influences our future releases.
No personal information is collected and you can stop participating at any time.
Freeware users are required to participate in the product improvement program and cannot reject to participate. When you insert you license key the freeware version becomes full and you might modify product improvement program settings.
To view or change your participation in the product improvement program:
- Go to Help Menu | Product Improvement Program
- Select Yes, I want to participate or No, thank you
You can review the privacy policy at https://www.quest.com/legal/privacy.aspx.
Toad World Community
Watch instructional flash movies that will guide you through great features of Toad Data Modeler, learn about tips and tricks, read how-to's, tutorials, download sample scripts and user packages, dictionary files and templates for reports, join our discussion forum and much more at: https://www.toadworld.com.
Submit Your Ideas and Suggestions
If you are already the community member, feel free to post any ideas and suggestions for new features and improvements for Toad Data Modeler.
