Advanced Database & Application Migration (ADAM) allows you to scan static code to identify the SQL statements that need to be transformed. ADAM transforms the SQL statements that can be automatically replaced, or sends notifications to you if some SQL statements cannot be automatically replaced.

Purpose

ADAM identifies the SQL statements that need to be transformed and automatically transform them by using a program.

Create a transformation project

  1. Click Create Transformation Project.
  2. In the Create Transformation Project dialog box, specify the required parameters of the transformation project. These parameters include Source Database Type, Destination Database Type, Destination Database Version, and Architecture. Upload data files and then click Create.
  3. If you create a migration project, you need to run the built-in analysis program of ADAM. This process takes 1 to 10 minutes.
    Note If the source database is an Oracle database and the destination database is a PolarDB-O database, automatic transformation is supported. If the source database is an Oracle database and the destination database is an ApsaraDB RDS for MySQL, AnalyticDB for PostgreSQL, or PolarDB-X database, SQL statements can be displayed, but cannot be automatically transformed.

Details of static application transformation

The details of the static application transformation include the following sections in the console: Project Summary, Transformation Overview, and Transform Applications.

Project summary

The Project Summary section describes the basic information of a transformation project.

Transformation Overview

The Transformation Overview section displays the types and transformation methods of code blocks.

Transformation types of code blocks

  • Not Required: The code blocks run in the destination database without transformation.
  • Automatic: The code blocks are transformed by ADAM. You only need to replace them and run the transformed code blocks in the destination database.
  • Manual: The transformation requirements of the code blocks are listed. You must manually transform these code blocks.
  • SQL Unrecognized: The SQL statements in the code blocks cannot be identified because the SQL statements are invalid or code blocks are run in a special way.

Types of code blocks

  • select: the code blocks of the SELECT type
  • insert: the code blocks of the INSERT type
  • update: the code blocks of the UPDATE type
  • procedure: the code blocks of stored procedures
  • delete: the code blocks of the DELETE type
  • statement: the code blocks executed by statements

Transform Applications

Click Details in the Actions column to view the transformation details of code blocks.