Data migration

Last Updated: Jun 23, 2017

This section introduces the available sources and targets for data migration and the available migration types for data migration specifications.

Available source and target

Data migration supports many popular databases as source and target. The following table illustrates the available specifications of data migration task in DTS.

Source Target
On-premises databases in IDC
  • RDS instance databases in classic or VPC network
  • ECS instance databases
ECS instance databases
  • RDS instance databases in classic or VPC network
  • ECS instance databases
RDS instance databases
  • RDS instance databases in classic or VPC network
  • ECS instance databases
Redis instance databases in classic network
  • Redis instance databases in classic network
  • ECS instance databases

Available migration types

The complete data migration process includes three migration types: scheme migration, existing data migration, and incremental replication. When you create a data migration task, you can determine which one (or multiple) migration types to carry out based on your requirements.

Different migration specifications support different migration types, as illustrated in the following table.

Specification Schema migration Existing data migration Incremental data replication
Oracle > RDS for MySQL Yes Yes No
MySQL > RDS for MySQL Yes Yes Yes
SQLServer > RDS for SQLServer Yes Yes Yes
PostgreSQL > RDS for PostgreSQL Yes Yes Yes
Redis > Redis Yes Yes Yes
Thank you! We've received your feedback.