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.
Note:
If you are migrating tables from the Schema Viewer do not change this field. Changing the From field will clear the Schema Viewer. |
|
| To | Select the location to which you want the selected tables and/or query results migrated.
Note:
The destination location must exist in order to migrate a table to it. If it does not, you must first create it using a database management tool such as SQLWizard. |
|
| 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.
Note:
If this checkbox is selected, you cannot generate an Impact Analysis Report. |
|
| 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. Note:
When this report is selected, Migrate will not create or copy any information. The entire migration, including queries is executed step-by-step, but no tables are created and no data is written. |
|
| 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. |