Help Center/ Data Warehouse Service / More Documents/ Tool Guide (Ally Region)/ DSC/ Using DSC/ Migration Process/ Executing DSC
Updated on 2025-12-11 GMT+08:00
View PDF
Share

Executing DSC

Important Notes

  • Before starting the migration program, you can specify the path of the output folder. The input folder path, output folder path, and log path are separated by spaces. By default, they are in the root directory of the tool. The input folder path cannot contain spaces which will cause an error when DSC is used for migrating data. For details, see Troubleshooting.
  • If the output folder contains subfolders or files, DSC deletes the subfolders and files or overwrites them based on parameter settings in the application.properties configuration file in the config folder before the migration. Deleted or overwritten subfolders and files cannot be restored by DSC.
  • If migration tasks are performed concurrently on the same server (by the same or different DSCs), different migration tasks must use different output folder paths and log paths.
  • You can specify a log path by configuring optional parameters. If the path is not specified, DSC automatically creates a log folder under TOOL_HOME. For details, see Log Reference.
  • The maximum size of a single SQL statement is 20 KB. If the size exceeds 20 KB, the execution may be slow and the conversion may fail.

Migration Methods

You can run the runDSC.sh or runDSC.bat command in Windows or Linux to perform migration. For details about the commands in different migration scenarios, see Table 1. The parameters in square brackets ([]) are optional.

Table 1 Migration on Windows and Linux

Migration

CLI Parameter

Linux

 
1
2
3
4
5
 
> ./runDSC.sh
 --source-db Teradata
[ --input-folder <input-script-path> ]
[--output-folder <output-script-path> ]
[--log-folder <log-path>]

Windows

 
1
2
3
4
5
 
> runDSC.bat
--source-db Teradata
[ --input-folder <input-script-path> ]
[--output-folder <output-script-path> ]
[--log-folder <log-path>]
  • The CLI parameters are described as follows:
    • Acronym

      --source-db: -S

      --input-folder: -I

      --output-folder: -O

      --log-folder: -L

    • source-db specifies the source database. The value can be:

      mysql

      bigquery

      teradata-re

      greenplum

      netezza-re

      oracle

      postgres

  • Command output description:

    Migration process start time indicates the migration start time and Migration process end time indicates the migration end time. Total process time indicates the total migration duration, in milliseconds. In addition, the total number of migrated files, total number of processors, number of used processors, log file path, and error log file path are also displayed on the console.

Examples

  • Example: Migrate the SQL files of the Teradata database to the SQL scripts of DWS on Linux. 
    1
2
3
    		 
    ./runDSC.sh --source-db teradata 
or
./runDSC.sh -S teradata 

    1
    		 
    ./runDSC.sh --source-db teradata --input-folder D:\test\conversion\input --output-folder D:\test\conversion\output  --log-folder D:\test\conversion\log
  • Example: Migrate the SQL file of the Teradata database to the SQL script of DWS on Windows. 
    1
2
3
    		 
    runDSC.bat --source-db teradata 
or
runDSC.bat -S teradata

    1
    		 
    runDSC.bat --source-db teradata --input-folder D:\test\conversion\input --output-folder D:\test\conversion\output --log-folder D:\test\conversion\log

Migration details are displayed on the console (including the progress and completion status):

********************** Schema Conversion Started *************************  
DSC process start time : Mon Jan 20 17:24:49 IST 2020  
Statement count progress 100% completed [FILE(1/1)]    
Schema Conversion Progress 100% completed  
**************************************************************************   
Total number of files in input folder : 1  
Total number of valid files in input folder : 1  
**************************************************************************   
Log file path :....../DSC/DSC/log/dsc.log  
Error Log file :    
DSC process end time : Mon Jan 20 17:24:49 IST 2020  
DSC total process time : 0 seconds  
********************* Schema Conversion Completed ************************
Parent topic: Migration Process