Overview of data migration or synchronization solutions - PolarDB

This topic summarizes the data migration or synchronization solutions that are supported by PolarDB-X 1.0.

Note

In the following table, √ indicates that the solution is supported. × indicates that the solution is not supported.

Solution	Data volume	Full migration	Incremental migration
DTS Synchronize data between PolarDB-X instances Synchronize data from a PolarDB-X 1.0 instance to an ApsaraDB RDS for MySQL instance Note You can use Data Transmission Service (DTS) to synchronize data from or to only the PolarDB-X 1.0 databases that are created based on ApsaraDB RDS for MySQL.	Large	√	√
	Large	×	√
	Large	√	√
	Large	√	√
Assess data import and export. Migrate data from an ApsaraDB RDS instance to a PolarDB-X 1.0 instance	Large	√	√
	Large	√	√
MySQL native commands Run the `source` command to import an SQL text file into PolarDB-X 1.0. Run the `mysqldump` command to export an SQL text file from PolarDB-X 1.0. For more information about the detailed steps, see Import and export data by using mysqldump.	Small (less than 20 million records)	√	×
Programming methods Import data from a database or a text file to PolarDB-X 1.0. Export data from PolarDB-X 1.0 to a database or a text file. For more information about the detailed steps, see Import big data through a program.	Large	√	×
Data Integration Import data from MaxCompute (formerly known as ODPS) to PolarDB-X 1.0. Export data from PolarDB-X 1.0 to MaxCompute (formerly known as ODPS). For more information about the detailed steps, see Overview.	Large	√	×