Toad Data Modeler
Toad Data Modeler is a modeling tool allowing users to visually create (using Entity Relationship Diagrams), maintain and document new or exsiting database systems.
Features
With Toad Data Modeler you can:
- Visually create database structures (Logical and Physical Entity Relationship Diagrams - ERD)
- Create ERD for various database systems (Oracle, MS SQL, DB2 MySQL etc.)
- Reverse engineer already existing database structures and see the existing database structure in form of a diagram
- Add logical data to their diagrams and describe existing database structures better
- Verify their ERD (model) and get a list of Errors, Warnings and Hints
- Automatically generate SQL code for selected target database
- Generate detailed documentation in HTML or RTF format
- Synchronize their model with physically existing database (using Alter Script Generation and Model Merge features)
- Keep track of changes using internal Version Manager
- Create and maintain a list of tasks related to their model or particular part of a model using To-Do list feature.
- Perform their daily tasks quickly and comfortably, thanks to GUI improvements
- Customize the product accordingly to their requirements (including customization of forms) and more.
- Affect objects in ERD via internal scripting (user-defined batch rename scripts etc.)