Migrates data across ApsaraDB RDS for SQL Server instances.
Operation description
Supported database engine
- SQL Server
Description
We recommend that you use Data Transmission Service (DTS). DTS provides data migration, subscription, and synchronization features that allow you to establish stable, secure transmission links. For more information, see DTS API overview.
Precautions
-
During the migration, the source instance is in the Migrating state, and the destination instance is in the Importing state.
-
Before you call this operation, make sure that the following conditions are met:
- The source and destination instances must run SQL Server and belong to the dedicated or dedicated host instance family. For more information about the supported instance types, see Primary instance types.
- The source and destination instances must be created by using the same user.
- The instance is in the Running state.
- The source and destination databases must be in the Running state.
- The remaining storage of the destination instance must be greater than the storage capacity of the source instance.
Debugging
Authorization information
Request parameters
Parameter | Type | Required | Description | Example |
---|---|---|---|---|
DBInstanceId | string | Yes | The ID of the instance. | rm-uf6wjk5xxxxxxx |
SourceDBInstanceId | string | Yes | The ID of the source instance, which cannot be the same as the ID of the destination instance. | rm-g4a1jk8xxxxxxx |
DBInfo | string | Yes | The names of the source and destination databases. The value of this parameter is a JSON string. Note
If the source instance runs SQL Server, the value of this parameter consists of one or more key-value pairs. In each key-value pair, the key specifies the name of the source database, and the value specifies the name of the destination database. A source database can have a different name from the destination database. For example, {"DBNames":{"srcdb":"destdb","srcdb2":"destmydb2"}} indicates that srcdb is migrated to destdb and srcdb2 is migrated to destmydb2. The names of source databases cannot be the same, and the names of destination databases cannot be the same.
| {"DBNames":["mydb","mydb2"]} |
Response parameters
Examples
Sample success responses
JSON
format
{
"ImportId": "852654*****",
"RequestId": "5A77D650-27A1-4E08-AD9E-59008EDB6927"
}
Error codes
For a list of error codes, visit the Service error codes.
Change history
Change time | Summary of changes | Operation | ||
---|---|---|---|---|
2022-06-23 | API Description Update | see changesets | ||
|