Toad World® Forums

Update the database

It is possible to generate a SQL script with only the changes made to the database type from version 1.00 to 1.01?

Hello there,

You can use Change Script which compares your model with another model (or database) and generates SQL script according to the differences between compared items. If you don't want your database data to be deleted when applying changes, you should enable the Use Temporary Tables to Preserve Data option in DDL Code Generation section of Generate Change Script wizard.

Regards,

Lukas