Help Center/ Database and Application Migration UGO/ API Reference/ API/ SQL Statement Conversion/ Converting SQL Statements
Updated on 2026-05-16 GMT+08:00
View PDF
Share

Converting SQL Statements

Function

This API is used to convert SQL statements.

URI

POST /v1/{project_id}/sql-conversion

Table 1 URI parameters

Parameter

Mandatory

Type

Description

project_id

Yes

String

Project ID of a tenant in a region.

For details about how to obtain the project ID, see Obtaining a Project ID.

Request Parameters

Table 2 Request header parameters

Parameter

Mandatory

Type

Description

X-Auth-Token

Yes

String

User token obtained from IAM.
Table 3 Request body parameters

Parameter

Mandatory

Type

Description

source_db_type

Yes

String

Source database type.

Range

  • Oracle
  • MySQL
  • GoldenDB
  • PostgreSQL
  • Microsoft SQL Server
  • Informix
  • MariaDB
  • openGauss
  • DDM

target_db_type

Yes

String

Target database type.

Range

  • GaussDB Centralized

  • GaussDB Distributed

  • GaussDB CloudNative(Centralized)
  • GaussDB CloudNative(Distributed)

  • GaussDB Centralized(M-Compatibility)

  • GaussDB Centralized(B-Compatibility)
  • GaussDB Distributed(MySQL-Compatibility)

  • RDS for PostgreSQL

  • RDS for MySQL
  • TaurusDB

target_db_version

Yes

String

Target database version.

CAUTION:

This field must be used with target_db_type to specify the target database type and version.

  • GaussDB Centralized

    10.0, 9.0, 8.200, 8.100, 8.0, 3.3, 3.2, 3.1, 2.7

  • GaussDB Distributed

    9.0, 8.200, 8.100, 8.0, 3.3, 3.2, 3.1, 2.7

  • GaussDB CloudNative(Centralized)

    10.0

  • GaussDB CloudNative(Distributed)

    10.0

  • GaussDB Centralized(M-Compatibility)

    10.0, 9.0, 8.200, 8.100

  • GaussDB Centralized(B-Compatibility)

    10.0, 8.200, 8.100, 8.0, 3.3, 3.2, 3.1, 2.7

  • GaussDB Distributed(MySQL-Compatibility)

    10.0, 8.200, 8.100, 8.0, 3.3, 3.2, 3.1, 2.7

  • RDS for PostgreSQL

    11, 12, 13, 14, 15

  • RDS for MySQL

    5.7

  • TaurusDB

sql_statement

Yes

String

SQL statements to be converted.

Response Parameters

Status code: 200

Table 4 Response body parameters

Parameter

Type

Description

is_support_conversion

Boolean

Whether the SQL statements can be converted.

converted_sql_statement

String

Converted SQL statements.

unsupported_items

Array of Table 5 objects

Details about unsupported SQL statements.
Table 5 UnSupportedItem

Parameter

Type

Description

reason

String

Reasons why the SQL statements cannot be converted.

suggestion

String

Modification suggestions for unsupported statements.

line_number

Integer

Line number.

position

Integer

Position.

Example Request

Converting SQL statements (The source database is Oracle and the target database is RDS for PostgreSQL 11.)

POST https://{EndPoint}/v1/{project_id}/sql-conversion 
 
{ 
  "source_db_type" : "ORACLE", 
  "target_db_type" : "RDS for PostgreSQL", 
  "sql_statement" : "create table ugo(col1 int, col2 varchar2);", 
  "target_db_version" : "11" 
}

Example Response

Status code: 200

Request succeeded.

{ 
  "converted_sql_statement" : "create table ugo(col1 NUMERIC(38), col2 VARCHAR);", 
  "is_support_conversion" : true 
}

Status Codes

Status Code

Description

200

Request succeeded.

Error Codes

For details, see Error Codes.

Parent topic: SQL Statement Conversion