ApsaraDB for OceanBase (Deprecated):Execute online assessment

Background

In online assessment, the migration assessment service directly connects to the source database and collects its information such as the objects, SQL statements, and database load. Then, it assesses the compatibility of the source database with ApsaraDB for OceanBase based on the collected information, identifies the incompatibilities, and provides optimization suggestions.

Limitations

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

Procedure

1. Create an online 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 > Online Assessment in the upper-right corner.

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

   

   Parameter	Description
   Assessment Task Name	The task name cannot exceed 30 characters in length.
   Source Database Type	Valid values: Oracle and MySQL.
   Target Database Type	This parameter is auto-populated based on the source database type you select.
   Source Data Source	If you have created a data source, select it from the drop-down list. If not, click Create Data Source on the right of the drop-down list to create one. For more information, see Create a data source.

3. Click Next.

4. On the Select Assessment Type page, select an assessment type and configure related parameters.

   

   Parameter	Description
   Select Assessment Type	Valid values: Object Assessment and Database Profile Assessment. During object assessment, DDL statements executed on database objects, such as tables, views, and triggers, are collected to assess their compatibility with ApsaraDB for OceanBase. The incompatibilities will be marked, and optimization suggestions will be provided. The option for object assessment is selected by default and cannot be deselected. In addition to performing object and SQL assessments, database profile assessment scans and collects statistics on abnormal and slow SQL statements. It also collects and analyzes database information, such as data volume, table storage space, and system settings, to provide comprehensive suggestions for data migration.
   Select Object Type	Supported object types are tables, views, triggers, functions, procedures, and events. You can select from them as needed.
   Select Schema	In the left-side Sources section, select the desired schema and click > to add it to the right-side list.

5. Click Initiate Assessment.

6. In the dialog box that appears, click OK.

   Note

   After an assessment task is initiated, the migration assessment service connects to the source and target databases you configured to perform assessment. Necessary dictionary information is required for assessment, which may put pressure on the databases.