Toad Data Modeler

Design new database structures using Logical or Physical entity relationship diagrams

Create basic objects and model inheritance in logical model

Define settings for conversion from logical to physical model

Add entities, relationships and views to your diagrams

Define other database specific items like Procedures, Triggesr, Domains, Sequences…

Categorize entities and/or divide large models to smaller parts

Define properties of Entities, Attributes and Relationships comfortably

Propagate foreign key attributes to child entities automatically

Change or modify settings and let the tool to update data in child entities

Define database specific objects

Create Functions, Procedures, Sequences…

Verify your model

Generate a list of errors, warnings and hints

Define types of objects for SQL code generation

Define settings how to generate SQL code

Select entities and other objects and generate SQL code automatically

Connect to already existing database system

Reverse engineer database structure and visualize it or

Import and visualize SQL file (some databases only)

Select report type

Choose layout and design

Define options for report generation

Document your database structure

HTML/RTF/PDF formats are available

Compare two models

Merge two models

Convert model from one target database to another system

Generate change scripts (Alter Scripts)

Keep track of changes using subversion

Group models into projects

Store frequently used part of models to Gallery

Rename objects and use Refactoring Utility to change properties of other objects, e.g. Stored procedures, views etc.

Customize forms

Reposition existing items

Create new textboxes, checkboxes and customize the application