OceanBase
English日本語简体中文
Docs Home
Products
Integrations
Release Notes

Databases

OceanBase DatabaseOceanBase Cloud OceanBase Best Practices

Tools

OceanBase Cloud PlatformOceanBase Migration ServiceOceanBase Developer CenterOceanBase Migration AssessmentOceanBase Admin ToolOceanBase Loader and DumperOceanBase DeployerKubernetes operator for OceanBaseOceanBase Diagnostic Tool OceanBase Binlog Service

Connectors and Middleware

OceanBase Database Proxy OceanBase Connector/C OceanBase Connector/J OceanBase Connector/ODBC OceanBase Connector/NETOceanBase Command-Line Client

Databases

OceanBase DatabaseOceanBase Cloud OceanBase Best Practices

Connectors and Middleware

OceanBase Database Proxy OceanBase Connector/C OceanBase Connector/J OceanBase Connector/ODBC OceanBase Connector/NETOceanBase Command-Line Client

Tools

OceanBase Cloud PlatformOceanBase Migration ServiceOceanBase Developer CenterOceanBase Migration AssessmentOceanBase Admin ToolOceanBase Loader and DumperOceanBase DeployerKubernetes operator for OceanBaseOceanBase Diagnostic Tool OceanBase Binlog Service
OceanBase DatabaseOceanBase Cloud ToolsConnectors and MiddlewareLifecycle Support Policy

OceanBase Migration Assessment

V4.4.2Enterprise Edition
  • Product Introduction
    • Overview
    • Application scenarios
    • System architecture
    • Product form
  • Install OMA
  • Compatibility assessment
    • Overview
    • Assess the compatibility with objects
    • Assess the compatibility with SQL statements
    • Assess the compatibility with business code
    • Export SQL statements from an OceanBase database
    • Database assessment
      • Overview
      • Assess an Oracle database
      • Assess a MySQL database
      • Assess a TiDB database
      • Assess a PostgreSQL database
      • Assess a DB2 LUW database
  • Performance assessment
    • Standalone edition
      • Overview
      • Assess the performance differences between an Oracle database and an OceanBase database
      • Assess the performance differences between a MySQL database and an OceanBase database
      • Assess the performance differences between different versions of OceanBase Database

Download PDF

  1. Documentation Center
  3. OceanBase Migration Assessment

OceanBase Migration Assessment

OceanBase Migration Assessment (OMA) collects object and SQL information from databases and uses the built-in OceanBase syntax parser to assess compatibility and generate reports. For workload replay, OMA replays collected source SQL against the target database in its original sequence and with actual traffic patterns, then generates a replay report.

Download

User Guide

Install and Deploy OMA

OMA Compatibility Assessment

OMA Load Replay

  1. 1
    Key feature of OMA

    Before using OMA, familiarize yourself with its core capabilities, including supported assessment objects and database versions, compatibility assessment, and performance assessment.

    For more information, refer to "OMA features and benefits".

  2. 2
    Install OMA

    Learn about OMA configuration requirements, deployment options, and basic usage.

    For more information, refer to "Install OMA".

  1. 1
    OMA compatibility assessment

    OMA assesses the compatibility of migrating Oracle, MySQL, PostgreSQL, TiDB, DB2 LUW, RDS MySQL, Polar MySQL, Polar O, and DRDS databases to OceanBase Database and generates compatibility assessment reports.

    For more information, refer to "Compatibility assessment".

  1. 1
    OMA Load Replay

    For heterogeneous database migrations or major-version upgrades, use OMA load replay to quickly identify potential performance differences and risks, and optimize accordingly.

    For more information, refer to "Performance assessment".