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 |
|
| Database Profile |
|
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.
