Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 20 Aug 2003 @ 15:48:23 GMT


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


Subj:   Arcmain Questions
 
From:   Jeremy Christiansen

I'm trying to move data from a test environment to a production environment. Due to space restrictions I can not do a simple insert/select. What I'd like to do is copy the data to tape, get rid of the test database (thus freeing up that space), and then load the data to production. I know that there are a number of ways to do this, but the one I need more information on is ArcMain. I've never used ArcMain and am unclear about a few things from the documentation.

1) If the table I am copying data to already has data in it, will that data be deleted?

2) Can I copy data from multiple databases (using seperate archive files) and then load those files to my production database? Morevoer, will it work if some of the source databases have slightly different table definitions (i.e. the column order is slightly different)?

Again, I am well aware of other options, so please confine your replies to ArcMain. My knowledge of this utility is sketchy, hence my questions.

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: 27 Dec 2016