This topic introduces the data migration and synchronization solutions supported by AnalyticDB for PostgreSQL. You can migrate or synchronize data smoothly between AnalyticDB for PostgreSQL databases and other types of data sources without interruptions to your business. These data sources include ApsaraDB RDS for MySQL, Apsara PolarDB for MySQL, ApsaraDB RDS for PostgreSQL, ApsaraDB RDS for PPAS, MaxCompute, Greenplum Database, user-created MySQL, user-created PostgreSQL, and Amazon Redshift.

The following table lists data migration and synchronization scenarios supported by AnalyticDB for PostgreSQL and related operations.

Operation Type Scenario
Migrate data by using an OSS external table Data migration Use OSS external tables to migrate data between an AnalyticDB for PostgreSQL instance and OSS.
Use Data Integration to migrate and batch synchronize data Data synchronization or migration Use Data Integration to migrate or synchronize data between an AnalyticDB for PostgreSQL instance and a heterogeneous data source within a few minutes.
Use the \COPY command Data migration Use the \COPY command to migrate data in local text files to an AnalyticDB for PostgreSQL instance.
Use rds_dbsync to migrate or synchronize data from a MySQL database to an AnalyticDB for PostgreSQL database Data synchronization or migration Use the mysql2pgsql function of the rds_dbsync tool to synchronize the data of tables from a local MySQL database to an AnalyticDB for PostgreSQL database.
Use rds_dbsync to migrate or synchronize data from a PostgreSQL database to an AnalyticDB for PostgreSQL database Data synchronization or migration Use the pgsql2pgsql function of the rds_dbsync tool to synchronize data between AnalyticDB for PostgreSQL databases, Greenplum Databases, PostgreSQL databases, or PPAS databases.
  1. Data migration: Data in a database instance or local data is migrated to an AnalyticDB for PostgreSQL instance.
  2. Data synchronization: Data in a database is synchronized to an AnalyticDB for PostgreSQL instance in real time.