This topic describes the system architecture of OceanBase Migration Assessment (OMA).
OMA is an intermediate tool to connect the to-be-assessed database to the destination database. The database to be assessed is usually an Oracle or MySQL database, and the destination database is usually an OceanBase database. OceanBase Database offers OB Parser, a built-in syntax parser, to assess the compatibility with collected objects and SQL statements and generate an assessment report for your reference.
The workflow of OMA is divided into three steps:
OMA collects objects and SQL statements from the database to be assessed or the workload capture replay (WCR) files.
The built-in OB parser performs compatibility analysis on the collected objects and SQL statements.
OMA generates an assessment report or replays the objects and SQL statements in the destination database depending on the scenarios.
In the replay scenario, OMA replays the SQL statements collected from the source database in the destination database in sequence based on the real traffic and generates a replay report for your reference.