Toad Data Modeler

Toad Data Modeler

Original author(s)	Quest Software
Type	Database modelling tools
Website	http://www.quest.com/toad-data-modeler/

Toad Data Modeler is a database design 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 in 2006.^[1] Quest Software was acquired by Dell as of September 28, 2012.^[2]

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 generate 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