You can use DTS to migrate data between homogeneous and heterogeneous data sources. Typical scenarios include data migration to Alibaba Cloud, data migration between instances within Alibaba Cloud, and database splitting and scale-out. This topic describes the database types, database versions, and migration types that are supported by data migration.

For more information about data migration in various scenarios, see Overview.

Migration types

Migration type Description
Schema migration

DTS migrates the schemas of the required objects from the source database to the destination database. Tables, views, triggers, and stored procedures can be migrated.

For schema migration between heterogeneous databases, DTS converts the schema syntax based on the syntax of the source and destination databases. For example, it converts the NUMBER data type in Oracle databases to the DECIMAL data type in MySQL databases.

Full data migration DTS migrates historical inventory data of the required objects from the source database to the destination database. If you select only schema migration and full data migration, new data generated in the source database will not be migrated to the destination database.
Note To ensure data consistency, we recommend that you do not write new data into the source database during full data migration. To migrate data with minimal downtime, you must select schema migration, full data migration, and incremental data migration when configuring a data migration task.
Incremental data migration DTS retrieves static snapshots that are used for full data migration from the source database and migrates the snapshot data to the destination database. Then, DTS synchronizes incremental data that is generated in the source database to the destination database in real time.
Note During incremental data migration, data between the source and destination databases are synchronized in real time. The migration task does not automatically end. You must manually end the migration task.

Database and migration types

A user-created source or destination database, such as a MySQL, SQL Server, or Oracle database, can be one of the following types: User-Created Database with Public IP Address, User-Created Database in ECS Instance, and User-Created Database Connected Over Express Connect, VPN Gateway, or Smart Access Gateway.

Source database Destination database Migration type
  • User-created MySQL database

    5.1, 5.5, 5.6, 5.7, and 8.0

  • ApsaraDB RDS for MySQL

    All versions

User-created MySQL database

5.1, 5.5, 5.6, 5.7, and 8.0

  • Schema migration
  • Full data migration
  • Incremental data migration

ApsaraDB RDS for MySQL

All versions

  • Schema migration
  • Full data migration
  • Incremental data migration

POLARDB for MySQL

All versions

  • Schema migration
  • Full data migration
  • Incremental data migration

DRDS

All versions

  • Full data migration
  • Incremental data migration

HybridDB for MySQL (Previous name: PetaData)

All versions

  • Full data migration
  • Incremental data migration

AnalyticDB for MySQL

2.0

  • Schema migration
  • Full data migration
  • Incremental data migration

PostgreSQL

9.4, 9.5, 9.6, and 10.x

  • Full data migration
  • Incremental data migration

User-created Oracle database (RAC and non-RAC architecture)

9i, 10g, and 11g

  • Schema migration
  • Full data migration
  • Incremental data migration

ApsaraDB for OceanBase

All versions

  • Schema migration
  • Full data migration
  • Incremental data migration

POLARDB for MySQL

All versions

POLARDB for MySQL

All versions

  • Schema migration
  • Full data migration
  • Incremental data migration

User-created MySQL database

5.1, 5.5, 5.6, 5.7, and 8.0

  • Schema migration
  • Full data migration
  • Incremental data migration

ApsaraDB RDS for MySQL

All versions

  • Schema migration
  • Full data migration
  • Incremental data migration

AnalyticDB for MySQL

2.0

  • Schema migration
  • Full data migration
  • Incremental data migration

DRDS

All versions

  • Full data migration
  • Incremental data migration
  • User-created SQL Server database

    2005, 2008, 2008R2, 2012, 2014, and 2016.

    Note If the version of the source database is 2005, incremental data migration is not supported.
  • ApsaraDB RDS for SQL Server

    2008, 2008R2, 2012, 2014, and 2016.

User-created SQL Server database

2005, 2008, 2008R2, 2012, 2014, and 2016.

  • Schema migration
  • Full data migration
  • Incremental data migration

ApsaraDB RDS for SQL Server

2008, 2008R2, 2012, 2014, and 2016.

  • Schema migration
  • Full data migration
  • Incremental data migration

User-created Oracle database (RAC and non-RAC architecture)

9i, 10g, and 11g

User-created Oracle database (RAC and non-RAC architecture)

9i, 10g, and 11g

  • Schema migration
  • Full data migration
  • Incremental data migration

POLARDB database engine that is compatible with Oracle syntax

All versions

  • Schema migration
  • Full data migration
  • Incremental data migration

ApsaraDB RDS for PPAS

9.3 and 10

  • Schema migration
  • Full data migration
  • Incremental data migration

User-created MySQL database

5.1, 5.5, 5.6, 5.7, and 8.0

  • Schema migration
  • Full data migration
  • Incremental data migration

ApsaraDB RDS for MySQL

All versions

  • Schema migration
  • Full data migration
  • Incremental data migration

DRDS

All versions

  • Full data migration
  • Incremental data migration

AnalyticDB for MySQL

2.0

  • Full data migration
  • Incremental data migration
  • User-created PostgreSQL database

    9.4, 9.5, 9.6, and 10.x

  • ApsaraDB RDS for PostgreSQL

    9.4 and 10

User-created PostgreSQL database

9.4, 9.5, 9.6, and 10.x

  • Schema migration
  • Full data migration
  • Incremental data migration

ApsaraDB RDS for PostgreSQL

9.4 and 10

  • Schema migration
  • Full data migration
  • Incremental data migration
  • User-created MongoDB database (single-node, replica set, and sharded cluster architecture)

    3.0, 3.2, 3.4, 3.6, and 4.0

  • ApsaraDB for MongoDB instance (single-node and replica set architecture)

    All versions

  • User-created MongoDB database (single-node, replica set, and sharded cluster architecture)

    3.0, 3.2, 3.4, 3.6, and 4.0

  • ApsaraDB for MongoDB instance (single-node and replica set architecture)

    All versions

  • Full data migration
  • Incremental data migration
Note MongoDB is a type of NoSQL database that does not require initial schema synchronization.

User-created Redis database (single-host architecture)

2.8, 3.0, 3.2, and 4.0

  • User-created Redis database (single-host and cluster architecture)

    2.8, 3.0, 3.2, 4.0, and 5.0

  • ApsaraDB for Redis instance (single-host and cluster architecture)

    All versions

  • Full data migration
  • Incremental data migration
Note Redis is a type of NoSQL database that does not require initial schema synchronization.

User-created Db2 database

9.7 and 10.5

User-created MySQL database

5.1, 5.5, 5.6, 5.7, and 8.0

  • Schema migration
  • Full data migration
  • Incremental data migration