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.