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.

Toad Data Modeler can generate SQL scripts for you, but you need another tool to execute the generated SQL code. You can try Toad Extension for Eclipse. It is a freeware Eclipse plugin that works with Oracle.

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 11g R1 & R2
  • Oracle 10g
  • Oracle 9i
  • MySQL 5.5
  • MySQL 5.1
  • MySQL 5.0
  • Microsoft SQL Azure
  • Microsoft SQL Server 2005
  • Microsoft SQL Server 2008
  • PostgreSQL 9.0
  • PostgreSQL 8.4
  • PostgreSQL 8.3
  • PostgreSQL 8.2
  • PostgreSQL 8.1
  • DB2 v9.7
  • DB2 v9.5
  • DB2 v9
  • DB2 UDB 8
Compare two models and generate change script automatically!
SQL / DDL code generation SQL/DDL code generation

Alter script generation Alter script generation