ApsaraDB RDS:Replicate the databases of an ApsaraDB RDS instance that runs SQL Server 2008 R2

Prerequisites

Before you begin, make sure that:

• The source instance runs SQL Server 2008 R2 and uses cloud disks

• The destination instance has the same database engine version, region, and network type as the source instance (zones can differ)

• If you plan to replicate more than one database or all databases, the destination instance has enough available storage to hold all databases you plan to replicate — see Change instance specifications to expand storage

• None of the databases you plan to replicate share a name with an existing database on the destination instance — databases with conflicting names are skipped

Replicate databases to another instance

1. Go to the Instances page. In the top navigation bar, select the region where the source instance resides. Find the instance and click its ID.

2. In the left-side navigation pane, click Databases.

3. Click Replicate to Another Instance. In the Replicate to Another Instance dialog box, configure the following parameters.

   Parameter	Description
   Source Instance Name	The source RDS instance. Automatically populated with the current instance ID.
   Destination Instance Name	The destination RDS instance. The instance must meet the compatibility requirements listed in Prerequisites.
   Source Databases	The databases to replicate. Click the or icons to move databases between the available and selected lists.
   Source Databases	Controls whether database accounts and their permissions are copied to the destination instance. Choose one of the following options: Replicate Database Only. Do Not Synchronize Users and Authorizations (default) or Synchronize Database Users and Authorizations. See Create standard, privileged, and global read-only accounts,Modify the permissions of an account for details.

   

4. Click OK.

After replication completes, the copied databases appear in the Databases list of the destination instance.