This software is for all developers, database designers and for all who want to create and maintain their database structures effectively. Key features include:
Entity relationship diagrams - Physical, Logical and Universal models.
Support for various databases(Oracle, Microsoft SQL Server, MySQL, PostgreSQL, DB2...)
Generation of SQL (DDL) scripts
Reverse engineering
Generation of Alter Scripts
Model Update and Model Merge
Gallery for storing frequently used parts of model
Refactoring Utility
Generation of detailed HTML and RTF documentation
Conversion from Logical to Physical model
Support for Unicode
UNDO / REDO
Modeless dialogs, user-friendly GUI
Editable forms, scriptable objects...
Entity relationship diagrams - ER diagrams
Using the graphically very well arranged Entity Relationship Diagrams (ER Diagrams) you can easily create and maintain your database structures. In your models you will have all the entities, attributes, domains, primary keys, foreign keys, constraints, relationships, indexes, descriptions, notes and other physical and logical data, laid-out in a transparent order. While creating models you will have a perfect view of all database elements.
Triggers, Procedures, Views....
Toad™ Data Modeler supports Functions, Procedures, Triggers, Views, Packages, Package bodies, Object types, Object type bodies, Sequences and Synonyms etc..