Best practices
Last updated
Last updated
This is a deprecated version of the SnowConvert documentation, please visit the official site .
We highly recommend you use our scripts to extract your workload:
Teradata: .
Oracle: .
SQLServer: .
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:
Create a single file for each top-level object
Organize each file by a defined folder hierarchy (The default is: Database Name -> Schema Name -> Object Type)
Generate an inventory report that provides information on all the objects that are in the workload.
Please to download the binary of the script.
The following information is needed to run the script:
Script Argument
Example Value
Required
Usage
Input folder
/home/user/extracted_ddls
Yes
{ -i | ifolder= }
Output folder
/home/user/processed_extracted_ddls
Yes
{ -o | ofolder= }
Database name
sampleDataBase
Yes
{ -d | dname= }
Database engine
Microsoft SQL Server
Yes
{ -e | dengine= }
Output folder structure
Database name, top level object type and schema
No
[ { -s | structure= } ]
Pivot tables generation
Yes
No
[ -p ]
Set the binary as an executable:
chmod +x standardize_sql_files
Run the script by executing the following command:
./standardize_sql_files
Running the script using the previous information:
./standardize_sql_files -i "input path" -o "output path" -d Workload1 -e teraddata
If the script is successfully executed the following output will be displayed:
Splitting process completed successfully!
Report successfully created!
Script successfully executed!
If this is the first time running the binary the following message will pop-up: Click OK.
Open Settings -> Privacy & Security -> Click Allow Anyway