This topic describes how to view and download a compatibility assessment report after you complete an assessment task.
Limitations
Only users with the roles Project Admin and Data Services Admin are allowed to download the compatibility assessment reports.
You can view or download compatibility assessment reports only for tasks that are in the Completed state.
View an assessment report
Log on to the OceanBase Cloud console.
In the left-side navigation pane, click Data Services > Migrations.
On the Migrations page, click the Assess Compatibility tab.
On the Assess Compatibility tab, click View Report next to the target assessment task.
You can view the assessment details on the tabs of different assessment types.
Object Assessment: displays the compatibility information of different types of objects, as well as the incompatibilities and optimization suggestions. To view specific DDL statements, click the name of the corresponding schema and view DDL statements of all the objects under this schema.
SQL Assessment: displays all collected SQL statements and their compatibility information. The SQL statements are aggregated based on the SQL IDs. The assessment report will show the incompatibilities if any. You can view the details in the incompatibility list.
Database Profile: displays the basic information of the source database, such as the basic load information, proportion of tablespace to disk space, table growth rate, whether tables use indexes, and whether tables have no visits. In addition, the compatibility assessment service analyzes all SQL statements and displays the slow SQL statements, complex SQL statements, and corresponding optimization suggestions.
Download an assessment report
Log on to the OceanBase Cloud console.
In the left-side navigation pane, click Data Services > Migrations.
On the Migrations page, click the Assess Compatibility tab.
On the Assess Compatibility tab, click Download Report next to the target assessment task to open the assessment report in the PDF format.
Click the Download icon in the upper-right corner of the assessment report to download it.