Migration service

Last Updated: Aug 21, 2017

The migration service can migrate data from a local database to ApsaraDB, or migrate an ApsaraDB instance to another instance. ApsaraDB includes a Data Transfer Service (DTS) tool to facilitate quick database migration.

DTS is a cloud data transfer service for efficient instance migration in local databases, as well as between RDS instances. For more information about DTS, see DTS product overview.

DTS provides three migration modes: structural migration, full migration and incremental migration:

  • Structural migration: DTS migrates the structural definitions of migration objects to the target instance. Currently, this mode can migrate tables, views, triggers, stored procedures, and stored functions.

  • Full migration: DTS migrates all existing data in the source database migration objects to the target instance.

    Note: To ensure data consistency, non-transaction tables that do not have a Primary Key will be locked during full migration. Locked tables cannot be written to, and the duration of the lock depends on the volume of data in a table. The locks are released only after the non-transaction tables without a Primary Key have been fully migrated.

  • Incremental migration: DTS synchronizes data changes made in the migration process to the target instance.

    Note: If a DDL operation is performed during data migration, structural changes will not be synchronized to the target instance.

Thank you! We've received your feedback.