Migration type | References | Description | Supported in Serverless mode |
Write data | Use INSERT ON CONFLICT to overwrite 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 |
Use COPY ON CONFLICT to overwrite data | 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 |
Use the Client SDK | 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 | Use Data Integration to migrate and batch synchronize 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 \copy command to import data from your text files to AnalyticDB for PostgreSQL instances. | 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 |
Elastic Compute Service (ECS)
Container Compute Service (ACS)
