Perform an offline evaluation

Background information

Migration Evaluation supports offline evaluation for systems that cannot connect directly to a source database from the public cloud. You provide the files for evaluation. The offline evaluation feature assesses SQL compatibility using SQL files, persistence frameworks such as MyBatis and iBatis, or files collected by Migration Evaluation. After the assessment is complete, an evaluation report is generated.

Limits

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

Procedure

1. Create an offline evaluation task.

   1. Log on to the OceanBase Management Console .

   2. In the navigation pane on the left, click Migration Evaluation > Compatibility Evaluation.

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

2. On the Create Evaluation Task page, configure the parameters.

   

   Parameter	Description
   Evaluation task name	The name cannot exceed 30 characters in length.
   Evaluation type	Currently, only Compatibility Evaluation is supported.
   Source database type	Select the source database type from the drop-down list. Oracle, MySQL, and DB2 LUW are supported.
   File type	Upload the files that you want to evaluate to the cloud for offline evaluation. Supported file types include SQL files, MyBatis files, iBatis files, and collection files. Click How to Obtain Files to view details. SQL file: A text file that uses $$ to separate SQL statements. MyBatis file: Compress one or more SQL configuration files from MyBatis into a .zip package and upload the package. iBatis file: Compress one or more SQL configuration files from iBatis into a .zip package and upload the package. Migration Evaluation collection file: Download the Migration Evaluation data collector to collect data. After collection, upload the files to the cloud for evaluation. For more information, see Collect database objects using the Migration Evaluation data collector.
   Upload file	Click Upload File and select the files that you want to evaluate. You can upload multiple files to generate a single evaluation report.

3. Click Start Evaluation to start the offline evaluation task.