SQL Migration Scripts

You can create SQL migration scripts either:

Automatically Generated Scripts

If you create them using the Migration wizard, the session ID is tagged onto the name of each script to represent the date and time you migrated the schema objects. In this case, the scripts are generated in the Log file directory that you have specified in the Options dialog box. The scripts in the log file directory are:

MwbErrors<timestamp>.sql

Contains all the SQL commands that the Migration Workbench failed to execute.

MwbCreated<timestamp>.sql

Contains all the SQL commands that were executed by the Migration Workbench, such as CREATE USER SA IDENTIFIED BY ORACLE.

MwbDrops<timestamp>.sql

Contains the associated DROP commands for the MwbCreate<session>.sql script, such as DROP USER SA CASCADE.

Manually Generated Scripts

If you generate the SQL scripts manually, they are located in the migration_scripts directory. They are overwritten each time with the latest file. The scripts in the migration_scripts directory are:

Create.sql

Contains all the SQL commands that were executed by the Migration Workbench, such as CREATE USER SA IDENTIFIED BY ORACLE.

Drop.sql

Contains the associated DROP commands for the MwbCreate<session>.sql script, such as DROP USER SA CASCADE.