The static application transformation feature allows you to scan static code to identify the SQL statements that need to be transformed. ADAM transforms SQL statements that can be automatically replaced, and provides transformation suggestions on SQL statements that 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 Data Management (DMS) console V5.0.
  2. In the top navigation bar, move the pointer over DTS. Choose Heterogeneous Database Migration(ADAM) > Application Evaluation and Transformation.
  3. Click the Transform Applications tab.
  4. On the Transform Applications tab, click Create Transformation Project.
  5. In the Create Transformation Project panel, set the Source Database Type, Destination Database Type, Destination Database Version, and Architecture parameters and click Upload to upload data files. Then, click Create.

    When you create a transformation project, the built-in analysis program of ADAM is automatically run. This process takes 1 minute to 10 minutes.

    Note
    • If the destination database is a PolarDB for Oracle instance, automatic transformation is supported.
    • If the destination database is an ApsaraDB RDS for MySQL instance, AnalyticDB for PostgreSQL database, or PolarDB-X instance, automatic transformation is not supported.

View the transformation details

  1. Log on to the Data Management (DMS) console V5.0.
  2. In the top navigation bar, move the pointer over DTS. Choose Heterogeneous Database Migration(ADAM) > Application Evaluation and Transformation.
  3. Click the Transform Applications tab.
  4. On the Transform Applications tab, find the transformation project that you want to view and click Details in the Actions column.
  5. View project details in the following sections:
    • Project Summary: displays the basic information of the transformation project.
    • Transformation Overview: 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 need to only replace the original code blocks with 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 the code blocks are run in a special way.
      • Statistics of code blocks
        • select: the number of code blocks of the SELECT type.
        • insert: the number of code blocks of the INSERT type.
        • update: the number of code blocks of the UPDATE type.
        • procedure: the number of code blocks of stored procedures.
        • delete: the number of code blocks of the DELETE type.
        • statement: the number of code blocks executed by statements.
    • Transform Applications: Click Details in the Actions column to view the details of code block transformation.