All Products
Search
Document Center

Data Management:Overview of data migration solutions

Last Updated:Jan 17, 2024

You can use Data Transmission Service (DTS) to migrate data between homogeneous data sources or between heterogeneous data sources. Typical scenarios include data migration to Alibaba Cloud, data migration between instances within Alibaba Cloud, and database sharding and scaling. This topic describes the database types, database versions, and migration types that are supported by the data migration feature. This topic also provides links to the relevant references.

Billing rules

You are charged for using the data migration feature of Data Transmission Service (DTS). For more information about the billing rules,see Billing overview.

Migration types

Migration type

Description

Schema migration

DTS migrates the schemas of 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, DTS converts the NUMBER data type in Oracle databases into the DECIMAL data type in MySQL databases.

Full data migration

DTS migrates historical data of the required objects from the source database to the destination database. If you select only Schema Migration and Full Data Migration when you configure a data migration task, DTS does not migrate incremental data that are generated in the source database.

Important

To ensure data consistency, do not write data to the source database during full data migration. To ensure service continuity, you must select Schema Migration, Full Data Migration, and Incremental Data Migration when you configure 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 generated in the source database to the destination database.

Note

During incremental data migration, data is synchronized between the source and destination databases in real time. The migration task does not automatically stop. You must manually stop the migration task.

Data migration scenarios

DTS supports the following data migration solutions. Select the corresponding data migration solution based on your actual scenario to view the supported database versions, migration types, and configuration procedure.