This topic describes how to replicate the databases of an existing ApsaraDB RDS for SQL Server instance to another RDS instance in the ApsaraDB RDS console.
Prerequisites
Your RDS instance runs SQL Server 2008 R2 and uses cloud disks.
You can replicate the databases of an RDS instance that runs SQL Server 2008 R2 and uses cloud disks only to another RDS instance. For more information, see Replicate the databases to another RDS instance that runs SQL Server 2008 R2 with cloud disks.
You can only execute SQL statements to replicate the databases of an RDS instance that runs SQL Server 2012 or later. For more information, see Replicate a database of an ApsaraDB RDS instance that runs SQL Server 2012 or later.
Replicate databases to another RDS instance that runs Server 2008 R2 with cloud disks
Go to the Instances page. In the top navigation bar, select the region in which the RDS instance resides. Then, find the RDS instance and click the ID of the instance.
In the left-side navigation pane, click Databases.
On the page that appears, click Replicate to Another Instance. In the Replicate to Another Instance dialog box, configure the following parameters.
Parameter
Description
Source Instance Name
The name of the source RDS instance. The system automatically displays the ID of the source RDS instance.
Destination Instance Name
The name of the destination RDS instance.
NoteThe database engine version, region, and network type of the source RDS instance must be the same as those of the destination RDS instance. The zones of the source and destination RDS instances can be different. For more information, see Network types.
Source Databases
The databases that you want to replicate to the destination RDS instance. You can click the
or 
icon to manage the databases. If you select more than one database or all databases, make sure that the following conditions are met: The available storage of the destination RDS instance is larger than the size of the databases that you want to replicate from the source RDS instance. For more information about how to expand the storage capacity, see Change instance specifications.
The names of the databases on the destination RDS instance cannot be the same as the names of the databases that you want to replicate.
NoteIf you create databases that have the same names as the databases that you want to replicate on the destination RDS instance, the databases are not replicated.
Source Databases
Specifies whether to replicate accounts and account permissions for the databases that you want to replicate to the destination RDS instance.
Synchronize Database Users and Authorizations: Accounts and account permissions are replicated to the destination RDS instance. Take note of the following two scenarios:
If the destination RDS instance has accounts whose usernames are the same as those of accounts on the source RDS instance, the accounts on the destination RDS instance are granted the same permissions as the accounts on the source RDS instance.
If the destination RDS instance does not have accounts whose usernames are the same as those of accounts on the source RDS instance, the accounts are created on the destination RDS instance and then granted the same permissions as the accounts on the source RDS instance.
Replicate Database Only. Do Not Synchronize Users and Authorizations: Accounts and account permissions are not replicated to the destination RDS instance. This option is the default value.
After the replication is complete, you can create accounts on the destination RDS instance and grant permissions on the selected databases. For more information, see Create an account and Modify the permissions of an account.
Click OK.