This topic summarizes the data migration or synchronization solutions that are supported by .

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 DRDS databases that are created based on ApsaraDB RDS for MySQL.
  • The version of the AnalyticDB for MySQL instance must be V2.0 or V3.0.
  • The version of the AnalyticDB for PostgreSQL instance must be V4.3 or V6.0.
Large
Large ×
Large
Large
Assess data import and export Large
Large
MySQL native commands
  • Run the source command to import an SQL text file into DRDS.
  • Run the mysqldump command to export an SQL text file from DRDS.

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 DRDS.
  • Export data from DRDS 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 DRDS.
  • Export data from DRDS to MaxCompute (formerly known as ODPS).

For more information about the detailed steps, see Import and export data through Data Integration.

Large ×