AnalyticDB for PostgreSQL provides multiple data migration and synchronization solutions to meet different business requirements. This allows you to migrate and synchronize data across various types of databases without impact on your business.
Migrate data to AnalyticDB for PostgreSQL
Migration type | References | Description | Supported in Serverless mode |
Write data | When you execute an INSERT statement to insert a row that contains the same primary key as an existing row, you can execute an INSERT ON CONFLICT statement to update the existing row.
| No | |
When you execute a COPY statement to import data, the data that you want to import may conflict with table constraints, and the COPY statement may fail with an error message. To solve this issue, AnalyticDB for PostgreSQL provides the COPY ON CONFLICT statement. | No | ||
AnalyticDB for PostgreSQL provides the Client SDK that allows you to develop your own data write programs or access existing data write programs efficiently. A custom data write program developed by using the Client SDK simplifies the data write process based on mechanisms such as parallel processing and delivers a performance that is multiple times better than COPY and INSERT statements. You do not need to worry about connection pool or cache issues. | Yes | ||
Migrate table data | Data Integration is a secure, cost-effective, stable, efficient, and elastic data synchronization platform provided by Alibaba Cloud. It is one of the core features of DataWorks. It supports data migration and synchronization across heterogeneous systems in diverse network environments. For more information, see Supported data source types, Reader plug-ins, and Writer plug-ins. | Yes | |
Use the \copy command to import data from your computer to AnalyticDB for PostgreSQL | You can use the | Yes | |
Use an external table to import data from OSS at a high speed | AnalyticDB for PostgreSQL allows you to use the Object Storage Service (OSS) external table (gpossext) feature to import data from OSS to AnalyticDB for PostgreSQL. | Yes | |
Use external tables for federated analytics of Hadoop data sources | You can migrate data from a Hadoop cluster to an AnalyticDB for PostgreSQL instance by using the gphdfs protocol. | Yes | |
Migrate warehouse data | Migrate data from a self-managed Greenplum cluster to an AnalyticDB for PostgreSQL instance | AnalyticDB for PostgreSQL V6.0 is built based on Greenplum 6.0 and optimized by Alibaba Cloud. AnalyticDB for PostgreSQL V6.0 supports vector computing and transaction processing when multiple coordinator nodes are supported. It uses the same API operations as Greenplum Community Edition. Both applications and data can be migrated from Greenplum to AnalyticDB for PostgreSQL. AnalyticDB for PostgreSQL allows you to smoothly migrate your applications and select from a variety of data migration solutions to migrate data. | No You can import data by using external tables. |
Migrate data from a Teradata database to an AnalyticDB for PostgreSQL instance | AnalyticDB for PostgreSQL is compatible with Teradata syntax, which allows you to migrate data from a Teradata database to an AnalyticDB for PostgreSQL instance. | No You can import data by using external tables. | |
Migrate data from an Amazon Redshift instance to an AnalyticDB for PostgreSQL instance | You can migrate data from an Amazon Redshift instance to an AnalyticDB for PostgreSQL instance. | No You can import data by using external tables. | |
Migrate data from a self-managed Oracle application to an AnalyticDB for PostgreSQL instance | AnalyticDB for PostgreSQL is compatible with Oracle syntax, which allows you to migrate data from an Oracle database to an AnalyticDB for PostgreSQL instance. | No You can import data by using external tables. | |
Migrate data from a self-managed Oracle database to an AnalyticDB for PostgreSQL instance | You can use Data Transmission Service (DTS) to migrate data from a self-managed Oracle database to an AnalyticDB for PostgreSQL instance. | Yes |
Migrate data from AnalyticDB for PostgreSQL
References | Description | Supported in Serverless mode |
You can use the | Yes | |
AnalyticDB for PostgreSQL allows you to export data to OSS buckets in parallel by using the OSS external table (gpossext) feature. AnalyticDB for PostgreSQL also supports GZIP compression for OSS external tables to reduce file size and storage costs. | Yes |
Synchronize data from cloud databases
References | Description | Supported in Serverless mode |
You can use DTS to synchronize data from an ApsaraDB RDS for MySQL instance to an AnalyticDB for PostgreSQL instance. The data synchronization feature provided by DTS allows you to transfer and analyze data with ease. | Yes | |
You can use DTS to synchronize data from an ApsaraDB RDS for SQL Server instance to an AnalyticDB for PostgreSQL instance. This helps you transfer and analyze data with ease. | Yes | |
You can use DTS to synchronize data from an ApsaraDB RDS for PostgreSQL instance to an AnalyticDB for PostgreSQL instance. The data synchronization feature provided by DTS allows you to transfer and analyze data with ease. | Yes | |
Synchronize data from a PolarDB for MySQL cluster to an AnalyticDB for PostgreSQL instance | You can use DTS to synchronize data from a PolarDB for MySQL cluster to an AnalyticDB for PostgreSQL instance. This helps you transfer and analyze data with ease. | Yes |
Synchronize data from self-managed databases
References | Description | Supported in Serverless mode |
You can use DTS to synchronize data from a self-managed MySQL database hosted on an Elastic Compute Service (ECS) instance to an AnalyticDB for PostgreSQL instance. This helps you transfer and analyze data with ease. | Yes | |
Synchronize data from a self-managed SQL Server database to an AnalyticDB for PostgreSQL instance | You can use DTS to synchronize data from a self-managed SQL Server database to an AnalyticDB for PostgreSQL instance. | Yes |
You can use DTS to synchronize data from a self-managed MySQL database connected over Express Connect, VPN Gateway, or Smart Access Gateway to an AnalyticDB for PostgreSQL instance. This helps you transfer and analyze data with ease. | Yes | |
Synchronize data from a self-managed Oracle database to an AnalyticDB for PostgreSQL instance | You can use DTS to synchronize data from a self-managed Oracle database to an AnalyticDB for PostgreSQL instance. | Yes |
Synchronize data from a Db2 for LUW database to an AnalyticDB for PostgreSQL instance | You can use DTS to synchronize data from a Db2 for LUW database to an AnalyticDB for PostgreSQL instance. | Yes |
You can use DTS to synchronize data from a self-managed SQL Server database to an AnalyticDB for PostgreSQL instance to implement incremental data synchronization in real time. | Yes | |
Synchronize data from a self-managed PostgreSQL database to an AnalyticDB for PostgreSQL instance | You can use DTS to synchronize data from a self-managed PostgreSQL database to an AnalyticDB for PostgreSQL instance. The data synchronization feature provided by DTS allows you to transfer and analyze data with ease. | Yes |
rds_dbsync is an open source tool used to migrate or synchronize data. You can use the mysql2pgsql feature of this tool to migrate data from MySQL tables to AnalyticDB for PostgreSQL, Greenplum Database, or PostgreSQL without having to store data. mysql2pgsql connects to both the source MySQL database and the destination database, retrieves the data that you want to export from the source MySQL database, and then uses a COPY statement to import the data to the destination database. | No | |
You can use the pgsql2pgsql feature of rds_dbsync to migrate tables across AnalyticDB for PostgreSQL, Greenplum Database, and PostgreSQL. | No |