Toad Data Modeler is a database design

Database design

Database design is the process of producing a detailed data model of a database. This logical data model contains all the needed logical and physical design choices and physical storage parameters needed to generate a design in a Data Definition Language, which can then be used to create a database...

 tool allowing users to visually create, maintain and document new or existing database systems. It was previously called "CASE Studio 2" before it was acquired from Charonware by Quest Software

Quest Software

Quest Software is a computer software manufacturer headquartered in Aliso Viejo, California. Founded in 1987, Quest develops, manufactures and supports software used by Information Technology professionals in a variety of industries...

 in 2006.

Visual creation of Entity Relationship Diagrams

Toad Data Modeler allows users to draw logical, physical and universal entity relationship diagrams (ERD). This tool supports various database specific items and therefore it is necessary to select a target database system for a physical ERD.
Physical ERD can be created for:

• DB2
• Ingres
• MS Access
• MS SQL Azure
• MS SQL Server
• MySQL
• Oracle
• PostgreSQL
• Sybase ASE
• Sybase SQL Anywhere

SQL Code Generation

Complex SQL/DDL code can be generated automatically for all above mentioned database systems. It is possible to select types of objects for SQL code generation as well as define options how to generate the output.

Reverse engineering and database visualization

Existing databases can be reverse engineered and displayed in form of a diagram. For all supported database systems it is possible to select particular connection method - native connection, ODBC etc.
In addition, ER Diagrams can be created from SQL files for Oracle, Microsoft SQL Azure, Microsoft SQL Server, DB2 and MySQL databases.

Documentation

Toad Data Modeler users can generate reports in HTML, RTF or PDF format. It is also possible to genereate output based on XSL transformations - XML, TXT, CSV etc.
Pictures of ER Diagrams can be generated for HTML reports only.

Verification

Models can be verified and list of errors, warnings and hints can be displayed as a result of model verification process.

Advanced features

• Synchronization of models with physically existing database (using Alter Script Generation and Model Merge features)
• Version Manager
• Version Control System - Apache Subversion for TDM 4, integrated with Projects to achieve the best possible cooperative functionality
• Creation and maintenance of tasks related to a model or particular part of a model using To-Do list feature.
• Customization, including customization of forms
• Gallery of objects, which can be shared
• Refactoring Utility

Other features

• Support for unicode
• Undo/Redo
• Integration with Toad for Oracle
  TOAD (software)
  Toad is a software application from Quest Software used for development and administration of various relational databases using SQL.- Supported databases and environments :...
  
  

External links

• Official website
• Modeling community