Updated on 2024-07-19 GMT+08:00

Preparations

Before the migration, create an input folder and an output folder, and copy all the SQL scripts to be migrated to the input folder. The following procedure describes how to prepare for the migration in Linux.

  1. Run the following commands to create an input folder and an output folder. You can create the folder anywhere based on your preferences. You can also use the default folders for input, output, provided as part of package.

    1
    2
    mkdir input
    mkdir output
    

    The tool reads the input folder in batches randomly. After the migration starts, it is recommended the users should not perform any modification on the input folder and files. Abnormal operations will affect the output result of the tool.

  2. Copy all SQL scripts to be migrated to the input folder.

    • If the encoding format of source files is not UTF-8, perform the following steps:
      1. Open the application.properties file in the config folder.
      2. Change the value of encodingFormat in the application.properties file to the required encoding format.

      DSC supports the UTF-8, ASCII, and GB2312 encoding formats. The values of encodingFormat are case-insensitive.

    • To obtain the encoding format of a source file in Linux, run the following command on the server where the source file is located:
      1
      file -bi <Input file name>