Return to Snippet

Revision: 9837
at November 25, 2008 11:20 by hoffstein


Initial Code
REM The tablediff.exe file is typically located in c:\Program Files\Microsoft SQL Server\90\COM

tablediff -sourceserver MyServer -sourcedatabase MyDatabase -sourcetable MyTable1 -destinationserver MyServer2 -destinationdatabase MyDatabase2 -destinationtable MyTable2 -o diff_output.txt -F diff_script

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

Initial Description
The TableDiff utility comes with SQL Server 2005 and can report differences on schema and data. The most popular feature of TableDiff is the fact that it can generate a script that you can run on the destination that will reconcile differences between the tables.

Original source was a TechNet article called [Top 10 Hidden Gems In SQL Server 2005][1].

[1]: http://www.microsoft.com/technet/prodtechnol/sql/bestpractice/gems-top-10.mspx "Top 10 Hidden Gems in SQL Server 2005"

Initial Title
SQL Server Find Differences Between Two Tables

Initial Tags


Initial Language
DOS Batch