To add SQL to a migration

Migrate gives you two ways to incorporate additional SQL in a migration.

• You can execute a "prologue script" script before the migration to perform preparatory operations such as location creation and table initialization. A prologue script can be any batch SQL file containing valid SQL statements.

  To include a prologue script, select the Prologue option in the Migrate Options dialog box when you execute the migration. In the text box next to this option, specify the name of the SQL file that you want Migrate to run.

• You can execute an "epilogue script" script after the migration to perform "housekeeping" operations such as dropping temporary tables or creating an index. An epilogue script can be any batch SQL file containing valid SQL statements.

  To execute an epilogue script, select the Epilogue option in the Migrate Options dialog box when you execute the migration. In the text box next to this option, specify the name of the SQL file that you want Migrate to run.

  Note:

  Prologue and Epilogue SQL statements are executed against the destination location.