Database design and SQL/DDL script generation

Using Toad™ Data Modeler database design tool, you will not only create ER diagrams and design your databases. This product IS NOT a graphical software. It gives you the opportunity to get a full control over the final SQL script, generate individual parts of your model, generate triggers, views, stored procedures, users, functions, storages, comments, referential integrity rules etc. You will also check the consistency more easily.

The automatic SQL script generation feature may save you hundreds of hours of your work.

Advanced database design

Toad™ Data Modeler gives you absolutely unique opportunity. Via the scripting, you can affect your database design and the process of SQL (DDL) code generation in full. The implemented Internal scripting allows you to include your own, additional insertions into the final SQL script.

Generation of Alter Scripts (change scripts)

Toad Data Modeler allows you to generate alter scripts for models for

  • Oracle 9i
  • Oracle 10g
  • Oracle 11g
  • MySQL 5.0
  • MySQL 5.1
  • MS SQL Server 2005
  • MS SQL Server 2008
  • PostgreSQL 8.1
  • PostgreSQL 8.2
  • PostgreSQL 8.3
  • DB2 UDB 8
  • DB2 v9
  • DB2 v9.5
Compare two models and generate change script automatically!
SQL / DDL code generation SQL/DDL code generation

Alter script generation Alter script generation