Loading tables from Teradata 5 to Teradata 6

Visit Teradata.com

Home

Guidelines

Member List

Welcome Guest ( Login | Register )

This online forum is for user-to-user discussions of Teradata products, and is not an official customer support channel for Teradata. If you require direct assistance, please contact Teradata support.

Loading tables from Teradata 5 to Teradata 6

Rate Topic

Display Mode

Topic Options

Author

Message

shash

Posted 10/31/2007 9:30:53 AM

Forum Newbie

Group: Forum Members
Last Login: 1/3/2008 4:44:27 AM
Posts: 1, Visits: 20

Dear All,

I 'm new to Teradata and have to deal with the following situation, I need to load the data from Teradata version 5 to version 6. I have around 600 tables to be loaded.

Ironically, when I installed the teradata the fastload, fastexport, multiload were not installed. If these tools are installed, is this the best way to load the data or can any one of you think of a better solution.

Thanks
Shash

Post #9554

dnoeth

Posted 10/31/2007 10:03:04 AM

Supreme Being

Group: Forum Members
Last Login: 6/25/2008 7:26:06 AM
Posts: 474, Visits: 202

Hi Shash,
FastLoad et.al. are part of the Teradata Client and not of the Teradata DBMS.

And the best way to copy x tables is a BACKUP on the old system followed by a COPY to the new system.

Dieter

Post #9557

« Prev Topic | Next Topic »

Reading This Topic

Active Users: 0 ( 0 guests, 0 members, 0 anonymous members )

No members currently viewing this topic.

All times are GMT -5:00, Time now is 6:40pm