tencent cloud

Feedback

Databases Supported by Data Migration

Last updated: 2024-07-08 19:41:52

    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

    Data migration feature for AWS ElasticCache for Redis requires Submit a Ticket application.
    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
    Contact Us

    Contact our sales team or business advisors to help your business.

    Technical Support

    Open a ticket if you're looking for further assistance. Our Ticket is 7x24 avaliable.

    7x24 Phone Support