Heterogeneous data migration refers to the migration of data from external data sources, such as MySQL, Oracle, PostgreSQL, or NoSQL databases, to OceanBase Database. This type of migration requires addressing data format conversion, structural adaptation, and cross-platform compatibility issues.
Migration scenarios
Heterogeneous data migration is suitable for the following scenarios:
- Database upgrade or replacement: Migrate the existing database system to OceanBase Database for better performance, scalability, or cost-effectiveness.
- Data integration: Integrate data from multiple database systems into a unified OceanBase Database platform.
- Architecture upgrade: Migrate data from a traditional database to a distributed database architecture.
In these data migration scenarios, you need to pay attention to the following aspects:
- Schema and data type mapping: Define the mapping rules between the source and target (OceanBase Database) data structures and types accurately. For example, convert the
DATETIMEdata type in MySQL to theTIMESTAMPdata type in OceanBase Database. - Performance optimization: For large-scale data migration, use efficient migration strategies such as parallel processing, sharding migration, and batch loading to shorten the migration window.
- Data consistency verification: After the migration is completed, verify the data integrity and accuracy by using hash verification, sampling comparison, or full comparison.
Related migration documents
OceanBase Database provides various heterogeneous data migration solutions. You can view the migration operation documents based on the source database type:
Migrate data from other databases to OceanBase Database
Migrate data from a MySQL database
- Migrate data from a MySQL database to a MySQL-compatible tenant of OceanBase Database by using OMS
- Migrate data from a MySQL database to a MySQL-compatible tenant of OceanBase Database by using MyDumper
- Migrate the schema of a MySQL database to a MySQL-compatible tenant of OceanBase Database by using DBCAT
- Migrate data from a MySQL database to a MySQL-compatible tenant of OceanBase Database by using DataX
- Migrate data from a MySQL database to a MySQL-compatible tenant of OceanBase Database by using CloudCanal
- Migrate data from a MySQL database to a MySQL-compatible tenant of OceanBase Database by using Canal
- Migrate data from a MySQL database to a MySQL-compatible tenant of OceanBase Database by using Flink CDC
- Migrate data from a MySQL database to a MySQL-compatible tenant of OceanBase Database by using ChunJun
Migrate data from an Oracle database
- Migrate data from an Oracle database to a MySQL-compatible tenant of OceanBase Database by using OMS
- Migrate data from an Oracle database to an Oracle-compatible tenant of OceanBase Database by using OMS
- Migrate data from an Oracle database to a MySQL-compatible tenant of OceanBase Database by using DBCAT
- Migrate data from an Oracle database to a MySQL-compatible tenant of OceanBase Database by using DataX
Migrate data from a PostgreSQL database
Migrate data from a DB2 LUW database
- Migrate data from a DB2 LUW database to a MySQL-compatible tenant of OceanBase Database by using OMS
- Migrate data from a DB2 LUW database to an Oracle-compatible tenant of OceanBase Database by using OMS
- Migrate the schema of a DB2 LUW table to OceanBase Database by using DBCAT
Migrate data from a TiDB database
Migrate data from OceanBase Database to another database
Migrate data from OceanBase Database to MySQL Database
- Use OMS to migrate data from an OceanBase Database (MySQL compatible mode tenant) to a MySQL database
- Use OMS to migrate incremental data from an OceanBase Database (Oracle compatible mode tenant) to a MySQL database
- Use DBCAT to migrate the table structure of OceanBase Database to a MySQL database
- Use DataX to migrate data from OceanBase Database to a MySQL database
- Use Canal to migrate data from OceanBase Database to a MySQL database
- Use CloudCanal to migrate data from OceanBase Database to a MySQL database
- Use Flink CDC to migrate data from OceanBase Database to a MySQL database
- Use ChunJun to migrate data from OceanBase Database to a MySQL database
Migrate data from OceanBase Database to Oracle Database
- Use OMS to migrate data from an OceanBase Database (Oracle compatible mode tenant) to an Oracle database
- Use DBCAT to migrate the table structure from an Oracle database to OceanBase Database
- Use DataX to migrate data from OceanBase Database to an Oracle database