Migration Solution Overview

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

Data migration tools include Data Replication Service (DRS) and pg_dump. 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** TaurusDB for PostgreSQL migration solutions
Source Database	Data Size	One-Time or Continuous Migration	Application Downtime	Solution
TaurusDB for PostgreSQL	Small	One-time	Some time	Use pg_dump to copy data from the source to the destination TaurusDB for PostgreSQL instance.
TaurusDB for PostgreSQL	Any	One-time or continuous	Minimal	Use DRS to synchronize data from the source to the destination TaurusDB for PostgreSQL instance.
RDS for PostgreSQL	Small	One-time	Some time	Use pg_dump to copy data from the source to the destination TaurusDB for PostgreSQL instance.
RDS for PostgreSQL	Any	One-time or continuous	Minimal	Use DRS to synchronize data from the source to the destination TaurusDB for PostgreSQL instance.
On-premises PostgreSQL databases ECS-hosted PostgreSQL databases	Any	One-time or continuous	Minimal	Use DRS to synchronize data from self-managed PostgreSQL databases to TaurusDB 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 TaurusDB for PostgreSQL.
On-premises Oracle databases ECS-hosted Oracle databases	Any	One-time or continuous	Minimal	Use DRS to synchronize data from self-managed Oracle databases to TaurusDB for PostgreSQL.
RDS for MySQL	Any	One-time or continuous	Minimal	Use DRS to synchronize data from RDS for MySQL to TaurusDB for PostgreSQL.
On-premises MySQL databases ECS-hosted MySQL databases	Any	One-time or continuous	Minimal	Use DRS to synchronize data from self-managed MySQL databases to TaurusDB 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 TaurusDB for PostgreSQL.