Use the Run dialog box to execute the currently specified migration. It also can specify certain options for the migration before you begin, and optionally select scripts that can be executed before and/or after the migration is processed. Clicking OK in this dialog starts the migration.
The Run dialog box contains the following controls:
Migrating | Displays the source and destination of the migration. If the destination is not displayed or is incorrect, change it in the To entry box . | |
From | Displays the location of the source table(s). If you have placed tables in the Schema Viewer, this field displays the location of these tables. | |
To | Select the location to which you want the selected tables and/or query results migrated. | |
Migrate Options | Use Migrate Options to select the reports and files you want Migrate to produce. | |
Execute Migrate | Determines whether or not any data is migrated when you run a migration. When enabled, Migrate performs a normal migration. When disabled, Migrate executes the migration but does not actually copy any data to the specified destination. This lets you obtain an SQL stream without actually migrating any data. | |
Impact Analysis | Select this checkbox to generate a report that provides detailed information about the migration as it is currently specified. This report lets you analyze the effect of a migration without actually executing it. Type the name of the file to which you want the report written in the field next to the checkbox. |
|
Generate SQL | Select this checkbox if you want to save the SQL that processes your migration. 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 Analysis Report | Select this checkbox to generate a listing of the source and destination tables that are 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. |
|
Error File | Select this checkbox to record migration errors in a file. 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. |