Data movement across Terdata server

Database
Enthusiast

Data movement across Terdata server

Hi Experts,

Please offer your opinion on data movement  across Teradata servers( for e.g. production to Test, TD 14 to TD 12/13 or vice versa) using TTU. If you have to rank the tool/technology from the following in terms of performance and Price how would you  -

1> Archive/Restore through ARCMain

2> TPT

3> FAST export/Fast load

Regards,

Meet_As

3 REPLIES
Enthusiast

Re: Data movement across Terdata server

I'd rank based on the performance like below -

2> TPT

1>ARCMain

3> Fast export/Fast Load

Enthusiast

Re: Data movement across Terdata server

Thanks for the response. If possible can you please tell the reason why TPT is fastest on the performace than others.

Regards,

meet_as

Enthusiast

Re: Data movement across Terdata server

If the requirements permit it, I usually move data from a backup between systems.  There are usually faster connections to your backup media and the source system is not effected by a Fast Export.  I may be misunderstanding, but I believe TPT would still need to perform a Fast export/Fast load if moving data from one cabinet to another.

Joe