OceanBase Migration Assessment (OMA) provides accurate compatibility assessment for data migration. This topic describes the types and versions of databases that support compatibility assessment.
Background information
OMA assesses the compatibility of converting database objects of Oracle Database, MySQL, PostgreSQL, TiDB, DB2 LUW, RDS for MySQL, PolarDB for MySQL, PolarDB for Oracle, DRDS, SQL Server, openGauss, and OceanBase Database instances (both MySQL and Oracle tenants) to database objects of OceanBase Database, and provides profile analysis and automatic conversion solutions.
Supported types and versions of databases
Source databases
| Database type | Database version |
|---|---|
| RDS for MySQL | All versions |
| DRDS | All versions |
| TDSQL for MySQL | All versions |
| MariaDB | All versions |
| MySQL | V5.6, V5.7, and V8.0 |
| TiDB | V3.0, V4.0, and V5.0 |
| Oracle Database | 11g, 12c, 18c, and 19c
NoticeOMA replays the workload capture replay (WCR) files of only 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 tenant of OceanBase Database | V2.2.0, V3.2.2, V3.2.3, V3.2.4, V4.0.0, and V4.1.0 |
| Oracle tenant of OceanBase Database | V2.2.5, V2.2.7, V3.1.2, V3.2.2, V3.2.3, V3.2.4, V4.0.0, and V4.1.0 |
Target databases
| Database type | Database version |
|---|---|
| MySQL tenant 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, and V4.2.2 |
| Oracle tenant 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, and V4.2.2 |