Scenario Overview
Data migration is a one-time task of replicating data from the source database to the target database at the database level. After the migration is completed, the business will be cut over to the new database.
DTS supports data migration from self-built databases, TencentDB databases, and third-party cloud databases.
|
Migration from a self-built database to the cloud | Migrating a self-built database in the local IDC or on CVM to a TencentDB database. |
Migrating from third-party cloud vendors to Tencent Cloud. | Such as migration from an Alibaba Cloud or AWS database to TencentDB. |
Migration between TencentDB instances | Database version upgrade, cross-region migration (including migration between regions inside China or outside China, or cross-border migration), and the migration between database instances under different Tencent Cloud accounts. |
Feature Description
DTS supports access methods such as public network/self-built on CVM/DC/VPN access/CDB/CCN/VPC, with different deployment modes of databases offering various access options. Each access method requires specific network conditions. Please see Preparations. Self-built IDC databases/other cloud vendor databases: Access methods can include public network/DC/VPN access/CCN.
Self-built databases on CVM: Select CVM self-built as the access method.
CBD instances: Select CDB as the access method.
Migrating to MySQL
Note:
The version requirements for each database migration are as follows:
The data migration module does not support migrating out of cloud when the source is the TDSQL-C MySQL database type. If you have such cloud migration needs, please use the data sync module.
MySQL/TDSQL MySQL/MariaDB/TDSQL-C MySQL/TDSQL MySQL: The target database version must be equal to or later than the source database version, distinguished by the major version number. For example, 5.6.x can be migrated to 5.6.x, 5.7.x, or later versions.
MySQL > MySQL
|
Self-Built Database 5.5, 5.6, 5.7, 8.0 (IDC self-built MySQL/Self-built MySQL on CVM) | TencentDB for MySQL 5.5, 5.6, 5.7, 8.0 | Structure migration Full migration Full + incremental Migration | |
Third-Party Cloud Vendors Alibaba Cloud RDS 5.5, 5.6, 5.7, 8.0 Alibaba Cloud PolarDB 5.6, 5.7, 8.0 AWS RDS MySQL 5.6, 5.7, 8.0 AWS Aurora MySQL 5.6, 5.7, 8.0 |
|
|
|
TencentDB for MySQL 5.5, 5.6, 5.7, 8.0 Migration between databases under the same Tencent Cloud root account Migration between databases under different Tencent Cloud root accounts |
|
|
|
MariaDB > MySQL
|
Self-Built Database IDC self-built MariaDB 5.5, 10.0-10.6 Self-built MariaDB on CVM 5.5, 10.0-10.6 | TencentDB for MySQL 5.5, 5.6, 5.7, 8.0 | Structure migration Full migration Full + incremental migration | |
TencentDB for MariaDB (database versions: MySQL 8.0, Percona 5.7, MariaDB 10.1, MariaDB 10.4) Migration between databases under the same Tencent Cloud root account. Migration between databases under different Tencent Cloud root accounts |
|
|
|
Percona > MySQL
|
Self-Built Database IDC Self-built Percona 5.5, 5.6, 5.7, 8.0 Self-built Percona on CVM 5.5, 5.6, 5.7, 8.0 | TencentDB for MySQL 5.5, 5.6, 5.7, 8.0 | Structure migration Full migration Full + incremental migration | |
TDSQL-C for MySQL > MySQL
|
TDSQL-C for MySQL 5.7, 8.0 Migration between databases under the same Tencent Cloud root account Migration between databases under different Tencent Cloud root accounts | TencentDB for MySQL 5.7, 8.0 | Structure migration Full migration Full + incremental migration | |
|
|
|
|
TDSQL for MySQL > MySQL
|
TDSQL for MySQL (database versions: MySQL 8.0, Percona 5.7, MariaDB 10.1) Migration between databases under the same Tencent Cloud root account Migration between databases under different Tencent Cloud root accounts | TencentDB for MySQL | Structure migration Full migration Full + incremental migration | |
|
|
|
|
Migrating to MariaDB
MySQL > MariaDB
|
Self-Built Database IDC self-built MySQL 5.5, 5.6, 5.7, 8.0 Self-built MySQL on CVM 5.5, 5.6, 5.7, 8.0 | TencentDB for MariaDB (Database versions: MySQL 8.0, Percona 5.7, MariaDB 10.1, MariaDB 10.4) | Structure migration Full migration Full + incremental migration | |
TencentDB for MySQL 5.5, 5.6, 5.7, 8.0 Migration between databases under the same Tencent Cloud root account Migration between databases under different Tencent Cloud root accounts |
|
|
|
MariaDB > MariaDB
|
Self-Built Database IDC self-built MariaDB 5.5, 10.0-10.6 Self-built MariaDB on CVM 5.5, 10.0-10.6 | TencentDB for MariaDB (Database versions: MySQL 8.0, Percona 5.7, MariaDB 10.1, MariaDB 10.4) | Structure migration Full migration Full + incremental migration | |
TencentDB for MariaDB (Database versions: MySQL 8.0, Percona 5.7, MariaDB 10.1, MariaDB 10.4) Migration between databases under the same Tencent Cloud root account Migration between databases under different Tencent Cloud root accounts |
|
|
|
Percona > MariaDB
|
Self-Built Database IDC self-built Percona 5.5, 5.6, 5.7, 8.0 Self-built Percona on CVM 5.5, 5.6, 5.7, 8.0 | TencentDB for MariaDB
(database versions: MySQL 8.0, Percona 5.7, MariaDB 10.1, MariaDB 10.4) | Structure migration Full migration Full + incremental migration | |
TDSQL-C for MySQL > MariaDB
|
TDSQL-C for MySQL 5.7, 8.0 Migration between databases under the same Tencent Cloud root account Migration between databases under different Tencent Cloud root accounts | TencentDB for MariaDB (Database versions: MySQL 8.0, Percona 5.7, MariaDB 10.1, MariaDB 10.4) | Structure migration Full migration Full + incremental migration | |
|
|
|
|
TDSQL for MySQL > MariaDB
|
TDSQL for MySQL (Database versions: MySQL 8.0, Percona 5.7, MariaDB 10.1) Migration between databases under the same Tencent Cloud root account Migration between databases under different Tencent Cloud root accounts | TencentDB for MariaDB
(Database versions: MySQL 8.0, Percona 5.7, MariaDB 10.1, MariaDB 10.4) | Structure migration Full migration Full + incremental migration | |
|
|
|
|
Migrating to TDSQL-C for MySQL
MySQL > TDSQL-C MySQL
|
Self-Built Database IDC self-built MySQL 5.5, 5.6, 5.7, 8.0 Self-built MySQL on CVM 5.5, 5.6, 5.7, 8.0 | TDSQL-C for MySQL 5.7, 8.0 | Structure migration Full migration Full + incremental migration | |
Third-Party Cloud Vendors Alibaba Cloud RDS 5.5, 5.6, 5.7, 8.0 Alibaba Cloud PolarDB 5.6, 5.7, 8.0 AWS RDS MySQL 5.6, 5.7, 8.0 AWS Aurora MySQL 5.6, 5.7, 8.0 |
|
|
|
TencentDB for MySQL 5.5, 5.6, 5.7, 8.0 Migration between databases under the same Tencent Cloud root account Migration between databases under different Tencent Cloud root accounts |
|
|
|
MariaDB > TDSQL-C MySQL
|
Self-Built Database IDC self-built MariaDB 5.5, 10.0-10.6 Self-built MariaDB on CVM 5.5, 10.0-10.6 | TDSQL-C for MySQL 5.7, 8.0 | Structure migration Full migration Full + incremental migration | |
TencentDB for MariaDB (Database versions: MySQL 8.0, Percona 5.7, MariaDB 10.1, MariaDB 10.4) Migration between databases under the same Tencent Cloud root account Migration between databases under different Tencent Cloud root accounts |
|
|
|
Percona > TDSQL-C MySQL
|
Self-Built Database IDC self-built Percona 5.5, 5.6, 5.7, 8.0 Self-built Percona on CVM 5.5, 5.6, 5.7, 8.0 | TDSQL-C for MySQL 5.7, 8.0 | Structure migration Full migration Full + incremental migration | |
TDSQL-C MySQL > TDSQL-C MySQL
|
TDSQL-C for MySQL (database versions: MySQL 8.0, Percona 5.7, MariaDB 10.1) Migration between databases under the same Tencent Cloud root account Migration between databases under different Tencent Cloud root accounts | TDSQL-C for MySQL 5.7, 8.0 | Structure migration Full migration Full + incremental migration | |
|
|
|
|
TDSQL for MySQL > TDSQL-C for MySQL
|
TDSQL for MySQL (database versions: MySQL 8.0, Percona 5.7, MariaDB 10.1) Migration between databases under the same Tencent Cloud root account Migration between databases under different Tencent Cloud root accounts | TDSQL-C for MySQL 5.7, 8.0 | Structure migration Full migration Full + incremental migration | |
|
|
|
|
Migrating to TDSQL for MySQL
MySQL > TDSQL for MySQL
|
Self-Built Database IDC self-built MySQL 5.6, 5.7, 8.0 Self-built MySQL on CVM 5.6, 5.7, 8.0 | TDSQL for MySQL (database version MySQL 8.0) | Structure migration Full migration Full + incremental migration | |
TencentDB for MySQL 5.6, 5.7, 8.0 Migration between databases under the same Tencent Cloud root account Migration between databases under different Tencent Cloud root accounts |
|
|
|
MariaDB > TDSQL for MySQL
For homogeneous migration from MariaDB to TDSQL for MySQL (MariaDB), the target database version must be later than or equal to the source database version. For heterogeneous migration, currently only MariaDB 10.1 to TDSQL for MySQL (Percona 5.7) is supported.
|
Self-Built Database IDC self-built MariaDB 5.5, 10.0-10.6 Self-built MariaDB on CVM 5.5, 10.0-10.6 | TDSQL for MySQL (database version: MariaDB 10.1) | Structure migration Full migration Full + incremental migration | |
TencentDB for MariaDB (Database versions: MySQL 8.0, Percona 5.7, MariaDB 10.1, MariaDB 10.4) Migration between databases under the same Tencent Cloud root account Migration between databases under different Tencent Cloud root accounts |
|
|
|
Percona > TDSQL for MySQL
|
Self-Built Database IDC self-built Percona 5.5, 5.6, 5.7, 8.0 Self-built Percona 5.5, 5.6, 5.7, 8.0 on CVM | TDSQL for MySQL (database version: Percona 5.7) | Structure migration Full migration Full + incremental migration | |
TDSQL-C for MySQL > TDSQL for MySQL
|
TDSQL-C for MySQL 5.7, 8.0 Migration between databases under the same Tencent Cloud root account Migration between databases under different Tencent Cloud root accounts | TDSQL for MySQL (database versions: MySQL 8.0, Percona 5.7, MariaDB 10.1) | Structure migration Full migration Full + incremental migration | |
TDSQL for MySQL > TDSQL for MySQL
|
TDSQL for MySQL (Database versions: MySQL 8.0, Percona 5.7, MariaDB 10.1) Migration between databases under the same Tencent Cloud root account Migration between databases under different Tencent Cloud root accounts | TDSQL for MySQL (Database versions: MySQL 8.0, Percona 5.7, MariaDB 10.1) | Structure migration Full migration Full + incremental migration | |
|
|
|
|
MySQL > TDSQL for MySQL(TDStore)
|
Self-Built Database IDC self-built MySQL 5.5, 5.6, 5.7, 8.0 Self-built MySQL on CVM 5.5, 5.6, 5.7, 8.0 | TDSQL for MySQL (TDStore) | Structure migration Full migration Full + incremental migration | |
TencentDB for MySQL 5.5, 5.6, 5.7, 8.0 Migration between databases under the same Tencent Cloud root account Migration between databases under different Tencent Cloud root accounts |
|
|
|
MariaDB > TDSQL for MySQL(TDStore)
|
Self-Built Database IDC self-built MariaDB 5.5, 10.0-10.6 Self-built MariaDB on CVM 5.5, 10.0-10.6 | TDSQL for MySQL (TDStore) | Structure migration Full migration Full + incremental migration | |
TencentDB for MariaDB (Database versions: MySQL 8.0, Percona 5.7, MariaDB 10.1, MariaDB 10.4) Migration between databases under the same Tencent Cloud root account Migration between databases under different Tencent Cloud root accounts |
|
|
|
Percona > TDSQL for MySQL(TDStore)
|
Self-Built Database IDC self-built Percona 5.5, 5.6, 5.7, 8.0 Self-built Percona on CVM 5.5, 5.6, 5.7, 8.0 | TDSQL for MySQL (TDStore) | Structure migration Full migration Full + incremental migration | |
TDSQL for MySQL > TDSQL for MySQL(TDStore)
|
TencentDB for TDSQL MySQL
(Database versions: MySQL 8.0, Percona 5.7, MariaDB 10.1) Migration between databases under the same Tencent Cloud root account Migration between databases under different Tencent Cloud root accounts | TDSQL for MySQL (TDStore) | Structure migration Full migration Full + incremental migration | |
Migrating to PostgreSQL
PostgreSQL > PostgreSQL
Only versions 9.4 and above support incremental migration.
|
Self-built PostgreSQL Databases 10-15 IDC self-built Self-built on CVM | TencentDB for PostgreSQL 10, 11, 12, 13, 14, 15 | Structure migration Full migration Full + incremental migration | |
Third-party cloud vendor PostgreSQL 10-15 Alibaba Cloud RDS PostgreSQL AWS RDS PostgreSQL Huawei Cloud RDS for PostgreSQL |
|
|
|
TencentDB for PostgreSQL 10-15 Migration between databases under the same root account Migration between databases under different root accounts |
|
|
|
TDSQL-C PostgreSQL > PostgreSQL
|
TDSQL-C PostgreSQL 10.17 Migration between databases under the same root account | TencentDB for PostgreSQL 10, 11, 12, 13, 14, 15 | Structure migration Full migration Full + incremental migration | |
Migrating to MongoDB
MongoDB > MongoDB
|
Self-Built Database IDC self-built MongoDB 3.0, 3.2, 3.4, 3.6, 4.0, 4.2, 4.4, 5.0, 6.0 Self-built MongoDB on CVM 3.0, 3.2, 3.4, 3.6, 4.0, 4.2, 4.4, 5.0, 6.0 | TencentDB for MongoDB 3.0, 3.2, 3.4, 3.6, 4.0, 4.4、6.2、7.0, 5.0, 6.0 | Full migration Full + incremental migration | |
Third-party cloud vendors (Alibaba Cloud) MongoDB 3.0, 3.2, 3.4, 3.6, 4.0, 4.4, 5.0, 6.0 |
|
|
|
TencentDB for MongoDB 3.0, 3.2, 3.4, 3.6, 4.0, 4.4, 5.0, 6.0 Migration between databases under the same root account Migration between databases under different root accounts |
|
|
|
Migrating to SQL Server
SQL Server > SQL Server
|
Self-Built Database IDC self-built SQL Server 2008R2, 2012, 2014, 2016, 2017, 2019, 2022 Self-built SQL Server 2008R2, 2012, 2014, 2016, 2017, 2019, 2022 on CVM | SQL Server 2008R2, 2012, 2014, 2016, 2017, 2019, 2022 Supported by TencentDB for SQLServer | Full migration Full + incremental migration | |
Third-party cloud vendors (Alibaba Cloud, AWS) SQL Server 2008R2, 2012, 2014, 2016, 2017, 2019, 2022 |
|
|
|
SQL Server 2008R2, 2012, 2014, 2016, 2017, 2019, 2022 Supported by TencentDB for SQL Server Migration between databases under the same root account Migration between databases under different root accounts |
|
|
|
Migrating to TencentDB for Redis
Redis > Redis
Data migration feature for AWS ElasticCache for Redis requires Submit a Ticket application. |
Self-Built Database IDC self-built Redis 2.8, 3.0, 3.2, 4.0, 5.0, 6.0, 6.2, 7.0 Self-built Redis on CVM 2.8, 3.0, 3.2, 4.0, 5.0, 6.0, 6.2, 7.0 | TencentDB for Redis 2.8, 3.0, 3.2, 4.0, 5.0, 6.0, 6.2, 7.0 | Full + incremental migration | |
Third-Party cloud vendors AWS ElasticCaChe for Redis 4.0,5.0,6.0, 6.2, 7.0 |
|
|
|
TencentDB for Redis 2.8, 3.0, 3.2, 4.0, 5.0, 6.0, 6.2, 7.0 Migration between databases under the same root account Database migration between different root accounts |
|
|
|
Migrating to KeeWiDB
Redis > KeeWiDB
|
Self-Built Database IDC self-built Redis 4.0 Self-built Redis 4.0 on CVM | KeeWiDB 1.0 | Full + incremental migration | |
All third-party cloud vendors Redis 4.0 |
|
|
|
TencentDB for Redis 4.0 Migration between databases under the same root account Database migration between different root accounts |
|
|
|
Tendis > KeeWiDB
|
TencentDB for Tedis 4.9 Migration between databases under the same root account Database migration between different root accounts | KeeWiDB 1.0 | Full + incremental migration | |
