Archives of the TeradataForum

Message Posted: Wed, 13 Feb 2008 @ 10:39:43 GMT


	<Prev	Next>		<<First	<Prev	Next>	Last>>

Subj:		Data migration from one TD machine to another

From:		Anomy Anom

<-- Anonymously Posted: Wed, 13 Feb 2008 10:41 -->

We need to migrate data from one Teradata machine to another that is 200 miles away.

What is the best way to achieve this?

We can't connect the two machines physically.

So is it best to do database archives from the source TD machine to cartridge/tape, physically transport them to the target TD machine and do restores?

Or is it possible to do something in Unix which will automatically generate fast exports/fastloads or multiloads for all the tables required? There are approximately a couple of hundred tables that need migrating. I am not sure what the table/database perm space volumes will be.

Or is there another, better method?

Thanks in advance.