- Release Notes and Announcements
- Product Introduction
- Purchase Guide
- Getting Started
- Preparations
- Business Evaluation
- Network Preparation
- DTS Service Permission Preparation
- Database and Permission Preparation
- Configuring Binlog in Self-Built MySQL
- Data Migration
- Databases Supported by Data Migration
- Cross-Account TencentDB Instance Migration
- Migration to MySQL Series
- Migrating to MySQL
- Migrating to MariaDB
- Migrating to TDSQL-C for MySQL
- Migrating to TDSQL MySQL
- Migrating to TDSQL TDStore
- Advanced Operations for MySQL Series Migration
- Processing for MySQL Series Pre-Check Failure
- Database Connection Check
- Peripheral Check
- Version Check
- Source Instance Permission Check
- Partial Database Parameter Check
- Target Instance Permission Check
- Target Database Content Conflict Check
- Target Database Space Check
- Binlog Parameter Check
- Foreign Key Dependency Check
- View Check
- Advanced Object Check
- Warning Item Check
- TDSQL Proxy Check
- TDSQL Kernel Check
- DDL Ring Linkage Synchronization Detection for Same Database and Table Objects
- DDL Synchronization Conflict Detection for the Same Target and Same Database and Table Object
- Offline Migration of MySQL Data
- Migrating to PostgreSQL
- Migration from PostgreSQL to TencentDB for PostgreSQL
- Migration from TDSQL-C PostgreSQL to TencentDB for PostgreSQL
- PostgreSQL Physical Migration
- Processing for PostgreSQL Series Pre-Check Failure
- Database Connection Check
- Object Dependency Check
- Version Check
- Source or Target Instance Permission Check
- Incremental Migration Pre Check
- Structural Compatibility Check
- Structural Conflict Check
- Account Conflict Check
- Parameter Configuration Conflict Check
- Plugin Compatibility Check
- Multi Task Conflict Detection
- Long Transaction Check
- Migrating to MongoDB
- Migration from MongoDB to MongoDB
- Fix for Verification Failure
- MongoDB Connection Check
- Database/Table Content Conflict Check
- Source Database Node Role Check
- Oplog Check
- Source/Target Database Account Permission Check
- Database Version Check
- Database Capacity Check
- Target Database Load Check
- ShardKey Check
- Source Database Balancer Check
- Time Series Collection Verification
- Compression Algorithm Verification
- MongoDB Data Consistency Verification
- Migrating to SQL Server
- Migrating to TencentDB for Redis
- Migrating to KeeWiDB
- Task Management
- Task Status Description
- Viewing Task
- Configuring Task
- Verifying Task
- Start Task
- Retrying Task (MySQL)
- Retrying Task (Redis)
- Speed Limit (MySQL)
- Speed Limit (Redis)
- Complete Task
- Terminating Task
- Deleting Task
- Pausing Task
- Resuming Task
- Changing Configuration
- Terminating Task
- Deisolating Task
- Deleting Task
- Managing Tag
- Creating a Similar Task
- Viewing Log
- Data Sync
- Databases Supported by Data Sync
- Cross-Account TencentDB Instance Sync
- Sync to MySQL series
- Sync to MySQL
- Sync to MariaDB
- Sync to TDSQL-C for MySQL
- Sync to TDSQL for MySQL
- Sync to TDSQL TDStore
- MySQL Series Advanced Sync Operations
- MySQL series Pre Validation Failed Processing
- Database Connection Check
- Peripheral Check
- Version Check
- Source Instance Permission Check
- Partial Database Parameter Check
- Target Database Content Conflict Check
- Target Database Space Check
- Binlog Parameter Check
- Foreign Key Dependency Check
- View Check
- Advanced Object Check
- Warning Item Check
- TDSQL Proxy Check
- TDSQL kernel check
- DLL Ring Sync Check for Single Database/Table Object
- DLL Sync Conflict Check for Single Database/Table Object in the Same Target
- Synchronize to PostgreSQL
- Synchronization from PostgreSQL to PostgreSQL
- PostgreSQL Pre Validation does not Pass Processing
- Database Connection Check
- Object Dependency Check
- Version Check
- Source or Target Instance Permission Check
- Incremental Migration Pre Check
- Structural Compatibility Check
- Structural Conflict Check
- Account Conflict Check
- Parameter Configuration Conflict Check
- Plugin Compatibility Check
- Primary Key Dependency Check
- Check the Key Parameters of the Instance
- Multi Task Conflict Detection
- Synchronize to Kafka
- Task Management
- Task Status Description
- Viewing Task
- Configuring Task
- Verifying Task
- Starting Task
- Retrying Task (MySQL)
- Speed Limit
- Stopping Task
- Modify Sync configuration
- Pausing Task
- Resuming Task
- Resetting Task
- Deleting Task
- Changing Configuration
- Pay-as-You-Go to Monthly Subscription
- Terminating/Returning Instance
- Renewing Task
- Deisolating Task
- Deleting Instance
- Creating a Similar Task
- Viewing Log
- Deleting Task
- Data Subscription (Kafka Edition)
- Databases Supported by Data Subscription
- MySQL series Data Subscription
- Creating MySQL or TDSQL for MySQL Data Subscription
- Creating TDSQL for MySQL Data Subscription
- Creating MariaDB/Percona Data Subscription
- Consuming MySQL Data
- Advanced Subscription Operations
- Fix for Verification Failure
- Data Subscription for TDSQL PostgreSQL
- MongoDB Data Subscription
- Task Management
- Consumption Management
- Fix for Verification Failure
- Cutover Description
- Monitoring and Alarms
- Ops Management
- Practical Tutorial
- Synchronizing Local Database to the Cloud
- Creating Two-Way Sync Data Structure
- Creating Many-to-One Sync Data Structure
- Creating Multi-Site Active-Active IDC Architecture
- Selecting Data Sync Conflict Resolution Policy
- Using CLB as Proxy for Cross-Account Database Migration
- Migrating Self-Built Databases to Tencent Cloud Databases via CCN
- Best Practices for DTS Performance Tuning
- FAQs
- Error Handling
- API Documentation
- History
- Introduction
- Introduction
- API Category
- Making API Requests
- (NewDTS) Data Migration APIs
- DescribeMigrationJobs
- CreateMigrationService
- ModifyMigrationJob
- CreateMigrateCheckJob
- DescribeMigrationCheckJob
- SkipCheckItem
- StartMigrateJob
- CompleteMigrateJob
- ContinueMigrateJob
- DescribeMigrateDBInstances
- DescribeMigrationDetail
- DestroyMigrateJob
- IsolateMigrateJob
- ModifyMigrateJobSpec
- ModifyMigrateName
- ModifyMigrateRuntimeAttribute
- PauseMigrateJob
- RecoverMigrateJob
- ResumeMigrateJob
- StopMigrateJob
- ModifyMigrateRateLimit
- Data Sync APIs
- DescribeSyncJobs
- CreateSyncJob
- ConfigureSyncJob
- CreateCheckSyncJob
- DescribeCheckSyncJobResult
- SkipSyncCheckItem
- StartSyncJob
- IsolateSyncJob
- RecoverSyncJob
- PauseSyncJob
- ContinueSyncJob
- ResumeSyncJob
- StopSyncJob
- DestroySyncJob
- ResizeSyncJob
- ModifySyncJobConfig
- CreateModifyCheckSyncJob
- DescribeModifyCheckSyncJobResult
- StartModifySyncJob
- ModifySyncRateLimit
- Data Consistency Check APIs
- (NewDTS) Data Subscription APIs
- CreateSubscribe
- ConfigureSubscribeJob
- CreateSubscribeCheckJob
- DescribeSubscribeCheckJob
- StartSubscribe
- ModifySubscribeObjects
- DescribeSubscribeDetail
- DescribeSubscribeJobs
- ResumeSubscribe
- CreateConsumerGroup
- DescribeConsumerGroups
- ModifyConsumerGroupDescription
- ModifyConsumerGroupPassword
- DescribeOffsetByTime
- ResetConsumerGroupOffset
- DeleteConsumerGroup
- ResetSubscribe
- ModifySubscribeAutoRenewFlag
- ModifySubscribeName
- DescribeSubscribeReturnable
- IsolateSubscribe
- DestroyIsolatedSubscribe
- Data Types
- Error Codes
- DTS API 2018-03-30
- Service Agreement
- Release Notes and Announcements
- Product Introduction
- Purchase Guide
- Getting Started
- Preparations
- Business Evaluation
- Network Preparation
- DTS Service Permission Preparation
- Database and Permission Preparation
- Configuring Binlog in Self-Built MySQL
- Data Migration
- Databases Supported by Data Migration
- Cross-Account TencentDB Instance Migration
- Migration to MySQL Series
- Migrating to MySQL
- Migrating to MariaDB
- Migrating to TDSQL-C for MySQL
- Migrating to TDSQL MySQL
- Migrating to TDSQL TDStore
- Advanced Operations for MySQL Series Migration
- Processing for MySQL Series Pre-Check Failure
- Database Connection Check
- Peripheral Check
- Version Check
- Source Instance Permission Check
- Partial Database Parameter Check
- Target Instance Permission Check
- Target Database Content Conflict Check
- Target Database Space Check
- Binlog Parameter Check
- Foreign Key Dependency Check
- View Check
- Advanced Object Check
- Warning Item Check
- TDSQL Proxy Check
- TDSQL Kernel Check
- DDL Ring Linkage Synchronization Detection for Same Database and Table Objects
- DDL Synchronization Conflict Detection for the Same Target and Same Database and Table Object
- Offline Migration of MySQL Data
- Migrating to PostgreSQL
- Migration from PostgreSQL to TencentDB for PostgreSQL
- Migration from TDSQL-C PostgreSQL to TencentDB for PostgreSQL
- PostgreSQL Physical Migration
- Processing for PostgreSQL Series Pre-Check Failure
- Database Connection Check
- Object Dependency Check
- Version Check
- Source or Target Instance Permission Check
- Incremental Migration Pre Check
- Structural Compatibility Check
- Structural Conflict Check
- Account Conflict Check
- Parameter Configuration Conflict Check
- Plugin Compatibility Check
- Multi Task Conflict Detection
- Long Transaction Check
- Migrating to MongoDB
- Migration from MongoDB to MongoDB
- Fix for Verification Failure
- MongoDB Connection Check
- Database/Table Content Conflict Check
- Source Database Node Role Check
- Oplog Check
- Source/Target Database Account Permission Check
- Database Version Check
- Database Capacity Check
- Target Database Load Check
- ShardKey Check
- Source Database Balancer Check
- Time Series Collection Verification
- Compression Algorithm Verification
- MongoDB Data Consistency Verification
- Migrating to SQL Server
- Migrating to TencentDB for Redis
- Migrating to KeeWiDB
- Task Management
- Task Status Description
- Viewing Task
- Configuring Task
- Verifying Task
- Start Task
- Retrying Task (MySQL)
- Retrying Task (Redis)
- Speed Limit (MySQL)
- Speed Limit (Redis)
- Complete Task
- Terminating Task
- Deleting Task
- Pausing Task
- Resuming Task
- Changing Configuration
- Terminating Task
- Deisolating Task
- Deleting Task
- Managing Tag
- Creating a Similar Task
- Viewing Log
- Data Sync
- Databases Supported by Data Sync
- Cross-Account TencentDB Instance Sync
- Sync to MySQL series
- Sync to MySQL
- Sync to MariaDB
- Sync to TDSQL-C for MySQL
- Sync to TDSQL for MySQL
- Sync to TDSQL TDStore
- MySQL Series Advanced Sync Operations
- MySQL series Pre Validation Failed Processing
- Database Connection Check
- Peripheral Check
- Version Check
- Source Instance Permission Check
- Partial Database Parameter Check
- Target Database Content Conflict Check
- Target Database Space Check
- Binlog Parameter Check
- Foreign Key Dependency Check
- View Check
- Advanced Object Check
- Warning Item Check
- TDSQL Proxy Check
- TDSQL kernel check
- DLL Ring Sync Check for Single Database/Table Object
- DLL Sync Conflict Check for Single Database/Table Object in the Same Target
- Synchronize to PostgreSQL
- Synchronization from PostgreSQL to PostgreSQL
- PostgreSQL Pre Validation does not Pass Processing
- Database Connection Check
- Object Dependency Check
- Version Check
- Source or Target Instance Permission Check
- Incremental Migration Pre Check
- Structural Compatibility Check
- Structural Conflict Check
- Account Conflict Check
- Parameter Configuration Conflict Check
- Plugin Compatibility Check
- Primary Key Dependency Check
- Check the Key Parameters of the Instance
- Multi Task Conflict Detection
- Synchronize to Kafka
- Task Management
- Task Status Description
- Viewing Task
- Configuring Task
- Verifying Task
- Starting Task
- Retrying Task (MySQL)
- Speed Limit
- Stopping Task
- Modify Sync configuration
- Pausing Task
- Resuming Task
- Resetting Task
- Deleting Task
- Changing Configuration
- Pay-as-You-Go to Monthly Subscription
- Terminating/Returning Instance
- Renewing Task
- Deisolating Task
- Deleting Instance
- Creating a Similar Task
- Viewing Log
- Deleting Task
- Data Subscription (Kafka Edition)
- Databases Supported by Data Subscription
- MySQL series Data Subscription
- Creating MySQL or TDSQL for MySQL Data Subscription
- Creating TDSQL for MySQL Data Subscription
- Creating MariaDB/Percona Data Subscription
- Consuming MySQL Data
- Advanced Subscription Operations
- Fix for Verification Failure
- Data Subscription for TDSQL PostgreSQL
- MongoDB Data Subscription
- Task Management
- Consumption Management
- Fix for Verification Failure
- Cutover Description
- Monitoring and Alarms
- Ops Management
- Practical Tutorial
- Synchronizing Local Database to the Cloud
- Creating Two-Way Sync Data Structure
- Creating Many-to-One Sync Data Structure
- Creating Multi-Site Active-Active IDC Architecture
- Selecting Data Sync Conflict Resolution Policy
- Using CLB as Proxy for Cross-Account Database Migration
- Migrating Self-Built Databases to Tencent Cloud Databases via CCN
- Best Practices for DTS Performance Tuning
- FAQs
- Error Handling
- API Documentation
- History
- Introduction
- Introduction
- API Category
- Making API Requests
- (NewDTS) Data Migration APIs
- DescribeMigrationJobs
- CreateMigrationService
- ModifyMigrationJob
- CreateMigrateCheckJob
- DescribeMigrationCheckJob
- SkipCheckItem
- StartMigrateJob
- CompleteMigrateJob
- ContinueMigrateJob
- DescribeMigrateDBInstances
- DescribeMigrationDetail
- DestroyMigrateJob
- IsolateMigrateJob
- ModifyMigrateJobSpec
- ModifyMigrateName
- ModifyMigrateRuntimeAttribute
- PauseMigrateJob
- RecoverMigrateJob
- ResumeMigrateJob
- StopMigrateJob
- ModifyMigrateRateLimit
- Data Sync APIs
- DescribeSyncJobs
- CreateSyncJob
- ConfigureSyncJob
- CreateCheckSyncJob
- DescribeCheckSyncJobResult
- SkipSyncCheckItem
- StartSyncJob
- IsolateSyncJob
- RecoverSyncJob
- PauseSyncJob
- ContinueSyncJob
- ResumeSyncJob
- StopSyncJob
- DestroySyncJob
- ResizeSyncJob
- ModifySyncJobConfig
- CreateModifyCheckSyncJob
- DescribeModifyCheckSyncJobResult
- StartModifySyncJob
- ModifySyncRateLimit
- Data Consistency Check APIs
- (NewDTS) Data Subscription APIs
- CreateSubscribe
- ConfigureSubscribeJob
- CreateSubscribeCheckJob
- DescribeSubscribeCheckJob
- StartSubscribe
- ModifySubscribeObjects
- DescribeSubscribeDetail
- DescribeSubscribeJobs
- ResumeSubscribe
- CreateConsumerGroup
- DescribeConsumerGroups
- ModifyConsumerGroupDescription
- ModifyConsumerGroupPassword
- DescribeOffsetByTime
- ResetConsumerGroupOffset
- DeleteConsumerGroup
- ResetSubscribe
- ModifySubscribeAutoRenewFlag
- ModifySubscribeName
- DescribeSubscribeReturnable
- IsolateSubscribe
- DestroyIsolatedSubscribe
- Data Types
- Error Codes
- DTS API 2018-03-30
- Service Agreement
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.
Scenario | Description |
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
Source Database and Version | Target Database and Version | Migration Type | Reference Documentation |
Self-Built Database IDC self-built MySQL 5.5, 5.6, 5.7, 8.0 Self-built MySQL 5.5, 5.6, 5.7, 8.0 on CVM | TencentDB for MySQL 5.5, 5.6, 5.7, and 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 | | | |
TencentDB for MySQL 5.5, 5.6, 5.7, and 8.0 Sync between databases under the same Tencent Cloud root account Sync between databases under different Tencent Cloud root accounts | | | |
MariaDB > MySQL
Source Database and Version | Target Database and Version | Migration Type | Reference Documentation |
Self-Built Database IDC self-built MariaDB 5.5, 10.0-10.6 Self-built MariaDB 5.5, 10.0-10.6 on CVM | TencentDB for MySQL 5.5, 5.6, 5.7, and 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) Sync between databases under the same Tencent Cloud root account. | | | |
Percona > MySQL
Source Database and Version | Target Database and Version | Migration Type | Reference Documentation |
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 | TencentDB for MySQL 5.5, 5.6, 5.7, and 8.0 | Structure migration Full migration Full + incremental migration |
TDSQL MySQL > MySQL
Source Database and Version | Target Database and Version | Migration Type | Reference Documentation |
TencentDB for MySQL (database versions: MySQL 8.0, Percona 5.7, MariaDB 10.1) Migration between databases under the same root account | TencentDB for MySQL | Structure migration Full migration Full + incremental migration | |
| | | |
Migrating to MariaDB
MySQL > MariaDB
Source Database and Version | Target Database and Version | Migration Type | Reference Documentation |
Self-Built Database IDC self-built MySQL 5.5, 5.6, 5.7, 8.0 Self-built MySQL 5.5, 5.6, 5.7, 8.0 on CVM | 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, and 8.0 Sync between databases under the same Tencent Cloud root account Sync between databases under different Tencent Cloud root accounts | | | |
MariaDB > MariaDB
Source Database and Version | Target Database and Version | Migration Type | Reference Documentation |
Self-Built Database IDC self-built MariaDB 5.5, 10.0-10.6 Self-built MariaDB 5.5, 10.0-10.6 on CVM | 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) Sync between databases under the same Tencent Cloud root account | | | |
Percona > MariaDB
Source Database and Version | Target Database and Version | Migration Type | Reference Documentation |
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 | 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 MySQL > MariaDB
Source Database and Version | Target Database and Version | Migration Type | Reference Documentation |
TencentDB for MySQL (Database versions: MySQL 8.0, Percona 5.7, MariaDB 10.1) Migration between databases under the same root account | 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
Source Database and Version | Target Database and Version | Migration Type | Reference Documentation |
Self-Built Database IDC self-built MySQL 5.5, 5.6, 5.7, 8.0 Self-built MySQL 5.5, 5.6, 5.7, 8.0 on CVM | 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 | | | |
TencentDB for MySQL 5.5, 5.6, 5.7, and 8.0 Sync between databases under the same Tencent Cloud root account Sync between databases under different Tencent Cloud root accounts | | | |
MariaDB > TDSQL-C MySQL
Source Database and Version | Target Database and Version | Migration Type | Reference Documentation |
Self-Built Database IDC self-built MariaDB 5.5, 10.0-10.6 Self-built MariaDB 5.5, 10.0-10.6 on CVM | 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) Sync between databases under the same Tencent Cloud root account | | | |
Percona > TDSQL-C MySQL
Source Database and Version | Target Database and Version | Migration Type | Reference Documentation |
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-C for MySQL 5.7, 8.0 | Structure migration Full migration Full + incremental migration |
TDSQL MySQL > TDSQL-C MySQL
Source Database and Version | Target Database and Versionn | Migration Type | Reference Documentation |
TencentDB for MySQL (database versions: MySQL 8.0, Percona 5.7, MariaDB 10.1) Migration between databases under the same root account | TDSQL-C for MySQL 5.7, 8.0 | Full migration Full + incremental migration | |
| | | |
Migrating to TDSQL MySQL
MySQL > TDSQL MySQL
Source Database and Version | Target Database and Version | Migration Type | Reference Documentation |
Self-Built Database IDC self-built MySQL 5.6, 5.7, 8.0 Self-built MySQL 5.6,5.7,8.0 on CVM | TDSQL for MySQL (database version MySQL 8.0) | Full migration Full + incremental migration | |
TencentDB for MySQL 5.6,5.7,8.0 Sync between databases under the same Tencent Cloud root account Sync between databases under different Tencent Cloud root accounts | | | |
MariaDB > TDSQL 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.
Source Database and Version | Target Database and Version | Migration Type | Reference Documentation |
Self-Built Database IDC self-built MariaDB 5.5, 10.0-10.6 Self-built MariaDB 5.5, 10.0-10.6 on CVM | TencentDB for MySQL (database version: MariaDB 10.1) | Full migration Full + incremental migration | |
TencentDB for MariaDB (Database versions: MySQL 8.0, Percona 5.7, MariaDB 10.1, MariaDB 10.4) Sync between databases under the same Tencent Cloud root account | | | |
Percona > TDSQL MySQL
Source Database and Version | Target Database and Version | Migration Type | Reference Documentation |
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 | TencentDB for TDSQL for MySQL (database version: Percona 5.7) | Full migration Full + incremental migration |
TDSQL-C MySQL > TDSQL MySQL
Source Database and Version | Target Database and Version | Migration Type | Reference Documentation |
TDSQL-C for MySQL 5.7, 8.0 | TencentDB for MySQL (database versions: MySQL 8.0, Percona 5.7, MariaDB 10.1) | Full migration Full + incremental migration |
TDSQL MySQL > TDSQL MySQL
Source Database and Version | Target Database and Version | Migration Type | Reference Documentation |
TencentDB TDSQL MySQL
(Database versions: MySQL 8.0, Percona 5.7, MariaDB 10.1) Migration between databases under the same root account | TencentDB for TDSQL MySQL (Database versions: MySQL 8.0, Percona 5.7, MariaDB 10.1) | Structure migration Full migration Full + incremental migration | |
| | | |
MySQL > TDSQL MySQL(TDStore)
Source Database and Version | Target Database and Version | Migration Type | Reference Documentation |
Self-Built Database IDC self-built MySQL 5.5, 5.6, 5.7, 8.0 Self-built MySQL 5.5, 5.6, 5.7, 8.0 on CVM | TencentDB for TDSQL MySQL (TDStore) | Structure migration Full migration Full + incremental migration | |
TencentDB for MySQL 5.5, 5.6, 5.7, and 8.0 Sync between databases under the same Tencent Cloud root account Sync between databases under different Tencent Cloud root accounts | | | |
MariaDB > TDSQL MySQL(TDStore)
Source Database and Version | Target Database and Version | Migration Type | Reference Documentation |
Self-Built Database IDC self-built MariaDB 5.5, 10.0-10.6 Self-built MariaDB 5.5, 10.0-10.6 on CVM | TencentDB for TDSQL 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) Sync between databases under the same Tencent Cloud root account | | | |
Percona > TDSQL MySQL(TDStore)
Source Database and Version | Target Database and Version | Migration Type | Reference Documentation |
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 | TencentDB for TDSQL MySQL (TDStore) | Structure migration Full migration Full + incremental migration |
TDSQL MySQL > TDSQL MySQL(TDStore)
Source Database and Version | Target Database and Version | Migration Type | Reference Documentation |
TencentDB for TDSQL MySQL
(Database versions: MySQL 8.0, Percona 5.7, MariaDB 10.1) Migration between databases under the same root account | TencentDB for TDSQL MySQL (TDStore) | Structure migration Full migration Full + incremental migration |
Migrating to PostgreSQL
PostgreSQL > PostgreSQL
Only versions 9.4 and above support incremental migration.
Source Database and Version | Target Database and Version | Migration Type | Reference Documentation |
Self-built PostgreSQL Databases 9.3, 9.4, 9.5, 9.6, 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 9.3, 9.4, 9.5, 9.6, 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
Source Database | Target Database | Migration Type | Reference Documentation |
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
Source Database | Target Database | Migration Type | Reference Documentation |
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 3.0, 3.2, 3.4, 3.6, 4.0, 4.2, 4.4, 5.0, 6.0 on CVM | TencentDB for MongoDB 3.0, 3.2, 3.4, 3.6, 4.0, 4.4, 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
Source Database | Target Database | Migration Type | Reference Documentation |
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
Source Database | Target Database | Migration Type | Reference Documentation |
Self-Built Database IDC self-built Redis 2.8, 3.0, 3.2, 4.0, 5.0, 6.0 Self-built Redis 2.8, 3.0, 3.2, 4.0, 5.0, 6.0 on CVM | TencentDB for Redis 2.8, 3.0, 3.2, 4.0, 5.0, 6.0 | Full + incremental migration | |
Third-Party cloud vendors AWS ElasticCaChe for Redis 4.0,5.0,6.0 | | | |
TencentDB for Redis 2.8, 3.0, 3.2, 4.0, 5.0, 6.0 Migration between databases under the same root account Database migration between different root accounts (requires
Submit a Ticket application) | | | |
Migrating to KeeWiDB
Redis > KeeWiDB
Source Database | Target Database | Migration Type | Reference Documentation |
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 (requires ticket submission) | | | |
Tendis > KeeWiDB
Source Database | Target Database | Migration Type | Reference Documentation |
TencentDB for Tedis 4.9 Migration between databases under the same root account Database migration between different root accounts (requires ticket submission) | KeeWiDB 1.0 | Full + incremental migration |
Yes
No
Was this page helpful?