Toad™ Data Modeler 3 - database design tool

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 - both Physical and Logical modeling (incl. inheritance)
  • Support for various databases (Oracle, MS SQL Server, MySQL, Sybase Ase, PostgreSQL, DB2)
  • Generation of SQL (DDL) scripts
  • Reverse engineering
  • Generation of Alter Scripts
    • Oracle 9i
    • Oracle 10g
    • Oracle 11g R1 & R2
    • MySQL 5.0
    • MySQL 5.1
    • MS SQL Server 2005
    • MS SQL Server 2008
    • PostgreSQL 8.1
    • PostgreSQL 8.2
    • PostgreSQL 8.3
    • PostgreSQL 8.4
    • DB2 UDB 8
    • DB2 v9 and
    • DB2 v9.5 (LUW)
    • DB2 v9.7 (LUW)
  • Model Update and Model Merge
  • 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..



Physical ERD Physical ERD

Logical ERD Logical ERD

Modeless dialogs Modeless dialogs

In-place editing In-place editing

Loupe and Overview panes Loupe and Overview panes

Changeable notation Changeable notation