OceanBase Migration Assessment (OMA) provides precise compatibility assessment for data migration. This topic describes the types and versions of databases that support compatibility assessment.
Basic information
OMA assesses the compatibility with converting instances of Oracle, MySQL, PostgreSQL, TiDB, DB2 LUW, RDS for MySQL, PolarDB for MySQL, PolarDB for Oracle, DRDS, SQL Server, openGauss, and OceanBase Database (including MySQL and Oracle compatible modes) to OceanBase Database. It also provides database profile analysis and automatic object conversion solutions.
Supported database types and versions
The following table describes the database types and versions that support compatibility assessment. If the version you are using is not listed, use the closest version. For example, if you have deployed OceanBase Database V4.3.5, you can specify OceanBase Database V4.2.2 as the target version in the assessment command. OMA will promptly match the latest OceanBase Database version.
Supported source databases
| Database type | Database version |
|---|---|
| RDS for MySQL | All versions |
| DRDS | All versions |
| TDSQL for Cloud MySQL | All versions |
| MariaDB | All versions |
| MySQL | V5.6, V5.7, and V8.0 |
| TiDB | V3.0, V4.0, and V5.0 |
| Oracle | 11g, 12c, 18c, and 19c
NoticeOMA can replay only the workload capture files of Oracle Database 11g, 12c, 18c, and 19c. |
| PostgreSQL | V9, V10, V11, V12, V13, and V14 |
| openGauss | All versions |
| DB2 LUW | V10.1.0, V10.5.0, V11.1, and V11.5 |
| SQL Server | All versions |
| PolarDB for MySQL | All versions |
| PolarDB for Oracle | All versions |
| MySQL compatible mode of OceanBase Database | V2.2.0, V3.2.2, V3.2.3, V3.2.4, V4.0.0, and V4.1.0 |
| Oracle compatible mode of OceanBase Database | V2.2.5, V2.2.7, V3.1.2, V3.2.2, V3.2.3, V3.2.4, V4.0.0, V4.1.0, V4.2.0, V4.2.1, V4.2.2, V4.2.5, and V4.3.5 |
Supported target databases
| Database type | Database version |
|---|---|
| MySQL compatible mode of OceanBase Database | V2.2.0, V3.2.2, V3.2.3, V3.2.4, V4.0.0, V4.1.0, V4.2.0, V4.2.1, V4.2.2, V4.2.5, and V4.3.5 |
| Oracle compatible mode of OceanBase Database | V2.2.5, V2.2.7, V3.1.2, V3.2.2, V3.2.3, V3.2.4, V4.0.0, V4.1.0, V4.2.0, V4.2.1, V4.2.2, V4.2.5, and V4.3.5 |