Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Tue, 19 May 2009 @ 12:57:54 GMT

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

Subj:   Re: Comparison of data in two servers
From:   Rob Paller

You have a couple of options:

1) Use arcmain (arc) to archive and copy the data from one server to the other in a separate database. You can then query the tables and join them effectively.

2) Use Microsoft Access and link to the tables on both systems. You can then query them independently and compare the data. Joining the two tables together in Access, while technically possible, can be (significantly) slower depending on the size of the tables in question. The data will have to be brought to your desktop and joined by the JET database engine in Access.

3) FastExport the data from one system to a flat file and FastLoad it to the other system.

4) Depending on the level of detail you need you could leverage a data profiling or analysis tool and run some comparisons. There are several open source options that you could consider if cost is an issue.

Hope this helps.

  <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