Table Difference

TableDiff.exe is a table comparison tool that comes with the sql server.

It's installed in the following location:

"D:\Program Files\Microsoft SQL Server\90\COM\TableDiff.exe"if your SQL Server is installed in the program files on D: drive.
I normally install everything on D drive.

This compares 2 tables in the same database on the same server and creates a new table called DiffsTable that holds the differences:



"D:\Program Files\Microsoft SQL Server\90\COM\tablediff.exe"
-sourceserver MyServer1
-sourcedatabase MyDatabase1
-sourcetable MyTable1
-destinationserver MyServer1
-destinationdatabase MyDatabase1
-destinationtable MyTable2
-et DiffsTable


For more information check out the below link
http://msdn2.microsoft.com/en-us/library/ms162843.aspx