Static code analysis scans your application's source code to identify embedded SQL that needs to be modified for database migration. The tool automatically converts compatible SQL statements and provides detailed recommendations for statements requiring manual changes.
Prerequisites
Your source database must be Oracle, Db2, or Teradata.
Create a transformation project
-
Log on to the Data Management (DMS) console.
-
In the top navigation bar, choose .
-
Click the Transform Applications tab.
-
On the Transform Applications tab, click Create Transformation Project.
-
In the Create Transformation Project panel, set the Source Database Type, destination database type, destination database version, and architecture parameters. Upload your source code files, and then click Create.
Creating the project triggers an automatic code analysis that typically takes 1 to 10 minutes to complete.
Note-
If the destination database is a PolarDB for PostgreSQL (Compatible with Oracle) cluster, automatic transformation is supported.
-
If the destination database is an AnalyticDB for PostgreSQL, AnalyticDB for PostgreSQL, or PolarDB-X instance, only the code that requires changes is identified. Automatic transformation is not supported.
-
Static application transformation details
-
Log on to the Data Management (DMS) console.
-
In the top navigation bar, choose .
-
Click the Transform Applications tab.
-
On the Transform Applications tab, find the project that you want to view and click Details in the Actions column.
-
On the project details page, review the project summary, transformation overview, and transformation results.
-
Project Summary: Displays basic information about the project.
-
Transformation overview: Provides a graphical summary of code block categories and statistics.
-
Code block categories
-
Not Required: These code blocks are compatible with the destination database and require no changes.
-
Automatic: These code blocks are automatically transformed by ADAM. You only need to replace the original files with the converted files.
-
Manual: ADAM identifies the code requiring changes and provides transformation suggestions.
-
SQL Unrecognized: The SQL in these code blocks could not be identified, often due to non-standard usage or syntax errors.
-
-
Code block statistics
-
select: The number of select code blocks.
-
insert: The number of insert code blocks.
-
update: The number of update code blocks.
-
procedure: The number of stored procedure code blocks.
-
delete: The number of delete code blocks.
-
statement: The number of code blocks executed by statement objects.
-
-
-
Static application transformation: In the Actions column, click Details to view the detailed transformation results for each code block.
-