The Migrate Options dialog box is used to set the default migration options that appear in the Run dialog box when you perform a migration.
The Migrate Options dialog box contains the following controls:
The
Output group box
Use this to select defaults for migration output. You can also control whether to execute the migration or not.
- Impact Analysis Report
- Sets the Impact Analysis Report as a default migration option. The Impact Analysis Report provides detailed information on the tables that will be affected by the migration as it is currently specified. This report is used to analyze the effect of a migration without actually executing it.
Attention: If this report is selected, Migrate will not migrate any information.
- Generate SQL
- Saves the SQL script file that processes your migration as a default migration option. In the field next to the checkbox, type the name of the file to which you want the SQL script written. If this file does not exist, Migrate creates it. If it exists, Migrate overwrites it with the new script.
- Post Execution Report
- Sets the Post Execution Analysis Report as a default migration option This report generates a listing of the source and destination tables that are a part of the migration. In the field next to the checkbox, type the name of the file to which you want the report written. If this file does not exist, Migrate creates it. If it exists, Migrate overwrites it with the new report.
You can specify the same file name for the Post Execution Report and the Error File to combine these two reports into one file.
Attention: If the Impact Analysis Report checkbox is selected, you can not run a Post Execution Analysis Report.
- Error File
- Sets the Error File as a default migration option. The error file records migration errors. In the field next to the checkbox, type the name of the file to which you want the report written. If this file does not exist, Migrate creates it. If it exists, Migrate overwrites it with the new report.
You can specify the same file name for the Post Execution Report and the Error File to combine these two reports into one file.
- Browse
- Use the
Browse button to view a list of filenames on your system. If you want to use an existing file for output, you can select its name from the list.
The
Input Files group box
Use this to specify SQL files to be executed during your migration.
- Prologue
- Causes Migrate to process an SQL script file before it processes the specified tables and queries. In the field next to the checkbox, type the name of the SQL script file to be used.
- Epilogue
- Causes Migrate to process an SQL script file after it processes the specified tables and queries. In the field next to the checkbox, type the name of the SQL script file to be used.
