Documentation
Rate This Document
Findability
Accuracy
Completeness
Readability
SubmitClose

Source Code SQL Compatibility Assessment and Conversion

  1. Log in to the Kunpeng DevKit at https://Server_IP_address:Port, for example, https://x.x.x.x:8086.
  2. Click System Migration in the navigation tree on the left and then click or New to go to the New Project tab page.
    Figure 1 New Project
  3. Select Source package migration only. Check that SQL migration is selected for Source Code Porting. Then select Upload source packages upload and click Upload.
    Figure 2 Basic Settings
  4. Click Add File, select the source package, and click Upload.
    Figure 3 Add File
  5. If you need to use DDL statements to improve the SQL statement parsing accuracy, click Upload to upload a DDL file. Otherwise, skip this step.
    Figure 4 Upload DDL
  6. Click Start Migration. The migration progress is displayed.
    Figure 5 Start Migration
  7. After the migration is complete, the Migration Result page is displayed.
    Figure 6 Migration Result
  8. 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 7 Incompatible SQL statements
    Figure 8 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