Help Center/ GaussDB(DWS)/ More Documents/ Tool Guide (Kuala Lumpur Region)/ DSC: SQL Syntax Migration Tool/ Using DSC/ Migration Process/ Viewing Output Files and Logs
Updated on 2022-08-16 GMT+08:00
View PDF
Share

Viewing Output Files and Logs

Viewing and Verifying Output Files

After the migration is complete, you can use a comparison tool (for example, BeyondCompare®) to compare the output file with its input file. Input SQL files can also be formatted for easier comparison.

  1. Run the following command in Linux and view output files in the output folder. Operations in Windows are not described here. 
    cd OUTPUT
ls

    Information similar to the following is displayed:

    formattedSource    output
user1@node79:~/Documentation/DSC/OUTPUT> cd output
user1@node79:~/Documentation/DSC/OUTPUT/output> ls
in_index.sql    input.sql    Input_table.sql    in_view.sql    MetadataInput.sql
user1@node79:~/Documentation/DSC/OUTPUT/output>
  1. Use the comparison tool to compare the output file with its input file. Check whether the keywords in the migrated SQL file meet the requirements of the target database. If they do not, contact technical engineer support.

Viewing Log Files

Execution information and error messages are written into corresponding log files. For details, see Log Reference.

Check whether errors are logged. If they are, rectify the faults by following the instructions in Troubleshooting.

Parent topic: Migration Process