Help Center/ Database and Application Migration UGO/ User Guide/ Object Migration/ Object Migration Implementation/ Converting Syntax
Updated on 2024-11-07 GMT+08:00
View PDF
Share

Converting Syntax

Procedure

  1. Log in to the UGO console.
  2. In the navigation pane, choose Schema Migration > Object Migration. The migration project list is displayed.
  3. Locate the project to be migrated and click Migrate in the Operation column. Click the Syntax Conversion tab.
  4. Click Start to start the conversion.
  5. Before the conversion is complete, click Pause to pause the conversion. Click Resume to continue the conversion.
  6. After the conversion is complete, click Download Reports. Locate the required report and click Download to download the report to the local PC for analysis.

    • Conversion Error Report: This report contains details about source database objects whose syntax could not be converted to syntax compatible with the target database.
    • Anonymized Conversion Error Report: This report contains details about anonymous source database objects whose syntax could not be converted to syntax compatible with the target database.
    • Conversion Risk Report: This report contains details about objects converted with risks based on configurations. However, there are function differences after the conversion.
    • Anonymized Conversion Risk Report: This report contains details about anonymous objects converted with risks. However, there are function differences after the conversion.
    • Converted SQL Parsing Failure Report: This report contains details about source database objects that could not be parsed using the conversion script for the target database syntax.
    • Anonymous Converted SQL Parsing Failure Report: This report contains details about anonymous source database objects that could not be parsed using the conversion script for the target database syntax.
    • Locate an object type that failed to be converted, and click Details in the Operation column to go to the Object Correction page to view details.

Viewing Syntax Conversion History

  1. Log in to the UGO console.
  2. In the navigation pane, choose Schema Migration > Object Migration. The migration project list is displayed.
  3. Locate the project to be migrated and click Migrate in the Operation column. On the displayed page, click the Syntax Conversion tab.
  4. Click Conversion History.

    The conversion information is displayed in chronological order.
    Figure 1 Conversion history

  5. Click Details to view information such as the object type, conversion plan, and conversion status (successful or failed).

    Figure 2 Conversion details

  6. Locate an object type and click Details to view its details, including the schema, object name, migration status, and conversion status. You can search for an object by name or view details about each schema.

    Figure 3 Object type details

  7. Locate an object and click Details to view the code.

    Figure 4 Object details