edit-icon download-icon

Create a data migration task

Last Updated: Dec 19, 2017

This document describes how to perform data migration in the DTS console. An example of data migration from MySQL to RDS for MySQL is used to explain 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, you must create the target RDS database in 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, numbers, underscore (_), or hyphen (-). It must start with a letter and end with a letter or number.

  • Create migration accounts.

    To create a migration task, you must 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 information, see the corresponding documents in the DTS User Guide. For example,

Procedure

Follow these steps to configure a migration task.

  1. Log on to the Alibaba Cloud DTS console.

  2. Click Data migration in the left-side navigation pane.

  3. Click Create migration task.

  4. Configure the Source endpoint and target endpoint.

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

    • Source database

      ParameterDescription
      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.
      PortSelect the MySQL database listener port.
      Database accountEnter the MySQL database account name.
      Database passwordEnter the MySQL database account password.
      Select the Connection method (Non-encrypted connection or SSL secure connection) , and then click Test the connection to verify the input contents.

    • Target database

      ParameterDescription
      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.

  5. Configure Migration type and migration objects.

    • 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: include database, table, and column.

      Note: By default, the object names are the same as in the source and target database. To use the object name mapping function, see Object name mapping.

  6. 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 view the reason and solution.

    Troubleshoot the issues and perform pre-check again until the pre-check is successful.

  7. After the pre-check passes, 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.