Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Thu, 16 Apr 2015 @ 15:06:16 GMT

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

Subj:   Re: Copying data from one database to another on different servers
From:   Ravani, Chiran Chandrakant

Adding to below points.

1. If you have Same Database versions (Major and Minor must match) on Server 1 and 2. Go for Arcmain utility. Arc/Restore would be easier to go for.

2. If not, try using TPT by exporting data and the loading it to empty tables after creating structures manually.

3. You may consider using standalone utilities like FastExport to export data to flat files and then load using FastLoad/MultiLoad.



  <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