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.