Source Code SQL Compatibility Assessment and Conversion
- Log in to the Kunpeng DevKit at https://Server_IP_address:Port, for example, https://xx.xx.xx.xx:8086.
- Choose Source Code Porting from the navigation pane on the left and click
to create a task.Figure 1 New Project
- Set Source Code Type to Java, select SQL migration for Source Code Porting, and upload the source package.Figure 2 Basic Settings
- Select the source and target databases. To improve the accuracy of SQL statement parsing using DDL statements, click Upload to upload a DDL file.Figure 3 Advanced Settings
- Click Start. The migration progress is displayed.Figure 4 Source code porting
- After the migration is complete, the SQL Migration Report page is displayed.Figure 5 SQL Migration Report
- Check the scan result. You can view the compatibility assessment report to obtain the files where the compatible, incompatible, and unconfirmed SQL statements are located.
Select Incompatible and click View Details to view the extracted incompatible SQL statements, conversion status, and target SQL statements.
Figure 6 Incompatible SQL statements
Figure 7 Guidance
- If a patch is generated, click Download SQL Migration Report Summary File to obtain the patch. Then apply the SQL modifications to the source file by following instructions in Source Code SQL Writeback Patch.
- If no patch was generated due to SQL statement conversion failure, manually convert the SQL statements and modify the source code.
Parent topic: Examples