Proper pre-processing is the backbone of success with a tool like SnowConvert for Teradata.
Before we get started, recall that we highly recommend that you go through our training labs in order to get the most out of SnowConvert.
Before you start using SnowConvert, you'll have to extract your Teradata SQL Code, and put them in a file with any other Teradata extensions (BTEQ, Fastload, etc.) you may have. In order to do this, please follow these steps:
- 2.Follow the instructions on extracting the SQL code using the Generate DDL Wizard.
- 3.Save the extracted .sql code into a folder. This folder will be referred to as the "Input Folder" in the conversion process.
As mentioned previously, once you have one folder with all of your .sql files, be sure to drop any .bteq, .fload, .fl, .mload, .ml, .tpump, or .tpt files that you may have into that same folder. The assessment and performance of SnowConvert are greatly enhanced by getting the maximum amount of your source code into the same folder.
There are other alternatives to using the Generate DDL Wizard. Mobilize.Net has provided a collection of extraction scripts that you can tailor to your own needs. You can find out more about how to use them in this lab.