Supported Databases

Real-Time Migration

You can migrate all database objects across cloud platforms, from on-premises databases to the cloud, or across regions on the cloud in real time. The following table lists the supported databases, versions, and migration types. For more information about real-time migration, see Real-Time Migration.

Self-managed databases include on-premises databases and databases created on an ECS. RDS for MySQL refers to the MySQL databases on RDS instances.

Note

The destination database version must be the same as or later than the source database version.

MySQL Serving as the Source in Migration

Table 1 Database information
Source DB Engine	Source DB Type and Version	Destination DB Type and Version	Migration Type
MySQL	Self-managed MySQL Versions 5.5, 5.6, 5.7, and 8.0 MySQL on other clouds Versions 5.5, 5.6, 5.7, and 8.0	RDS for MySQL All versions	Full Full+Incremental
		DDM The same version as that of the associated RDS instance.	Full Full+Incremental
	RDS for MySQL All versions	Self-managed or other cloud MySQL Versions 5.5, 5.6, 5.7, and 8.0	Full Full+Incremental

MongoDB Serving as the Source in Migration

Table 2 Database information
Source DB Engine	Source DB Type and Version	Destination DB Type and Version	Migration Type
MongoDB	Self-managed MongoDB Versions 3.2, 3.4, 3.6, 4.0, 4.2, 4.4, and 5.0 MongoDB on other clouds Versions 3.2, 3.4, 3.6, 4.0, 4.2, 4.4, and 5.0 DDS Versions 3.2, 3.4, 4.0, 4.2, 4.4, and 5.0	DDS Versions 3.4, 4.0, 4.2, 4.4, and 5.0 NOTE: DDS 5.0 supports replica sets only.	Full Full+Incremental migration supports the following scenarios: Replica set -> Replica set Replica set -> Cluster Cluster -> Cluster Cluster -> Replica set NOTE: If the source is a DDS cluster instance, the incremental migration can only be performed in the VPC network. To perform a full+incremental migration for a single node instance, the source database must be a single node instance.

DDS Serving as the Source in Migration

Table 3 Database information
Source DB Engine	Source DB Type and Version	Destination DB Type and Version	Migration Type
DDS	DDS Versions 3.2, 3.4, 4.0, 4.2, 4.4, and 5.0 NOTE: DDS 5.0 supports replica sets only.	Self-managed MongoDB Versions 3.2, 3.4, 3.6, 4.0, 4.2, 4.4, and 5.0 MongoDB on other clouds Versions 3.2, 3.4, 3.6, 4.0, 4.2, 4.4, and 5.0	Full Full+Incremental migration supports the following scenarios: Replica set -> Single node Replica set -> Replica set Replica set -> Cluster Single node -> Single node Single node -> Replica set Single node -> Cluster

MySQL Schema and Logic Table Serving as the Source in Migration

Table 4 Database information
Source DB Engine
Source DB Type and Version
Destination DB Type and Version
Migration Type
MySQL schema and logic table
DDM
DDM
Full
Full+Incremental

Table 4 Database information
Source DB Engine	Source DB Type and Version	Destination DB Type and Version	Migration Type
MySQL schema and logic table	DDM	DDM	Full Full+Incremental

Backup Migration

You can export data from the source database to a backup file, upload the backup file to OBS, and then restore the backup file to the destination database. In this way, data migration can be complete without exposing your source database to the Internet. Table 5 lists the supported databases, versions, and migration types. For more information about backup migration, see Backup Migration.

Note

The major version of the destination database must be the same as or later than that of the source database.

Table 5 Database information
Backup File Version	Destination DB Version	Migration Method	Backup File Source
On-premises and cloud Microsoft SQL Server backup file versions: Microsoft SQL Server 2000 Enterprise Edition and Standard Edition Microsoft SQL Server 2005 Enterprise Edition and Standard Edition Microsoft SQL Server 2008 Enterprise Edition, Standard Edition, and Web Edition Microsoft SQL Server 2012 Enterprise Edition, Standard Edition, and Web Edition Microsoft SQL Server 2014 Enterprise Edition, Standard Edition, and Web Edition Microsoft SQL Server 2016 Enterprise Edition, Standard Edition, and Web Edition Microsoft SQL Server 2017 Enterprise Edition, Standard Edition, and Web Edition Microsoft SQL Server 2019 Enterprise Edition, Standard Edition, and Web Edition	RDS for SQL Server Microsoft SQL Server 2008 Enterprise Edition, Standard Edition, and Web Edition Microsoft SQL Server 2012 Enterprise Edition, Standard Edition, and Web Edition Microsoft SQL Server 2014 Enterprise Edition, Standard Edition, and Web Edition Microsoft SQL Server 2016 Enterprise Edition, Standard Edition, and Web Edition Microsoft SQL Server 2017 Enterprise Edition, Standard Edition, and Web Edition Microsoft SQL Server 2019 Enterprise Edition, Standard Edition, and Web Edition	Full Incremental	OBS bucket RDS full backup
RDS for SQL Server full backup file versions: Microsoft SQL Server 2008 Enterprise Edition, Standard Edition, and Web Edition Microsoft SQL Server 2012 Enterprise Edition, Standard Edition, and Web Edition Microsoft SQL Server 2014 Enterprise Edition, Standard Edition, and Web Edition Microsoft SQL Server 2016 Enterprise Edition, Standard Edition, and Web Edition Microsoft SQL Server 2017 Enterprise Edition, Standard Edition, and Web Edition Microsoft SQL Server 2019 Enterprise Edition, Standard Edition, and Web Edition		Full Incremental	OBS bucket RDS full backup

Real-Time Synchronization

Real-time synchronization refers to the process of copying data from one data source to another database while keeping data consistency. In this way, the data of key services can flow in real time. The following table lists the supported databases, versions, and synchronization types. For more information about real-time synchronization, see Real-Time Synchronization.

Self-managed databases include on-premises databases and databases created on an ECS. RDS for MySQL refers to the MySQL databases on RDS instances.

Note

The destination database version must be the same as or later than the source database version.

MySQL Serving as the Source in Synchronization

Table 6 Database information
Source DB Engine	Source DB Type and Version	Destination DB Type and Version	Synchronization Mode
MySQL	Self-managed MySQL Versions 5.5, 5.6, 5.7, and 8.0 MySQL on other clouds Versions 5.5, 5.6, 5.7, and 8.0	RDS for MySQL All versions	Incremental Full Full+Incremental
		RDS for PostgreSQL Versions 9.5, 9.6, 10, 11, 12, 13, 14, 15, and 16	Full Full+Incremental
		GaussDB(DWS)	DataArts Migration is recommended.
		CSS/ES ElasticSearch 5.5, 6.2, 6.5, 7.1, 7.6, 7.9 and 7.10 NOTE: Only whitelisted users can use this function.	Full+Incremental
	RDS for MySQL All versions	Self-managed MySQL Versions 5.5, 5.6, 5.7, and 8.0 MySQL on other clouds Versions 5.5, 5.6, 5.7, and 8.0	Incremental Full+Incremental
		Kafka Version 0.11 or later	Incremental Full+Incremental
		CSS/ES ElasticSearch 5.5, 6.2, 6.5, 7.1, 7.6, 7.9 and 7.10 NOTE: Only whitelisted users can use this function.	Full+Incremental

MariaDB Serving as the Source in Synchronization

Table 7 Database information
Source DB Engine	Source DB Type and Version	Destination DB Type and Version	Synchronization Mode
MariaDB	On-premises MariaDB 10.3, 10.4, and 10.5 ECS-hosted MariaDB 10.3, 10.4, and 10.5 Other cloud MariaDB 10.3, 10.4, and 10.5	RDS for MariaDB Version 10.5	Full+Incremental
MariaDB	RDS for MariaDB Version 10.5	On-premises MariaDB Version 10.5 MariaDB built on ECSs Version 10.5 MariaDB built on other clouds Version 10.5	Full+Incremental

PostgreSQL Serving as the Source in Synchronization

Table 8 Database information
Source DB Engine	Source DB Type and Version	Destination DB Type and Version	Synchronization Mode
PostgreSQL	Self-managed PostgreSQL Versions 9.4, 9.5, 9.6, 10, 11, 12, 13, 14, 15, and 16 PostgreSQL on other clouds Versions 9.4, 9.5, 9.6, 10, 11, 12, 13, 14, 15, and 16 RDS for PostgreSQL Versions 9.5, 9.6, 10, 11, 12, 13, 14, 15, and 16	RDS for PostgreSQL Versions 9.5, 9.6, 10, 11, 12, 13, 14, 15, and 16	Incremental Full Full+Incremental

Table 9 Database information
Source DB Engine	Source DB Type and Version	Destination DB Type and Version	Synchronization Mode
PostgreSQL	Self-managed PostgreSQL Versions 9.4, 9.5, 9.6, 10, 11, 12, 13, 14, 15, and 16 PostgreSQL on other clouds Versions 9.4, 9.5, 9.6, 10, 11, 12, 13, 14, 15, and 16 RDS for PostgreSQL Versions 9.5, 9.6, 10, 11, 12, 13, 14, 15, and 16	RDS for PostgreSQL Versions 9.5, 9.6, 10, 11, 12, 13, 14, 15, and 16	Incremental Full Full+Incremental
	Self-managed PostgreSQL Versions 9.4, 9.5, 9.6, 10, 11, 12, 13, 14, 15, and 16 PostgreSQL on other clouds Versions 9.4, 9.5, 9.6, 10, 11, 12, 13, 14, 15, and 16	GaussDB(DWS) Versions 8.1.3 and 8.2.0 NOTE: Only whitelisted users can use this function.	Full+Incremental
		Kafka Version 0.11 or later	Incremental
	RDS for PostgreSQL Versions 9.5, 9.6, 10, 11, 12, 13, 14, 15, and 16	Kafka Version 0.11 or later	Incremental

Oracle Serving as the Source in Synchronization

Table 10 Database information
Source DB Engine	Source DB Type and Version	Destination DB Type and Version	Synchronization Mode
Oracle	Self-managed Oracle Versions 10g, 11g, 12c, 18c, 19c, and 21c	GaussDB primary/standby Version 1.0.0 or later	Incremental Full Full+Incremental
		GaussDB distributed Version 1.0.0 or later	Incremental Full Full+Incremental
		RDS for PostgreSQL Versions 9.5, 9.6, 10, 11, 12, 13, 14, 15, and 16	Full Full+Incremental

DDM Serving as the Source in Synchronization

Table 11 Database information
Source DB Engine	Source DB Type and Version	Destination DB Type and Version	Synchronization Mode
DDM	DDM	RDS for MySQL All versions	Incremental Full Full+Incremental
DDM	DDM	Self-managed or other cloud MySQL Versions 5.6, 5.7, and 8.0	Incremental Full Full+Incremental

Parent topic: Service Overview

Была ли эта статья полезна?

Поддержка Юридические документы