COPY Tables with data in Teradata

You can use the following syntax in a BTEQ Script to copy the tables and data:


CREATE TABLE <NewDB>.<NewTable> AS <OldDB>.<OldTable> WITH DATA AND STATS;


Or just the table structures:

CREATE TABLE <NewDB>.<NewTable> AS <OldDB>.<OldTable> WITH NO DATA AND NO STATS;


There are two solutions for this.

(1) Arcmain - You need to use Arcmain Backup first,

Which creates files containing data from your tables. Then you need to use Arcmain restore which restores the data from the files

(2) TPT - Teradata Parallel Transporter.

This is a very advanced tool. This does not create any files like Arcmain. It directly moves the data between two teradata servers.