SQL Server Find Differences Between Two Tables


/ Published in: DOS Batch
Save to your folder(s)

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"


Copy this code and paste it in your HTML
  1. REM The tablediff.exe file is typically located in c:\Program Files\Microsoft SQL Server\90\COM
  2.  
  3. tablediff -sourceserver MyServer -sourcedatabase MyDatabase -sourcetable MyTable1 -destinationserver MyServer2 -destinationdatabase MyDatabase2 -destinationtable MyTable2 -o diff_output.txt -F diff_script

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

Report this snippet


Comments

RSS Icon Subscribe to comments

You need to login to post a comment.