Verifying the Migration Result

Prerequisites

There is a project for which migration has been completed.

Procedure

Log in to the UGO console.
In the navigation pane, choose Schema Migration > Object Migration. The migration project list is displayed.
Locate the project to be migrated and click Migrate in the Operation column. On the displayed page, click the Migration & Verification tab.
The Migration tab page is displayed by default.
Figure 1 Going to the migration tab page
- Click Migration Verification to set the migration process. This parameter can be set only when the migration task is in the Pending, The migration is being paused, or Migration Succeeded state.
- The detailed information about the migration project is displayed, including object types, total objects, objects that have been migrated, objects that failed to be migrated, and objects that have not been migrated. If objects that failed to be converted will not be migrated, Objects Not Migrated upon Conversion Failure is also displayed.
- If the migration fails, click Details in the Operation column to go to the Object Correction page and view migration details of the object type.
- View Empty Stored Procedure: If the source database type is Oracle, you can view objects that fail to be created and failure occurrences.
- Click Download Reports, locate the required report, and click Download to download the report to the local PC for analysis. Data related to sub-objects is not included in the migration report.
  - Migration statistical report: This report includes a summary of object statuses during migration and verification.
  - Migration error report: This report includes failure details, such as statuses, migrated statements, and error details for each object.
  - Anonymized error report: This report consists of failure details, such as statuses, migrated statements, and error details for each object, but the original and migrated SQL statements will be anonymized.
  - Full migration report: This report includes failure details, such as statuses, migrated statements, and error details for each object.
Click Migration History.

Detailed information of the migrated projects is displayed in the descending order. The information includes the serial number, total count, migration succeed, migration failed.
Figure 2 Migration history
Click Details to view information such as the total count, migration succeed, and migration failed.
Locate an object type and click Details to view its details. The detailed information includes the schema, object name, object types, and migration status. You can search for an object by name or view details about each schema.

Figure 3 Object type details
Locate an object and click Details to view the code.

Figure 4 Object details