There is an issue with the "Migrate Object" function (from the right-click menu in the Object Explorer | Tables tab), when attempting to migrate two tables.
When selecting the migration options, if the 'Include Drop Statements' option is not selected, the output script does include the 'Add Versioning' clause, which is intended for system versioning.
If the 'Include Drop Statements' option is selected, the output script does not include the 'Add Versioning' clause.
This results in inconsistency regarding the inclusion of the "Add Versioning" clause necessary for system versioning.
The generated script should consistently include the "Add Versioning" clause to ensure the creation of tables with system versioning.
WORKAROUND:
None
STATUS:
Waiting for fix in a future release of Toad for DB2
