When migrating from Oracle, Db2, or Teradata to a cloud database, application code that embeds SQL statements may break due to syntax differences between the source and destination databases. Static application transformation uses ADAM to scan your static code, automatically rewrite SQL statements it can handle, and provide transformation suggestions for the rest—so you can identify and resolve compatibility issues before cutover.
How it works
The transformation workflow follows these steps:
Create a transformation project and upload your application code files.
ADAM scans the code, extracts SQL statements, and runs its built-in analysis program. This takes 1 to 10 minutes.
Review the results: each SQL statement is classified as Not Required, Automatic, Manual, or SQL Unrecognized.
For Automatic transformations: replace the original code blocks with the transformed versions in your application.
For Manual transformations: review ADAM's transformation suggestions and update the code blocks yourself.
Prerequisites
Before you begin, ensure that you have:
A source database of type Oracle, Db2, or Teradata
Automatic transformation is only supported when the destination database is a PolarDB for PostgreSQL (Compatible with Oracle) cluster. For ApsaraDB RDS for MySQL instances, AnalyticDB for PostgreSQL databases, and PolarDB-X instances, ADAM provides transformation suggestions but does not perform automatic transformation.
Create a transformation project
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) > Application Evaluation and Transformation.
Click the Transform Applications tab.
Click Create Transformation Project.
In the Create Transformation Project panel, set the following parameters, click Upload to upload your data files, then click Create.
Parameter Description Source Database Type The type of your source database: Oracle, Db2, or Teradata Destination Database Type The target database platform Destination Database Version The version of the destination database Architecture The architecture type of your application
ADAM starts the built-in analysis program automatically after you create the project. The analysis takes 1 to 10 minutes to complete.
View transformation details
After the analysis completes, review the results to plan your next 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) > Application Evaluation and Transformation.
Click the Transform Applications tab.
Find the transformation project and click Details in the Actions column.
Review the following sections: Project Summary — Displays the basic information of the transformation project. Transformation Overview — Displays the transformation type and method for each code block, along with statistics by SQL type. Transform Applications — Click Details in the Actions column to view the transformation details for individual code blocks.
Transformation types:
Type Description Next step Not Required These code blocks run in the destination database without any transformation. No action needed. Automatic ADAM transformed these code blocks. Replace the original code blocks with the transformed versions in your application. Manual These code blocks cannot be transformed automatically. ADAM provides transformation suggestions. Review the suggestions and update the code blocks manually. SQL Unrecognized ADAM could not identify these SQL statements—either the SQL is invalid or the code block runs in a special way. Review and transform these code blocks manually. Statistics by SQL type:
SQL type Description select Number of SELECT code blocks insert Number of INSERT code blocks update Number of UPDATE code blocks procedure Number of stored procedure code blocks delete Number of DELETE code blocks statement Number of code blocks executed by statements