All Products
Search
Document Center

Evaluate a database

Last Updated: Dec 13, 2021

Advanced Database & Application Migration (ADAM) allows you to evaluate the compatibility and specifications of destination databases, and migration risks. This helps you further understand the feasibility of migrating databases to the cloud and transformation cost.

Create a project

  1. Log on to the ADAM console.

  2. In the left-side navigation pane, click Evaluate DB.

  3. In the Source DB Profile step, select a database profile, and click Next: Select Destination Database.

  4. In the Select Destination DB step, click Next: Create Destination DB Evaluation Project to create an evaluation project.

  5. In the Create Project panel, set the following parameters.

    • Project Name: the name of the project. This parameter is required.

    • Source Database Profile: Select a database profile.

    • Project Type: Select the type of the destination database.

    • Destination Database Version: the version of the destination database. This parameter is required.

    • Kernel Version: If you set Project Type to PolarDB O Edition Engine, this parameter is required.

    • Report Language: the language of the evaluation reports.

  6. Click Create. The evaluation project is created and automatically performed.

Note

You can also click + Create Project in the Evaluate Dest. DB step to create an evaluation project.

Evaluation Overview

In the project list, you can view the status and progress of the evaluation project. After the evaluation is complete, click Details in the Actions column to view the compatibility evaluation results of the destination database. The following sections are displayed: Project Summary, Evaluation Overview, and Evaluation Details.

The Evaluation Overview section includes the following subsections: Compatibility, Transformation, Specifications, Risks and Overall Compatibility.

  • Compatibility: the compatibility between the source and destination databases. The higher the value, the fewer the SQL statements and objects that need to be transformed.

  • Transformation: the number of focus areas of the destination database transformation.

    • Object Transformation: Database objects transformed by ADAM do not need to be modified.

    • Application Transformation: The focus areas of application transformation are obtained by analyzing SQL statements collected from the database during preliminary evaluation.

  • Specifications: the required specifications of the destination database and migration cost calculated by ADAM based on collected data. The evaluation of the specifications is subject to the data collection environment. Purchase databases based on your business requirements.

  • Risks: the existing risks of the source database and risks that may arise when the database is migrated. This dimension provides you with warnings about database migration and transformation.

  • Overall Compatibility: the overall compatibility between the source and destination databases.

Evaluation Details

The Evaluation Details section is shown from the following dimensions: Object Compatibility, SQL Compatibility, Object Transformation, Destination DB Specifications, Migration Risk, and Project Dependency (Schema).

In the Evaluation Details section, click Details in the Actions column to view the details of each evaluation item.

Object Compatibility

The Schema Compatibility panel shows the evaluation results of all database objects, including compatible and incompatible database objects.

ADAM provides the transformed DDL statements and focus areas of transformation for objects that can be compatible after transformation. ADAM also explains why objects are incompatible and provides suggestions to transform them.

SQL Compatibility

The SQL Compatibility panel shows the evaluation results of SQL statements collected from the source database.

Click the Evaluation Summary tab to view the overview of the evaluation results. The overall evaluation results of SQL statements that are compatible, incompatible, and compatible after transformation are shown.

Click the Evaluation Details tab to view the compatibility details of SQL statements. The detailed evaluation results of SQL statements are shown from the following dimensions: compatibility, source SQL statements, and destination SQL statements.

  • Click View in the Source SQL Statements column to view the details of the source SQL statements.

  • Click View in the Destination SQL Statements column to view the details of the destination SQL statements. On the Error Message or Edit Information tab of the Destination SQL Statements panel, view the cause of incompatibility or information to be modified.

Note

ADAM evaluates the compatibility of SQL statements based on SQL statements executed and recorded in the database. You need to decide whether a specific SQL statement was issued by your business by using the ADAM application evaluation feature.

Click the Rule Details tab to view the detailed compatibility rules.

Object Transformation

The Project Transformation panel lists the focus areas of database transformation. You can transform your database objects based on these focus areas. You can also apply to use the ADAM database transformation feature to transform database objects. Some objects may need to be manually modified.

Transformation Level: All database objects that need to be transformed are classified by transformation difficulty to help you schedule transformation tasks. The higher the transformation level, the more difficult the transformation.

Click View in the Source DDL Operation column to view the source DDL operation.

Click View in the Destination DDL Operation column to view the destination DDL operation.

Click Database in the Transformation column to view the ID and transformation method of the focus area.

Destination DB Specifications

The Destination Database Solution panel provides specifications and migration plan guidelines to help you migrate databases to Alibaba Cloud.

The recommended destination database specifications are generated based on the configurations, performance, SQL, and external dependencies of the source database, and the comprehensive analysis of the source and destination databases.

On the Destination Database Solution tab, click Details in the Actions column to view the details of the objects in each migration group.

On the Cross-database Objects tab, click Details to view details of cross-database objects. A solution that has multiple instances may contain cross-database objects.

Migration Risk

Migration risks include risks from source and destination databases.

Risks from the source database may arise when you execute SQL statements that cause high CPU utilization and memory usage in the source database, such as SQL statements of the TOP CPU and TOP Buffer types.

Risks from the destination database may arise when you transform database schemas or execute SQL statements in the destination database. You must focus on migration risks to prevent performance differences caused by heterogeneous database migration.

Project Dependency (Schema)

The Project Dependency (Schema) panel shows dependent objects, referenced objects, and provides suggestions on these objects.

Download the evaluation reports

ADAM allows you to download the evaluation reports of your database.

In the Evaluation Details section, click Download All Reports to download all the evaluation reports of your database.

What to do next

In the Evaluation Details section, click Start DB Transformation to start database transformation. For more information, see Transform and migrate a database.