Migration Solution Overview

You can migrate data from RDS for MySQL, self-managed MySQL databases, MySQL databases built on other clouds, self-managed PostgreSQL databases, PostgreSQL databases built on other clouds, or self-managed Oracle databases to RDS for PostgreSQL, or from one RDS for PostgreSQL instance to another RDS for PostgreSQL instance.

Data migration tools include Data Replication Service (DRS), pg_dump, and Data Admin Service (DAS). You are advised to use DRS because it is easy to use and can complete a migration task in minutes. DRS facilitates data transfer between databases, helping you reduce DBA labor costs and hardware costs.

DRS provides real-time synchronization. Real-time synchronization refers to the real-time flow of workload data from sources to destinations through a synchronization instance while consistency of data is ensured. It is different from migration. Migration means moving entire data of a database to another. Synchronization refers to the continuous flow of data between different applications.

For more information, see What Is DRS?

Migration Solutions

**Table 1** RDS for PostgreSQL migration solutions
Source Database	Data Size	One-Time or Continuous Migration	Application Downtime	Solution	Document
RDS for PostgreSQL	Small	One-time	Some time	Use pg_dump to copy data from the source to the destination RDS for PostgreSQL instance.	Migrating Data to RDS for PostgreSQL Using psql
	Medium	One-time	Some time	Use DAS to export data from the source and then import the data to the destination RDS for PostgreSQL instance.	Migrating Data to RDS for PostgreSQL Using the Export and Import Functions of DAS
	Any	One-time or continuous	Minimal	Use DRS to synchronize data from the source to the destination RDS for PostgreSQL instance.	From PostgreSQL to RDS for PostgreSQL
On-premises PostgreSQL databases PostgreSQL databases on ECSs	Any	One-time or continuous	Minimal	Use DRS to synchronize data from self-managed PostgreSQL databases to RDS for PostgreSQL.	From PostgreSQL to RDS for PostgreSQL
PostgreSQL databases on other clouds	Any	One-time or continuous	Minimal	Use DRS to synchronize data from PostgreSQL databases on other clouds to RDS for PostgreSQL.	From PostgreSQL to RDS for PostgreSQL
On-premises Oracle databases Oracle databases on ECSs	Any	One-time or continuous	Minimal	Use DRS to synchronize data from self-managed Oracle databases to RDS for PostgreSQL.	From Oracle to RDS for PostgreSQL
RDS for MySQL	Any	One-time or continuous	Minimal	Use DRS to synchronize data from RDS for MySQL to RDS for PostgreSQL.	From MySQL to RDS for PostgreSQL
On-premises MySQL databases MySQL databases on ECSs	Any	One-time or continuous	Minimal	Use DRS to synchronize data from self-managed MySQL databases to RDS for PostgreSQL.	From MySQL to RDS for PostgreSQL
MySQL databases on other clouds	Any	One-time or continuous	Minimal	Use DRS to synchronize data from MySQL databases on other clouds to RDS for PostgreSQL.	From MySQL to RDS for PostgreSQL