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.
(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.
Enter the information of the task, source database, and target database.
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.
Enter the source database information and click Test Connectivity to check whether the source database can be connected.
Enter the target database information and click Save.
Select the type and database list and click Next step: verify task.
Check whether the source instance runs normally and whether the sets to be migrated to the target instance are in conflicts.
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?