Purpose

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

Create a project

In the Destination Database Recommendation step, click Next: Create Database Evaluation Project. You can use a database profile to create an evaluation project. In the Create Project dialog box, you must specify the name and version of the destination database, the profile name, and the schema list. The supported database engines include PPAS, Apsara PolarDB-O, and MySQL. You can also configure whether to migrate some LOB columns to OSS. After the project is created, it will start to analyze the database.

Project details

View a project

You can view the analysis progress on the project list page. After the analysis is complete, click Details in the Actions column corresponding to the project to view the analysis results.

Evaluation details

Databases are evaluated from the following dimensions: compatibility, transformation, specifications, and risks.

  • Compatibility: indicates the compatibility between the source and destination databases. A higher degree of compatibility indicates that fewer SQL statements and objects that need to be transformed.
  • Transformation: indicates the number of focus areas of the destination database transformation. Database objects transformed by ADAM do not need to be modified. The focus areas of application transformation are obtained by analyzing SQL statements collected from the database during preliminary evaluation. To analyze the specific focus areas of application transformation, you can use the ADAM application evaluation feature.
  • Specifications: indicates the required specifications of the destination database 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: indicates the existing risks of the source database and risks that may be generated when the database is migrated. This dimension provides you with warnings about database migration and transformation.

Evaluation details include compatibility analysis of database objects, SQL compatibility analysis, focus areas of object transformation, destination database specifications, conversions of Oracle PL/SQL to Java, and migration risks.

(1) Object compatibility analysis

The Schema Compatibility page shows the evaluation results of all database objects including those that are compatible, incompatible, and compatible after transformation. Compatible after transformation indicates that objects can be transformed by ADAM to be compatible with the destination database. ADAM provides the transformed DDL statements and focus areas of transformation for objects that can be compatible after transformation. ADAM explains why objects are incompatible and provides suggestions to transform them.

(2) SQL compatibility analysis

The SQL Compatibility page shows the evaluation results of SQL statements collected from the source database, including those that are compatible, incompatible, and compatible after transformation. You can query the overall compatibility information and details. You can view the cause of the incompatibility of an SQL statement on the Error Message tab.

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

(3) Destination database specifications

The Destination Database Specifications page provides specifications and migration plan guidelines to help you migrate databases to Alibaba Cloud databases. The estimated destination database specifications is calculated based on the collected configurations, performance, SQL, and Oracle PL/SQL of the source database, as well as the comprehensive analysis of the source and destination databases. Specifications are of reference value for migration. Detailed information is given for objects in each migration group, as shown in the following figure.
A solution that has multiple instances may contain cross-database objects.

(4) Migration risks

Migration risks include risks from source and destination databases. Risks from the source database may occur when you execute SQL statements that consume high CPU and use large memory in the source database, such as SQL statements of the TOP CPU and TOP Buffer types. Risks from the destination database may occur when you transform database schemas or execute SQL statements in the destination database. You must focus on migration risks to avoid performance differences caused by heterogeneous database migration.

(5) Focus areas

The Focus Areas page 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.

This page lists all database objects that need to be transformed and classifies them by their transformation difficulty to help you plan transformation tasks.You can search for focus areas of project transformation by object name, transformation level, or rule ID.

Download reports

ADAM not only shows information about database evaluation, but also allows you to download evaluation reports. You can click Download Reports to obtain all ADAM database evaluation reports.