All Products
Search

This Product

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

    Document Center

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

    Last Updated:Mar 28, 2026

    Copy one or more databases from an ApsaraDB RDS for SQL Server 2008 R2 instance to another RDS instance using the console.

    This console-based replication method applies only to RDS instances that run SQL Server 2008 R2 and use cloud disks. To replicate databases on an instance running SQL Server 2012 or later, see Replicate a database of an ApsaraDB RDS instance that runs SQL Server 2012 or later.

    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.

      ParameterDescription
      Source Instance NameThe source RDS instance. Automatically populated with the current instance ID.
      Destination Instance NameThe destination RDS instance. The instance must meet the compatibility requirements listed in Prerequisites.
      Source DatabasesThe databases to replicate. Click the 右移 or 左移 icons to move databases between the available and selected lists.
      Source DatabasesControls 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 Account synchronization options for details.

      Replicate to Another Instance dialog box

    4. Click OK.

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

    Account synchronization options

    The account synchronization setting determines whether database accounts and their permissions are copied alongside the databases.

    OptionBehavior
    Replicate Database Only. Do Not Synchronize Users and Authorizations (default)Only the database schema and data are copied. After replication, create accounts on the destination instance and grant the required permissions.
    Synchronize Database Users and AuthorizationsAccounts and permissions are also copied. If an account with the same username already exists on the destination, it is granted the same permissions as the source account. If no matching account exists, it is created and granted the source account's permissions.

    What to do next

    • Verify that the databases were replicated correctly by connecting to the destination instance and checking the database contents.

    • If you used the default account synchronization option, create accounts on the destination instance, then grant the appropriate permissions on each database.