1. Purchase a DTS Migration Instance
For information about how to purchase a DTS instance, see Purchasing a Data Migration Instance.
Configure your DTS migration instance based on the following description:
Select Data migration as the instance type, select Public EIP as the network type and select the purchased public EIP, specify MySQL as the database type, and select an RDS MySQL instance as the destination database instance.
2. Configure the DTS instance
After a DTS instance is created, it is in the To be configured status. Click Configuration.
3. Configure the source and destination databases.
Configure information about the source and destination databases, including the database types, IP addresses, ports, database accounts, and passwords.
You can select SSL-encrypted connection as the connection type. In this case, you need to upload the required certificates.
After you enter all required information about the source and destination databases, you can perform a connectivity test to check whether the databases can be connected.
4. Select the objects that you want to migrate
After you configure the source and destination databases, click Test Connectivity and Proceed. On the Configure Objects and Advanced Settings page that appears, select the objects that you want to migrate.
Configuration description:
| Configuration | Description |
|---|---|
| Step | To perform only full data migration, select Struct Migration and Full Data Migration. To migrate data without service downtime, select Struct Migration, Full Data Migration, and Incremental Data Migration. Note: If Incremental Data Migration is not selected, to ensure data consistency and proper task running, do not perform DML and DDL operations on the source database instance during data migration. |
| Migration Objects | If the source database is a MySQL database, you can select tables, views, functions, and stored procedures as the objects to be migrated. Select the objects that you want to migrate in the left-side multi-select box and click the  > icon to move the objects to the right-side box. You can also click the < icon to remove an object from the right-side box.If you select the database-level object instead of some specific objects in the source database, DTS migrates the entire database. During subsequent incremental data migration, you can add new tables to the source database, and the newly added tables will also be migrated to the destination database. However, other types of newly added objects cannot be migrated during incremental migration. |
| Configuring name mapping | DTS supports database name mapping, table name mapping, and column name mapping. To change the name of an object in the destination instance, such as the destination database name or a table or column name, locate the object and click Edit. To change object names in the destination instance in a batch, click Batch Edit in the upper right corner of the right-side box. Note: If a migration task includes only structure migration and full data migration, you can configure column name mapping. If the task includes incremental data migration, you cannot configure column name mapping. A table name can contain a maximum of 64 characters and can contain only letters, digits, and underscores (_). |
| Filtering the data to be migrated | You can set a WHERE condition to filter data. The WHERE clause can contain single quotation marks (') and cannot contain semicolons (;) or two consecutive hyphens (--). DTS migrates only data that meets the WHERE condition to the destination database. |
| DML operations for incremental data migration | Configure DML operations for incremental data migration: 1. Select an object that you need to migrate. 2. Click Edit. 3. In the pop-up window, select the DML operations for incremental data migration. If you configure DML operations for both the database and table levels, the table-level settings overwrite the database-level settings. |
| DDL operations for incremental data migration | For incremental data migration, only the following DDL statements are supported: CREATE INDEX, DROP INDEX, ALTER TABLE, and DROP TABLE. For database-level migration/synchronization, CREATE TABLE is supported. |
| Start Task as Scheduled | Specify the point in time at which your migration task starts. |
5. Precheck and start the task.
Click Next: Precheck. The system checks the items listed on the Precheck page and provides check results. You can perform subsequent operations based on the check results.
If the precheck is passed, click Start Migration to start data migration.
6. Managing a Task
For information about how to view migration progress, see Viewing Migration Progress.
For information about how to view a migration log, see Viewing a Migration Log.