OceanBase Migration Assessment (OMA) is a database compatibility assessment tool provided by OceanBase Database. OMA provides precise compatibility assessment, efficient performance assessment, comprehensive recommendations on the distribution mode, and application reconstruction suggestions to help you effectively migrate data to OceanBase Database.
Features and benefits
Lightweight installation and ease of use
You can directly decompress the downloaded OMA package without installing a CLI tool.
When you use OMA for compatibility and performance assessment, you need to only specify the assessment parameters and run the assessment script to obtain an assessment report.
Security and reliability
OMA uses a single thread to scan the metadata of databases. This ensures data security.
Comprehensiveness
OMA supports the assessment of various database types such as Oracle, MySQL, PostgreSQL, and DB2 LUW. It also supports compatibility, performance, and distribution mode assessments of database objects, such as tables, indexes, views, sequences, synonyms, functions, procedures, packages, and triggers, and all SQL statements in the databases.
Smart recommendations
If OMA identifies that your existing database is not fully compatible with the distributed architecture of OceanBase Database, it provides a transformation solution for migrating your database to OceanBase Database based on the best practices accumulated over the years.
Features
Compatibility assessment
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 during data migration or synchronization. OMA also generates an assessment report after the assessment is complete. The assessment report for compatibility with the Oracle and MySQL databases lists specific causes of the incompatibility and suggests corresponding solutions. The assessment reports list only the reasons for the incompatibility with other types of database instances.
OMA can assess the objects and SQL or PL statements of databases.
Database object assessment
You can directly connect OMA to the source database, automatically obtain information about objects in the source database, and assess the compatibility of OceanBase Database with the source database.
OMA can assess the compatibility of DDL statements in Oracle and MySQL databases. It can also assess DDL statements separated with double dollar signs ($$) in TEXT files.
You can use a lightweight client to connect OMA to an Oracle database and export DDL statements for compatibility assessment.
OMA can directly read the DDL statements exported by using MySQLDump for compatibility assessment.
OMA allows you to use db2look to export DDL statements for compatibility assessment.
Assessment of SQL or PL statements
You can directly connect OMA to an Oracle database, scan the V$SQL view to obtain SQL statements of the corresponding schema, and then assess the compatibility of these SQL statements with OceanBase Database.
OMA can assess the compatibility of SQL or PL statements that are separated with semicolons (;) or double dollar signs ($$) in TEXT files.
OMA can directly parse SQL statements in MyBatis and iBatis files to assess the compatibility of these statements.
You can directly connect OMA to an Oracle database, periodically scan the V$SQL view to obtain all SQL statements in a specific period, and then assess these SQL statements.
You can directly connect OMA to a DB2 LUW database, periodically scan the snapshots for dynamic SQL statements to obtain all SQL statements in a specific period, and then assess these SQL statements.
Database assessment
The database assessment feature allows you to assess objects, SQL statements, and database profiles in one assessment task and view the corresponding assessment results in one report.
OMA supports different database assessment modes for Oracle, MySQL, TiDB, PostgreSQL, and DB2 LUW databases. For more information, see Database assessment.
Performance assessment
OMA supports SQL replay and stress testing.
You can connect OMA to the source database, collect SELECT statements, and then replay the SQL statements in an OceanBase database to verify the compatibility of the SQL statements and the performance of OceanBase Database.
OMA allows you to collect the workload capture replay (WCR) files of an Oracle database, parse the WCR files to obtain SQL statements, and then assess the compatibility of the SQL statements. You can also replay the SQL statements in an OceanBase database to verify their accuracy and performance.
OMA can parse and replay the general log files of MySQL databases.
During the upgrade of an OceanBase database, OMA supports pulling query statements from the database before the upgrade and replaying the statements in the database after the upgrade.
Object and SQL statement export from OceanBase Database
OMA allows you to export DDL statements for objects in the corresponding schema from an OceanBase database.
OMA allows you to export all SQL statements in the SQL_AUDIT view for a specific period from an OceanBase database.