Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Thu, 03 Apr 2008 @ 21:04:40 GMT


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


Subj:   Re: Migrate data across Systems with ARC
 
From:   Anomy Anom

<-- Anonymously Posted: Date: Thu, 3 Apr 2008 13:34 -->

     COPY DATA TABLES (DEV_TB) (FROM(PROD_TB)), RELEASE LOCK,
     FILE=myTapeFile;

For tables, it's simple enough. Note, though, that not all object types get migrated as you might hope. For example, dictionary entries for join indexes and stored procedures are copied but those objects will need to be recreated before they can actually be used, and the text of views and macros is copied unchanged (i.e. they still "point" to PROD_TB).



     
  <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