Comparing table data in SQL Server 2005

Have you spent your hard earned money on tools like Redgate's SQL Compare to enable you to compare data. Or just dispaired when your publihser and subscriber get out of sync.

Well in SQL Server 2005 there is a new utility to compare the data in two tables, the data can be in different tables and on different servers.

The utility will allow for the results of the comparison to be stored in a table.

Ok so it doesn't provide the details of whats different but whether a record is mismatched, only on the source or only on the destination.

So whats the utility, its Tablediff

Its located in the Program Files\Microsoft SQL Server\90\COM folder

Published Thursday, January 5, 2006 6:00 PM by simonsabin
Filed under:


No Comments