Data migration

Last Updated: Jun 15, 2017

Data migration helps you quickly and easily migrate data between different databases. It is applicable for scenarios such as on-premises data to cloud migration, Alibaba Cloud cross-instance migration, and database split and expansion. Both homogeneous migration, such as MySQL to MySQL, and heterogeneous migration, such as Oracle to Alibaba Cloud RDS MySQL, are attainable. DTS also provides basic ETL functions, including multi-level object mapping and data filtering.

Multiple migration types

The complete data migration process consists of three sequential stages. When creating a migration task, you can determine which stages are most applicable to your environment. These stages are:

  1. Schema migration: Migrates structural definition from the source instance to the target instance.

  2. Existing data migration: Migrates the existing data from the source instance to the target instance.

  3. Incremental replication: Replicates the source instance data changes to the target instance. The data changes are captured from the start of the existing data migration until the end of the whole migration progress.

Note: All three stages of data migration are crucial if you want to perform zero downtime data migration.

Migration task

Migration task is the basic unit of data migration. To carry out data migration, you must create a migration task on the DTS console. With a migration task, you need to specify the connection between the source and target instances, the objects to be migrated, migration stages, and additional parameters. You can also perform migration task creation, management, suspension, and deletion on the DTS console.

The migration task displays different status during creation and progress.

Migration status Description Available operation
Not started The migration task has been configured, but is not started. Pre-check
Delete
Pre-checking The migration task is performing pre-check. Delete
Pre-check passes The migration task passes pre-check. Start
Delete
Migrating The data is being migrated. Pause
Stop
Delete
Migration Failed The migration failed. Delete
Paused The migration is halted. Start
Delete
Finished The migration is completed successfully or cancelled. Delete

Migration specification

Data migration supports the following list of migration specifications, in form of source database engine to target database engine.

Migration spec. Schema migration Existing data migration Ongoing data replication
Oracle > RDS For MySQL Support Support Not support
MySQL > RDS For MySQL Support Support Support
SQLServer > RDS For SQLServer Support Support Support
PostgreSQL > RDS For PostgreSQL Support Support Support
Redis > Redis Support Support Support

Source instance

You can use the following databases as a source instance for data migration.

  • RDS instance
  • On-premises databases
  • ECS built-in database

Target instance

You can use the following databases as a target instance for data migration.

  • RDS instance
  • ECS built-in database
  • Redis instance

Multiple ETL functions

Data migration supports multiple ETL functions, including:

  • Multi-level object mapping: Data migration can be conducted between source and target objects with different names. You can configure the mapping relationship through the management console. The object granularity supports database, table, and column.

  • Data filtering: You can filter the table to be migrated by configuring a standard SQL condition. For example, by specifying the time period, you can choose to migrate the latest data.

DTS monitor

DTS monitors the operating status of migration tasks and detects abnormalities, such as lag or abended processes. If an abnormality is detected during the data migration process, you will immediately receive an alarm message instructing you how to best handle the issue.

Thank you! We've received your feedback.