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
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
Compare two models and generate change script automatically!
- 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