ApsaraDB for OceanBase:Execute offline assessment

Background

When your database system cannot be connected to the public cloud, you can use the offline assessment feature of OMA. You need to provide the files for assessment, and OMA will assess the DDL and DML statements in the files and generate corresponding assessment reports.

Procedure

1. Create an offline assessment task.

   1. Log on to the ApsaraDB for OceanBase console.

   2. In the left-side navigation pane, choose Migration Assessment > Compatibility Assessment.

   3. On the Assessment Tasks page, choose Create Assessment Task > Offline Assessment in the upper-right corner.

2. On the Create Assessment Task page, specify related parameters.

   Parameter	Description
   Assessment Task Name	The name cannot exceed 40 characters in length.
   Assessment Type	At present, only Compatibility Assessment is supported.
   Source Database Type	Select a source database type from the drop-down list. Valid values: Oracle, MySQL, and DB2 LUW.
   File Type	The type of the files uploaded for offline assessment. Valid values: SQL File, MyBatis File, iBatis File, and Collected File. You can click How to obtain files to view more information. SQL File: A text file where SQL statements are separated with double dollar signs ($$). MyBatis File: One or multiple SQL configuration files in MyBatis are compressed into a ZIP package and then uploaded to OMA for assessment. iBatis File: One or multiple SQL configuration files in iBatis are compressed into a ZIP package and then uploaded to OMA for assessment. Collected File: You can download the OMA collector to collect data, and upload files of the collected data to the cloud for assessment. For more information, see Collect database objects by using the OMA collector.
   Upload File	Click Upload File and select and upload the files for assessment. You can upload multiple files at a time, for which one assessment report is generated.

3. Click Initiate Assessment.

4. In the dialog box that appears, click OK.