All Products
Search
Document Center

Migrate data between databases with different names in different RDS instances

Last Updated: May 28, 2019

Scenarios

This topic describes data migration between databases with different names under different RDS instances using Data Transmission Service (DTS). This topic is based on the example of using DTS to migrate the amptest database of the source instance to the jiangliu_amptest database of the target RDS instance. You can learn how to use DTS to migrate data between databases with different names under different RDS instances.

* Note: The steps for configuring the migration remain the same when the source and target instance types are not RDS.

Prerequisites

An RDS instance with a certain database type specified and a database (the amptest database of the source RDS instance and the jiangliu_amptest database of the target RDS instance) are created.

Procedure

  1. Log on to the DTS console with the Alibaba account to which the target RDS instance belongs. Click Create Migration Task in the upper-right corner of the console to configure the task.

  2. Configure the connection information of the instances as shown in the following figure:

    Set the migration task name and configure the connection information about the source and target instances in migration. Specifically:

    • Task name

    By default, DTS generates a name for every task automatically. The task name is not required to be unique. You can modify the name. We recommend that you use an informative name that is easy to identify.

    • Connection information of the source instance

      • Instance type: Select RDS Instance.
      • RDS instance ID: Configure the ID of the source RDS instance.
      • Database account: The account for accessing the RDS instance
      • Database password: The password of the preceding database account
    • Connection information of the target instance

      • Instance type: Select RDS Instance.
      • RDS instance ID: Configure the ID of the target RDS instance.
      • Database account: The account for accessing the RDS instance
      • Database password: The password of the preceding database account

Configure the connection

3.Configure the migration type and migration objects, and select the migration database amptest. Map the amptest database of the source instance to the jiangliu_amptest database of the target RDS instance, as shown in the following figure:

2

4.To configure the database name mapping, find the selected objects list on the right, and click the Edit button that appears. Click Edit to enter the configuration page of database name mapping, as shown in the following figure:

3

5.When the configuration is complete, click Pre-check and Start as shown in the following figure. Pre-check is performed before migration tasks start:

  • Pre-check successful: Migration starts successfully.
  • Pre-check failed: Click the button after the specific check to view failure details, fix the errors accordingly, and then perform pre-check again.

4

After the pre-check is passed, you can start the migration task.

You have completed data migration between databases with different names under different RDS instances using DTS.