Archives of the TeradataForum

Message Posted: Thu, 07 Jun 2012 @ 08:41:52 GMT

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

The standard script is very simple. You may enhance it for specific needs:

Results from both the SQLs below must be null.

     Select * from DB1.TableA minus Select * from DB2.TableA;

     Select * from DB2.TableA minus Select * from DB1.TableA;

If both the databases are on the same server, you can directly run these statements otherwise you may want to go for fetching row counts and measure aggregates separately on both the databases and compare those.

Regards

Sowmyalakshmi

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