Home Page for the TeradataForum
 

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.



     
  <Prev Next>  
<<First
<Prev
Next> Last>>  
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023