Overview|OceanBase Cloud| docs|Distributed Database

Overview

Last Updated：2025-06-24 11:54:39 Updated

This topic describes the application scenarios and procedure for compatibility assessment.

Compatibility assessment

Before you perform data migration in the OceanBase Cloud console, you can use the compatibility assessment service to analyze the objects and SQL statements in your database. The compatibility assessment service provides automated transformation solutions based on the best practices of migration to OceanBase Database to help you reduce the technical difficulties and reconstruction costs in migration to cloud.

At present, the compatibility assessment service can assess the compatibility of objects and SQL statements of databases, and supports database profiling.

Feature	Description
Database object assessment	The compatibility assessment service can directly connect to the source database, automatically obtain information about objects in the source database, and assess the compatibility of the source database with OceanBase Database. At present, only Aurora MySQL is supported as the source database.
SQL statement assessment	The compatibility assessment service can assess the compatibility of SQL statements separated with double dollar signs ($$) in text files. The compatibility assessment service can directly parse SQL statements from MyBatis and iBatis files for compatibility assessment.
Database Profile	The compatibility assessment service can connect to a source database instance and obtain the following basic information about the database instance: System information such as the CPU, memory, and disk information Business information such as the table schemas, proportion of table space to disk space, table growth rate, whether indexes are used in tables, and whether tables have visits Business SQL information such as whether full table scans are performed and whether multiple JOIN and WITH statements exist The compatibility assessment service can provide optimization and rewrite suggestions on specific SQL statements.

The compatibility assessment procedure is:

Collect database objects.
Execute the compatibility assessment task.

Two assessment modes are supported: online assessment and offline assessment. For more information, see Perform online assessment and Perform offline assessment.
Execute assessment and generate a report.

After the assessment task is started, the compatibility assessment service will generate an assessment report based on the selected assessment type.
View and download the assessment report.

After the assessment report is generated, you can view and download it. For more information, see View and download a compatibility assessment report.

Application scenarios

During the entire lifecycle of data migration from a source database to OceanBase Database, compatibility assessment is performed before data migration. You can use the compatibility assessment service to profile the source database to understand the database topology, application topology, and overall system load so as to formulate an appropriate data migration strategy.

In addition, the compatibility assessment service is capable of compatibility assessment for objects and SQL statements of the source database. This enables you to understand and handle the incompatibilities of the source database with OceanBase Database before migration, so as to ensure smooth data migration.