Help Center/ Database and Application Migration UGO/ User Guide/ SQL Statement Conversion
Updated on 2024-11-07 GMT+08:00
View PDF
Share

SQL Statement Conversion

Scenarios

You can check whether a specific SQL statement can be converted in the source and target databases and view the SQL statement after conversion.

Prerequisites

The SQL text provided for UGO must be syntactically correct, can be successfully compiled on the source database, and contains up to 100,000 characters.

Frozen accounts cannot view or modify target database types or conversion configurations.

Procedure

  1. Log in to the UGO console.
  2. In the navigation pane on the left, click SQL Conversion.
  3. Select the source and target database types and enter the SQL statements to be converted.
  4. (Optional) Click Modify Conversion Configuration to import the configuration parameters to be used. The conversion configuration in the default template is used by default.

    • You can set Parameter Configuration to Default value or Max compatibility, or import a created conversion configuration template. For details about how to create a conversion configuration template, see Creating a Configuration Template.
    • In the Current Configuration column, move the cursor to of each feature to view the impact of the feature. You can click Edit to view details about configuration information and the current configuration conversion example.
    • Locate a feature and click Edit in the Operation column to modify the current configuration of the feature, and then click OK.
    • After you import configuration parameters, the configuration status of features is Default value. If you edit the configuration of a feature, the configuration status will become Modified.
    Figure 1 Feature configuration settings

  5. Click SQL Conversion and view the converted SQL statement on the right.

    If any, the unsupported features are displayed in the Unsupported Item area in the lower right part.
    Figure 2 SQL conversion
    • You can clear SQL statements on the source end and replicated SQL statements on the target end in a few clicks.
    • For details about how to edit conversion configurations, see Editing Conversion Configurations.

  6. Enable Compare Mode (disabled by default).

    After the source SQL statement is converted, enable Compare Mode to view the source SQL statement and converted SQL statement in comparison mode. In comparison mode, the source SQL statements cannot be modified.
    Figure 3 Text comparison mode