Perform offline assessment

This topic describes how to perform offline compatibility assessment for a source database.

Background information

If the compatibility assessment service cannot connect to the source database, you can perform offline compatibility assessment. To do so, you need to provide files containing objects such as DDL and DML statements for assessment. After the assessment, an assessment report will be generated.

Limitations

Only users with the roles Project Admin and Data Services Admin are allowed to create the offline assessment tasks.

Procedure

1. Create an offline assessment task.

   

   1. Log on to the OceanBase Cloud console.

   2. In the left-side navigation pane, click Data Services > Migrations.

      The Assess Compatibility tab automatically appears.

   3. On the Assess Compatibility tab, click Create in the upper-right corner and then select Offline Assessment from the drop-down list.

   4. On the Assess Compatibility tab, click Create > Offline Assessment in the upper right corner.

2. On the Create Offline Assessment page, configure the parameters.

   1. Enter a custom name in the Task Name field. The task name cannot exceed 30 characters in length.

   2. In the Source Profile section, configure the parameters.

      Parameter	Description
      Cloud Vendor	Currently supports Amazon Cloud, Huawei Cloud, and Alibaba Cloud.
      Database Type	When you select Amazon Cloud as the cloud vendor, the database type supported is Aurora MySQL. When you select Huawei Cloud as the cloud vendor, the database types supported is RDS MySQL.
      Region	The region of the source database.
      Data Source	At present, SQL, MyBatis, and iBatis files are supported. SQL file: a text file where SQL statements are separated with double dollar signs ($$). MyBatis/iBatis file: One or more SQL configuration files in MyBatis/iBatis are compressed in the .zip format for uploading.
      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. For more information, see Obtain files for upload.

   3. In the Target Profile section, configure the variables.

      Parameter	Description
      Target Database Type	At present, only OceanBase MySQL Compatible Mode is supported.
      Target Database Version	Select the target database version from the drop-down list.

   4. In the Assessment Type section, select the assessment type.

      At present, Object Assessment and SQL Assessment are supported.

3. Click Start Assessment to start the offline assessment task.