Export Summary Report File

The Export Summary Report, which is created after you have performed a compare or specified criteria, displays the details of the data that is to be migrated. The report allows you to verify the details after you have filtered the records for migration or export, and before you run the migration or create the export file. You can filter the records and then regenerate and view the Export Summary Report over and over again until you are satisfied with the data that you have selected to migrate.

The Export Summary Report contains the following details, grouped by table:

  • Any Inserts (I), Updates (U), and Deletes (D) that will be made to the destination database
  • Field names and the resulting field values, when applicable.

For example, if the source database was TEST and the destination database was PROD, using the following Export Summary Report information, we can conclude the following:

  • In the CALC_GROUP table, CALC GROUP1... CALC GROUP5 will be deleted from the PROD database because they do not exist in the TEST database.
  • In the CALC_GROUP_HISTORY table, [CALC GROUP1, 10001]... [CALC GROUP5, 10005] will be deleted from the PROD database because they do not exist in the TEST database.
  • In the CALC_GROUP_RATE table, CALC GROUP1... CALC GROUP5 will be deleted from the PROD database because they do not exist in the TEST database.
  • In the CALC_GROUP table, [TEST, CALC GROUP1, 1900-01-01 00:00:00.0]... [TEST, CALC GROUP5, 1900-01-01 00:00:00.0]will be deleted from the PROD database because they do not exist in the TEST database.
  • In the CALC_GROUP_VERSION table, 10001... 10005 will be deleted from the PROD database because they do not exist in the TEST database.

How you access the Export Summary Report depends on which mode you are in: If you are in Compare Mode, click View Migration Summary from the Compare Mode - Select Differences page; and if you are in Specify Criteria Mode, click View Export Summary from the Specify Mode - Select Migration Records page.

The Export Summary Report page contains two buttons: the Save button enables you to save the report in HTML format; and the Print button, which enables you to print the report.