You can create SQL migration scripts either:
Automatically during the creation phase of the migration process.
Manually by choosing Action -> Generate Migration Scripts.
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.