Call GetStructSyncOrderDetail to obtain the ticket details for schema synchronization.
Debugging
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:
|
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:
|
SourceType | String | VERSION |
The table schema type. the values and descriptions are as follows:
|
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:
|
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:
|
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.