Using TPT to move Tables across Databases

Tools

Using TPT to move Tables across Databases

Hello,

I am a newbie to Teradata and only have a few weeks of experience usting Teradata's Tools and Utlities. I've been playing with FastLoad and FastExport for loading and exporting files. My next challange is to write a TPT script that will allow me to copy a table from a production database into a snapshot database that we are using to freeze data for analysis. I am having issues getting a fucntioning scfript and was wondering if anyone could provide an example script of how to copy tables between databses using TPT.

Thanks for your help in advance.

-Jeffrey

1 REPLY
Teradata Employee

Re: Using TPT to move Tables across Databases

The TPT User Guide will describe how to do that.

Also, there are sample scripts in the "samples" directory under the root install directory for TPT that should be able to provide the information.

-- SteveF