Before migrating a heterogeneous database to Alibaba Cloud, use Advanced Database & Application Migration (ADAM) to evaluate the destination database. ADAM analyzes your source database and generates an evaluation report covering compatibility, recommended specifications, and migration risks—giving you the data to estimate transformation effort and confirm migration feasibility.
Prerequisites
Before you begin, ensure that you have:
Collected source database data and created a source database profile in ADAM
Access to the Data Management (DMS) console V5.0Data Management (DMS) V5.0 console
Create an evaluation project
If you are already on the Select Destination DB tab from an earlier step in the ADAM workflow, click Next: Select Destination Database to create an evaluation project directly. Otherwise, follow these steps.
Log on to the Data Management (DMS) console V5.0.
In the top navigation bar, move the pointer over Data + AI. Choose Heterogeneous Database Migration(ADAM) > Database Evaluation.
Click the Evaluate Dest. DB tab.
Click Create Project.
In the Create Project panel, configure the following parameters.
Parameter Description Project Name Enter a name for the evaluation project. The name carries over to subsequent database transformation and migration steps. Source Database Profile Select the source database profile that contains the collected data. Project Type Select the type of destination database. Destination Database Version Select the version of the destination database. Are you sure that you want to evaluate invalid objects? Specify whether to include invalid objects from the source database profile. During O&M or data migration, objects such as packages, procedures, functions, and views can become invalid. Select Yes to include them in the evaluation, or No to skip them. Kernel Version Required only if the destination database is a PolarDB for Oracle database. Report Language Select the language of the evaluation report: Chinese or English. Select schema Add the schemas to evaluate. In the Not Selected section on the left, select the schemas you want. Click the 
icon to move them to the Selected section on the right.Click Create.
ADAM analyzes your source database, identifies suitable destination database types, and generates an evaluation report.
View the evaluation result
Log on to the Data Management (DMS) console V5.0.
In the top navigation bar, move the pointer over Data + AI. Choose Heterogeneous Database Migration(ADAM) > Database Evaluation.
Click the Evaluate Dest. DB tab.
Find the evaluation project and click Details in the Actions column.
The evaluation is complete when the project status shows Complete.
On the evaluation details page, review the results across the following sections.
Project Summary: An overview of the project, including the project name, source database profile, source database type, project type, and destination database version.
Evaluation Overview: A summary of five dimensions that inform your migration planning:
Compatibility: Object compatibility and SQL compatibility. The higher the compatibility, the fewer the SQL statements and objects that need to be transformed.
Transformation: The number of areas requiring destination database transformation.
Object Transformation: Database objects that ADAM transforms automatically, with no manual modification needed.
Application Transformation: Areas of application transformation identified by analyzing SQL statements collected during the preliminary evaluation.
Specifications: The required specifications of the destination database and migration cost, calculated by ADAM based on collected data. Because the recommendations depend on the data collection environment, verify them against your actual business requirements before purchasing.
Risks: Existing risks in the source database and risks that may arise during migration. Review this dimension to identify issues that require attention before or during the migration.
Overall Compatibility: The combined object compatibility and SQL compatibility after migrating data from the source database to the destination database.
Evaluation Details: Drill into each evaluation item. Click Details in the Actions column for any item. For more information, see Evaluation details.
Optional: Download the evaluation report.
Click Download Simple Report, Download All Report, or Download HTML Report to download the report format you need.
Click Custom report to select specific sections to include.
Evaluation details
Object compatibility
The Schema Compatibility panel lists all evaluated database objects, grouped by compatibility status.
For objects that can be made compatible through transformation, ADAM provides the transformed DDL statements and identifies the specific areas that require transformation. For incompatible objects, ADAM explains the reason for incompatibility and provides suggestions.
SQL compatibility
The SQL Compatibility panel shows compatibility results for SQL statements collected from the source database.
Evaluation Summary tab: An overview of SQL statement compatibility—compatible, incompatible, and compatible after transformation.
Evaluation Details tab: Detailed results for each SQL statement across three dimensions: compatibility status, source SQL statement, and destination SQL statement.
Click View in the Source SQL Statements column to inspect the source SQL.
Click View in the Destination SQL Statements column to inspect the destination SQL. On the Error Message or Edit Information tab, see the cause of incompatibility or the modifications required.
Rule Details tab: The compatibility rules applied during evaluation.
ADAM evaluates SQL compatibility based on SQL statements executed and recorded in the destination database. To determine whether a specific SQL statement originated from your business workload, use the ADAM application evaluation feature.
Project transformation
The Project Transformation panel lists the specific areas of your source database that require transformation.
Each transformation item includes a Transformation Level that classifies the difficulty of the transformation. Higher levels indicate more complex transformations. Use the transformation level to prioritize and schedule your transformation work.
Click View in the Source DDL Operation column to see the source DDL operation.
Click View in the Destination DDL Operation column to see the destination DDL operation.
Click Database in the Transformation column to see the focus area ID and the recommended transformation method.
Destination database solution
The Destination Database Solution panel provides recommended specifications and a migration plan to guide your migration to Alibaba Cloud.
ADAM derives the recommended specifications from a comprehensive analysis of the source and destination databases, including configurations, performance data, SQL workload, and external dependencies.
On the Destination Database Solution tab, click Details in the Actions column to see the objects in each migration group.
On the Cross-database Objects tab, click Details to see cross-database objects. Solutions with multiple instances may include cross-database objects.
Migration risk
Migration risks come from two sources:
Source database risks: SQL statements that cause high CPU utilization and memory usage in the source database, such as TOP CPU and TOP Buffer queries.
Destination database risks: Issues that may arise when transforming database schemas or running SQL statements in the destination database.
Review migration risks carefully to avoid performance differences caused by the heterogeneous database migration.
Project dependency (schema)
The Project Dependency (Schema) panel shows dependent objects, referenced objects, and suggestions for handling them.
What's next
At the bottom of the Evaluate Dest. DB tab, click Start DB Transformation to begin the database transformation and migration process. For more information, see Database transformation and migration.