This topic describes how to use the ApsaraDB RDS console to replicate the databases of an ApsaraDB RDS for SQL Server to another ApsaraDB RDS for SQL Server instance.

Prerequisites

Your RDS instance runs SQL Server 2008 R2 and uses standard SSDs or enhanced SSDs (ESSDs).

Note

Replicate the databases to another RDS instance

  1. Access RDS Instances, select a region at the top, and then click the ID of the target RDS instance.
  2. In the left-side navigation pane, click Databases.
  3. On the page that appears, click Replicate to Another Instance. In the Replicate to Another Instance dialog box, configure the parameters.
    Parameter Description
    Source Instance Name The name of the source RDS instance. The system automatically displays the ID of the source RDS instance.
    Target Instance Name The name of the destination RDS instance.
    Note The 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.
    Source Databases The databases that you want to replicate to the destination RDS instance. You can click the 1 or 2 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.
    • The source and destination RDS instances do not have databases whose names are the same.
    Note If the source and destination RDS instances have databases whose names are the same, these databases are not replicated.
    Source Databases Specify whether to replicate accounts and account permissions 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 the 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 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 a database for an ApsaraDB RDS instance that runs SQL Server 2008 R2.
  4. Click OK.