Create a data migration task

Last Updated: Nov 10, 2017

This section introduces how to perform data migration on the DTS console.

An example of data migration from MySQL to RDS for MySQL is used to illustrate the procedure. Other storage engines follow a similar procedure.

Prerequisites

  • Create a target RDS database

    During data migration, if the database to be migrated is not defined in the target RDS instance, DTS automatically creates it. In some cases where the database name does not comply with the RDS Definition Standard, create the target RDS database on the RDS console before configuring the migration task.

    The RDS Definition Standard states the RDS database name can be up to 64 characters in length and consist of lowercase letters, digits, underscore (_), or hyphen (-). It must start with a letter and end with a letter or digit.

  • Create migration accounts

    To create a migration task, first provide the migration accounts of the source instance and the target RDS instance. For different storage engines, specific database access privileges are also required. For more details, refer to the corresponding documents in the DTS User Guide. For example,

Procedure

With the target RDS database prepared and migration account created, start with configuring the migration task.

  1. Log on to the Alibaba Cloud DTS console, and enter the Data Migration page.

  2. Click Create Migration Task on the top right corner.

  3. Configure the Source endpoint and target endpoint.

    • Task Name: By default, DTS automatically generates a name for the migration task. You can edit the name according to your business requirements.

    • Source Database information: The specific parameters are listed as follows:

      ParameterAction
      Instance TypeSelect On-premises databases.
      Instance RegionSelect the region in closest geographic proximity to the source instance.
      Database EngineSelect MySQL.
      Host Name or IP AddressEnter the MySQL database connection string.
      PortEnter the MySQL database listener port.
      Database AccountEnter the MySQL database account name.
      Database PasswordEnter the MySQL database account password.
      Select a Connection Method from Non-encrypted Connection or SSL Secure Connection, and then click Test the Connection to verify the input contents.

    • Target Database information: The specific parameters are listed as follows:

      ParameterAction
      Instance TypeSelect RDS Instance.
      Instance RegionSelect the region of the RDS instance.
      RDS Instance IDSelect the target RDS instance ID.
      Database AccountEnter the access account name of the RDS instance database.
      Database PasswordEnter the access account password of the RDS instance database.
      Click Test the connection to verify the input contents.

  4. Configure Migration type and migration objects.

    • Migration Type: The migration type includes Schema migration, Existing data migration, and Incremental replication.

      • For existing data migration, select schema migration and existing data migration.
      • For zero downtime data migration, select schema migration, existing data migration, and incremental replication.
    • Migration Objects: The migration objects include database, table, and column.

      • By default, the object names are the same as in the source and target database.
      • To use the object name mapping function provided by DTS, refer to Object name mapping.
  5. Perform Pre-check before the migration task is started.

    • If the pre-check fails, click Failed to check the details of the failed items.
    • Click View to look up the reason and solution. Troubleshoot the issues and continue to perform pre-check until the pre-check is successful.
  6. Start the migration task.

    After the pre-check passes, you can start the migration task. When the task is started, you can view the migration status and progress in the task list.

Thank you! We've received your feedback.