Help Center> GaussDB> User Guide> Database Migration> Migration Solution Overview

Updated on 2024-05-14 GMT+08:00

View PDF

Migration Solution Overview

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

Data migration tools include DRS and 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. It refers to the real-time flow of workload data from sources to destinations through a synchronization instance while consistency of data is ensured.

For more information, see What Is GaussDB?

**Table 1** Solutions to migrating data to GaussDB
Source Database	Destination Database	Data Size	One-Time or Continuous Migration	Application Downtime	Solution	Reference
On-premises MySQL databases ECS-hosted MySQL databases MySQL databases on other clouds	Distributed GaussDB	Any	One-time or continuous	Minimal	Use DRS to synchronize data.	From MySQL to GaussDB Distributed (to the cloud)
	Primary/Standby GaussDB	Any	One-time or continuous	Minimal	Use DRS to synchronize data.	From MySQL to GaussDB Primary/Standby (to the cloud)
On-premises PostgreSQL databases ECS-hosted PostgreSQL databases PostgreSQL databases on other clouds RDS for PostgreSQL	Primary/Standby GaussDB	Any	One-time or continuous	Minimal	Use DRS to synchronize data.	From PostgreSQL to GaussDB Primary/Standby
	Distributed GaussDB	Any	One-time or continuous	Minimal	Use DRS to synchronize data.	From PostgreSQL to GaussDB Distributed
On-premises Oracle databases ECS-hosted Oracle databases	Primary/Standby GaussDB	Any	One-time or continuous	Minimal	Use DRS to synchronize data.	From Oracle to GaussDB Primary/Standby (to the cloud)
On-premises Oracle databases ECS-hosted Oracle databases	Distributed GaussDB	Any	One-time or continuous	Minimal	Use DRS to synchronize data.	From Oracle to GaussDB Distributed (to the cloud)
Distributed GaussDB	Distributed GaussDB	Any	One-time or continuous	Minimal	Use DRS to synchronize data.	From GaussDB Distributed to GaussDB Distributed (out of the cloud)
	Primary/Standby GaussDB NOTE: Only whitelisted users can use this function.	Any	One-time or continuous	Minimal	Use DRS to synchronize data.	From GaussDB Distributed to GaussDB Primary/Standby (out of the cloud)
	Distributed GaussDB	Medium	One-time	Some time	Use DAS to export data from the source and then import the data to the destination GaussDB instance.	Migrating Data to GaussDB Using the Export and Import Functions of DAS
	Primary/Standby GaussDB	Medium	One-time	Some time
Primary/Standby GaussDB	Distributed GaussDB	Any	One-time or continuous	Minimal	Use DRS to synchronize data.	From GaussDB Primary/Standby to GaussDB Distributed (out of the cloud)
	Primary/Standby GaussDB	Any	One-time or continuous	Minimal	Use DRS to synchronize data.	From GaussDB Primary/Standby to GaussDB Primary/Standby (out of the cloud)
	Distributed GaussDB	Medium	One-time	Some time	Use DAS to export data from the source and then import the data to the destination GaussDB instance.	Migrating Data to GaussDB Using the Export and Import Functions of DAS
	Primary/Standby GaussDB	Medium	One-time	Some time
Db2 for LUW	Distributed GaussDB	Any	One-time or continuous	Minimal	Use DRS to synchronize data.	From DB2 for LUW to GaussDB Primary/Standby (to the cloud)
Db2 for LUW	Primary/Standby GaussDB	Any	One-time or continuous	Minimal	Use DRS to synchronize data.	From DB2 for LUW to GaussDB Distributed (to the cloud)
Local self-managed Microsoft SQL Server databases ECS-hosted Microsoft SQL Server databases Microsoft SQL Server databases on other clouds RDS for SQL Server	Primary/Standby GaussDB	Any	One-time or continuous	Minimal	Use DRS to synchronize data.	From Microsoft SQL Server to GaussDB Primary/Standby
	Distributed GaussDB	Any	One-time or continuous	Minimal	Use DRS to synchronize data.	From Microsoft SQL Server to GaussDB Distributed