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
Create an offline assessment task.
Log on to the OceanBase Cloud console.
In the left-side navigation pane, click Data Services > Migrations.
The Assess Compatibility tab automatically appears.
On the Assess Compatibility tab, click Create in the upper-right corner and then select Offline Assessment from the drop-down list.
On the Assess Compatibility tab, click Create > Offline Assessment in the upper right corner.
On the Create Offline Assessment page, configure the parameters.
Enter a custom name in the Task Name field. The task name cannot exceed 30 characters in length.
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. 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. In the Assessment Type section, select the assessment type.
At present, Object Assessment and SQL Assessmen are supported.
Click Start Assessment to start the offline assessment task.