Code Extraction

Instructions to extract Teradata code.

This is a deprecated version of the SnowConvert documentation, please visit the official site HERE.

The first step for migration is getting the code that you need to migrate. There are many ways to extract the code from your database. However, we recommend using the extraction scripts provided by Snowflake.

All the source code for these scripts is open source and is available on GitHub.

Prerequisites

  • Access to a server with a Teradata database.

  • Permission to run shell scripts with access to the server.

  • Teradata utilities likebteq / tpt.

  • Python

Installing the scripts

Go to https://github.com/Snowflake-Labs/SC.DDLExportScripts/.

From the Code option, select the drop-down and use the Download ZIP option to download the code.

Decompress the ZIP file. The code for Teradata should be under the Teradata folder

Follow the Usage instructions to modify the files and run them on your system.

Package the results

When the script is done, the output folder will contain all the DDLs for the migration. You can then compress this folder to use it with SnowConvert.

E.g. run:

zip -r output.zip ./output

Last updated