Call GetStructSyncOrderDetail to obtain the ticket details for schema synchronization.

Debugging

OpenAPI Explorer automatically calculates the signature value. For your convenience, we recommend that you call this operation in OpenAPI Explorer. OpenAPI Explorer dynamically generates the sample code of the operation for different SDKs.

Parameters

Parameter Type Is it required? Example Description
OrderId Long No 432553

The ticket number.
Tid Long No 1

The tenant has expired.

Note The information of the tenant's chart is taken from the avatar in the upper-right corner of the system. For more information, see View tenant information .
RegionId String No cn-hangzhou

Select the service region of the destination region to call this operation. For more information about the valid values, see switchegionfigure parameter description .

Note select based on the location of the application nearby.

return data

Parameter Type Example Description
RequestId String 4E1D2B4D-3E53-4ABC-999D-1D2520B3471A

The error message returned because the request already exists.
Success Boolean true

Whether the request is successful.
ErrorMessage String UnknownError

Error message.
ErrorCode String UnknownError

Error code.
StructSyncOrderDetail object

The details of the structure synchronization ticket.
SourceDatabaseInfo object

The information about the source database.
DbId Long 432532

The library has expired.
SearchName String test

The name of the database search.
DbType String MySQL

The type of the database.
EnvType String dev

The environment type of the instance. For more information, see instance environment description .

Logic Boolean false

indicates whether the database is a logical database. Valid values:

  • true : Yes
  • false : no
TargetDatabaseInfo object

The information about the destination database.
DbId Long 432543

The library has expired.
SearchName String test

The name of the database search.
DbType String MySQL

The type of the database.
EnvType String dev

The environment type of the instance. For more information, see instance environment description .

Logic Boolean false

indicates whether the database is a logical database. Valid values:

  • true : Yes
  • false : no
SourceType String VERSION

The table schema type. the values and descriptions are as follows:

  • DATASOURCE : The latest version by default.
  • VERSION : a manually entered version history.
SourceVersionInfo object

The information of the source version.

Note only when SourceType is VERSION displayed when.
VersionId String e179bbb8163dcdcfacda24858bedb4d8006ae2b8

The version number.
TargetType String DATASOURCE

The table schema type. the values and descriptions are as follows:

  • DATASOURCE : The latest version by default.
  • VERSION : a manually entered version history.
TargetVersionInfo object

The information about the Target version.

Note only when SourceType is VERSION displayed when.
VersionId String e179bbb8163dcdcfacda24858bedb4d8006ae2b8

The version number.
TableInfoList Array of TableInfo

The information of the table to be synchronized.
SourceTableName String test_tbl

The name of the source table.
TargetTableName String test_tbl

The name of the destination table.
IgnoreError Boolean false

Specifies whether to ignore error reports. Valid values:

  • true : IGNORE. If an error occurs, the system skips the current failed execution execution execution execution script and continues the execution.
  • false : The script is not ignored. If an error occurs, the system stops running the script and stops executing the script.

Examples

Sample requests


     http(s)://dms-enterprise.aliyuncs.com/? >rder_id=432553&resourceid=1&public request parameters

Sample success responses

XML Format 


     HTTP/1.1 200 OK Content-Type:application/xml <GetStructSyncOrderDetailResponse> <RequestId>CA4E966B-1A57-4230-B0BB-CBB9CAF2CEDC</RequestId> <StructSyncOrderDetail> <SourceDatabaseInfo> <SearchName>poc_dev@rm-uxxxxx.mysql.rds.aliyuncs.com:3306</SearchName> <DbId>800000</DbId> <Logic>false</Logic> <EnvType>dev</EnvType> <DbType>mysql</DbType> </SourceDatabaseInfo> <SourceType>DATASOURCE</SourceType> <TargetType>DATASOURCE</TargetType> <IgnoreError>false</IgnoreError> <TargetDatabaseInfo> <SearchName>film@rm-uf64xxxxe.mysql.rds.aliyuncs.com:3306</SearchName> <DbId>700000</DbId> <Logic>false</Logic> <EnvType>dev</EnvType> <DbType>mysql</DbType> </TargetDatabaseInfo> <TableInfoList> <SourceTableName>*</SourceTableName> <TargetTableName>*</TargetTableName> </TableInfoList> </StructSyncOrderDetail> <Success>true</Success> </GetStructSyncOrderDetailResponse>

JSON Format 


     HTTP/1.1 200 OK Content-Type:application/json { "RequestId" : "CA4E966B-1A57-4230-B0BB-CBB9CAF2CEDC", "StructSyncOrderDetail" : { "SourceDatabaseInfo" : { "SearchName" : "poc_dev@rm-uxxxxx.mysql.rds.aliyuncs.com:3306", "DbId" : 800000, "Logic" : false, "EnvType" : "dev", "DbType" : "mysql" }, "SourceType" : "DATASOURCE", "TargetType" : "DATASOURCE", "IgnoreError" : false, "TargetDatabaseInfo" : { "SearchName" : "film@rm-uf64xxxxe.mysql.rds.aliyuncs.com:3306", "DbId" : 700000, "Logic" : false, "EnvType" : "dev", "DbType" : "mysql" }, "TableInfoList" : [ { "SourceTableName" : "*", "TargetTableName" : "*" } ] }, "Success" : true }

Error code

Access error Center For more information, see error codes.