Archives of the TeradataForum
Message Posted: Wed, 13 Feb 2008 @ 10:39:43 GMT
<-- 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.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|