Enahncement on DDL Script Generation


I am wondering if possible to provide another features on DDL Script Generation, to generate ALTER script if table already exist, so that once the user want to update their database, they could use Toad Date Modeler to modified the model and then generate the script for latest model for it.

Please let me know if you want me to explain mroe.

Many thanks


Hi Chi,
You can do this using Model>Alter Scripting , Merge Models… menuitem.

Yes, that’s right.
Just a note: At the moment, TDM3 allows you to generate alter scripts for Oracle models only. We will add alter script support for other databases gradually.

Concerning forward engineering of generated alter script for Oracle models, integration with Toad for Oracle is planned.