Overview

#docslug#/oceanbase-database/oceanbase-database/V3.2.2/data-migration-overview-1 Data migration is a common O&M operation essential for cluster load balancing and IDC migration. You can use commands to perform operations such as data archiving for a cluster or for tables, disk-level load balancing, and resource unit migration in OceanBase Database. However, to perform operations such as data synchronization between heterogeneous data sources and between clusters, you need to use external tools.

This topic describes the following data migration methods and tools:

• Migrate data by using SQL scripts

• Migrate data by using MySQLDump

• Migrate data by using DataX

• Migrate data by using OUTFILE statements