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
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 RDS to PolarDB-X 1.0

 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 through 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 √ ×