SnowConvert: Best practices¶

1. Extraction¶

We highly recommend you use our scripts to extract your workload:

2. Preprocess¶

We highly recommend you use a Preprocess Script that aims to give you better results before starting an assessment or a conversion. This script performs the following tasks:

  1. Create a single file for each top-level object

  2. Organize each file by a defined folder hierarchy (The default is: Database Name -> Schema Name -> Object Type)

  3. Generate an inventory report that provides information on all the objects that are in the workload.

2.1 Download¶

  • Please click here to download the binary of the script for MacOs (make sure to follow the setup on 2.3).

  • Please click here to download the binary of the script for Windows.

2.2 Description¶

The following information is needed to run the script:

Script ArgumentExample ValueRequiredUsage
Input folder/home/user/extracted_ddlsYes{ -i | ifolder= }
Output folder/home/user/processed_extracted_ddlsYes{ -o | ofolder= }
Database namesampleDataBaseYes{ -d | dname= }
Database engineMicrosoft SQL ServerYes{ -e | dengine= }
Output folder structureDatabase name, top level object type and schemaNo[ { -s | structure= } ]
Pivot tables generationYesNo[ -p ]

Note

The supported values for the database engine argument (-e) are: oracle, mssql and teradata

Note

The supported values for the database engine argument (-e) are: database_name, schema_name and top_level_object_name_type.
When specifying this argument all the previous values need to be separated by a comma (e.g., ““-sdatabase_name,top_level_object_name_type,schema_name).

This argument is optional and when it is not specified the default structure is the following: Database name, top-level object type and schema name.

Note

The pivot tables generation parameter (-p) is optional.

2.3 Setup the binary for Mac¶

  1. Set the binary as an executable:
    chmod +x standardize_sql_files

  2. Run the script by executing the following command:

    ./standardize_sql_files

    • If this is the first time running the binary the following message will pop-up:
      Click OK.

    • Open Settings -> Privacy & Security -> Click Allow Anyway

Running the script¶

  1. Running the script using the following format:

    1. Mac format
      ./standardize_sql_files -i "input path" -o "output path" -d Workload1 -e teraddata

    2. Windows format
      ./standardize_sql_files.exe -i "input path" -o "output path" -d Workload1 -e teraddata

  2. If the script is successfully executed the following output will be displayed:

    Splitting process completed successfully!
    Report successfully created!
    Script successfully executed!

Language: English