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, and provides suggestions if some SQL statements cannot be automatically replaced.

Prerequisites

The type of the source database is Oracle, Db2, or Teradata.

Create a transformation project

  1. Log on to the ADAM console.
  2. In the left-side navigation pane, click Evaluate & Transform App.
  3. In the Transform Applications step, click Create Transformation Project.
  4. In the Create Transformation Project panel, specify Source Database Type, Destination Database Type, Destination Database Version, and Architecture, upload a data file, and then click Create.
  5. 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 destination database is a PolarDB O Edition database, automatic transformation is supported.
    • If 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 can 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.