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 the migration assessment service. This feature assesses SQL compatibility based on the files that you provide and generates an assessment report. Supported file types are SQL files, MyBatis files, iBatis files, and files collected by the migration assessment service.

Limitations

Only users with the AliyunOceanBaseFullAccess permission can create offline assessment tasks. For more information about the permission policy, see AliyunOceanBaseFullAccess.

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 New Assessment Task page, configure the parameters.

   

   Parameter	Description
   Assessment Task Name	The task name cannot exceed 30 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, MyBatis, iBatis, and File Collected by Migration Assessment. You can click How to Obtain File to view more information. SQL: SQL files are text files where SQL statements are separated with double dollar signs ($$). MyBatis: One or multiple SQL configuration files in MyBatis are compressed into a ZIP package and then uploaded to the migration assessment service for assessment. iBatis: One or multiple SQL configuration files in iBatis are compressed into a ZIP package and then uploaded to the migration assessment service for assessment. File Collected by Migration Assessment: You can download the migration assessment collector, use it to collect data, and upload the file of collected data to the migration assessment service. For more information, see Collect database objects by using the migration assessment 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.