Archives of the TeradataForum

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

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

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>>