The Impact Analysis Report describes the schemas of the selected source and destination tables, and lists the options you have selected. You can use this report to review your specifications before you run a migration.
To create an Impact Analysis Report, select the Impact Analysis Report option in the Migrate Options dialog box before you run the migration. Type the name of the file to which you want the report written in the text-entry field next to the checkbox. If this file does not exist, Migrate creates it. If it exists, Migrate overwrites it with the new report.
When an Impact Analysis Report is selected, Migrate does not execute the migration. It simply describes what would happen if it were performed.
To view the report after it has been generated, select the Impact Analysis command on the View menu. Migrate automatically displays the last Impact Analysis file specified. To display a report other than the last one, specify the file with the Migrate command on the Options menu before you select the Impact Analysis command.
If you want to print the report once it is displayed, choose Print from the File menu.
The following is an example of an Impact Analysis Report.
IMPACT ANALYSIS REPORT
Generated: 07/09/1996
Source Destination
-------------- -------------
Location: SALES SALES
Table:
Name: CUSTOMERS CUSTOMERS
Authid: DEV001 DEV001
Database:
Tablespace:
Definition:
Migrate: Yes *
Columns: name(CHAR(20)) name(CHAR(20))
city(CHAR(20)) city(CHAR(20))
state(CHAR(2)) state(CHAR(2))
Primary Key: CKEY CKEY
Migrate: No
Columns: NAME NAME
Comments:
Migrate: No
Src Table Comment:
Dst Table Comment:
Synonyms:
Migrate: No
Privileges:
Migrate: No