Toad World® Forums

Toad DB2 Schema Compare - Preserve Data method

During the May 24th Toad DB2 webcast, a question was asked regarding how to change the Schema Compare option to use Export\Import instead of temporary tables for the Data Preservation method.

The 'Preserve Data Method' option is found under Tools | Options | Database | DB2 | Advanced Admin as shown in the Options Screenshot.

When the 'Use commands/utilities' option is set, scripts generated in the Schema Compare feature will not use temporary tables, but Export and Import commands will be generated to preserve data, as shown in the generated script screenshot.
Note that the 'Preserve Data Method' also controls how data is preserved during 'extended alters'.

I hope this helps.