For RDS for SQL Server 2012 and later versions, you can copy databases from one instance to another.

Prerequisite

The following conditions must be met:
  • The source and target instances belong to the same Alibaba Cloud account.
  • The engine versions of the source and target instances are the same. Supported versions: RDS for SQL Server 2012 and 2016. RDS for SQL Server 2008 R2 is not supported.
  • The source and target instances are in the same region (the zones can be different), and the network types must be the same.
  • The source and target instances do not have databases whose names are the same.
  • Available storage space of the target instance is larger than the size of the databases to be copied.

Background information

RDS for SQL Server completes a full backup of the source instance before it copies data from the source instance to the target instance. During the data copy process, incremental data of the source instance is not copied to the target instance.

You can choose to copy a single database or all databases in the source instance. If the copy task fails, no data is transferred to the target instance. This ensures data consistency.

Procedure

  1. Log on to the RDS console.
  2. Select the region where the target instance is located.
  3. Click the ID of the target instance.
  4. Select Databases in the left-side navigation pane.
  5. On the Databases page, click Replicate to Another Instance.
    Parameter Description
    Source Instance Name Source instance ID
    Target Instance Name

    Target instance ID

    All instances that are in the same region and have the same version as the source instance are displayed. Select a target instance. You can also use the search box to filter out your target instance.

    Databases

    Add the databases to be copied to the target instance. You can click Add or Delete to select the databases.

    If you select multiple or all databases, make sure the following conditions are met:
    • Available storage space of the target instance is larger than the size of the databases to be copied.
    • The source and target instances do not have databases whose names are the same.
    Note
    If the source and target instances have databases whose names are the same, these databases are not copied.
    Users and Authorizations

    Specify whether to copy users and permissions to the target instance.

    • Synchronize Database Users and Authorizations: This means the users and permissions of the source databases will be copied to the target instance.
      Note
      If the source instance and target instance each have a user of the same name before migration, after migration the target instance user has the combined permissions of both the users.
    • Replicate Database Only. Do Not Synchronize Users and Authorizations: This means the users and permissions of the source databases will not be copied to the target instance. This is the default option.
  6. After setting these parameters, click OK.