Updated on 2024-03-08 GMT+08:00

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 > Convert Text.
  3. Select the source and target database types and enter the SQL statements to be converted.
  4. (Optional) Click SQL Conversion to import the configuration 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 View Sample to view details about the 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 click OK. For details, see Migration Configurations.
    • 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 Converting configuration

  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

  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