Preparations
You need to have the permissions of the source database, including RELOAD, PROCESS, REPLICATION SLAVE, LOCK TABLES, REPLICATION CLIENT, SHOW DATABASE, EVENT, and SELECT.
If you want to migrate views in the source database, you also need to have the SHOW VIEW permission.
Directions
1. Create a migration task
(1) Log in to the DTS console and click Create Migration Task on the data migration page.
(2) On the Create Migration Task page, select the types and regions of the source and target databases and click Buy Now. Note:
Select the region with caution as it cannot be changed once the migration task is created.
2. Set the source and target databases
Enter the information of the task, source database, and target database.
Task settings
Enter the name of the migration task. If you want the migration task to be executed at a later time, you can set scheduled execution.
Source database settings
Enter the source database information and click Test Connectivity to check whether the source database can be connected.
Target database settings
Enter the target database information and click Save.
3. Select the type and databases/tables
Select the type and database list and click Next step: verify task.
4. Verify the task
Check whether the source instance runs normally and whether the sets to be migrated to the target instance are in conflicts.
5. Complete the migration
After the verification is passed, return to the migration task list. After the incremental sync is 90% complete, click Done on the right of the migration task.
Complete the migration.
Was this page helpful?