TableDiff.exe - SQL Server Comparison Utility

The tablediff.exe is very useful command line utility to compare two tables from SQL Server instances. 

Tablediff.exe utility features

·         Comparison between two tables from SQL Server instance. 

·         Row by row fast comparison. 

·         Perform column level comparison. 

·         Easily generate change script between production and development SQL server instances.

·         Log result can be captured as output file or database table.

Reference : http://msdn.microsoft.com/en-us/library/ms162843.aspx