Perform an online evaluation

Background information

Online evaluation connects to the source database to collect information, such as objects, SQL statements, and database load. It then compares this information with the capabilities of OceanBase Database to identify incompatibilities and provide solutions.

Limits

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

Procedure

1. Create an online 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 Compatibility Evaluation page, click Create Evaluation Task > Online Evaluation in the upper-right corner.

2. On the Select Source Database Type page, configure the parameters.

   

   Parameter	Description
   Evaluation Task Name	The name cannot exceed 30 characters in length.
   Source Database Type	Includes Oracle and MySQL.
   Target Database Type	Automatically populated based on the selected source database type.
   Source Data Source	If you have a data source, select it from the drop-down list. If you do not have a data source, click Create Data Source next to the drop-down list. For more information about the parameters, see Create a data source.

3. Click Next.

4. On the Select Evaluation Type page, select an evaluation type and configure its parameters.

   

   Parameter	Description
   Select Evaluation Type	Includes Object Evaluation and Database Profile Evaluation. Object evaluation collects the Data Definition Language (DDL) statements for objects such as TABLE, VIEW, and TRIGGER. It then evaluates the compatibility of these objects with OceanBase Database, identifies incompatibilities, and suggests changes. Object evaluation is selected by default and you cannot clear this selection. Database profile evaluation includes object evaluation and SQL evaluation. It also scans for and collects statistics on abnormal and slow SQL statements. The feature analyzes the total data volume, table storage space, and system information to provide comprehensive data migration recommendations.
   Select Object Type	Supported object types include TABLE, VIEW, TRIGGER, FUNCTION, PROCEDURE, and EVENT. Select the object types as needed.
   Select Schema	In the Source List area on the left, select the target schema and click > to add it to the list on the right.

5. Click Start Evaluation.

6. In the dialog box that appears, click OK to start the online evaluation task.

   Note

   Starting an evaluation task connects to your configured database. The process retrieves necessary dictionary information, which may place some load on the database.