advanced code snippet search

Posted By

hoffstein on 11/25/08


Tagged

sqlserver


Versions (?)

Who likes this?

3 people have marked this snippet as a favorite

hoffstein
robe
Tyster


SQL Server Find Differences Between Two Tables

 / Published in: DOS Batch
 

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

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.

Expand | Embed | Plain Text 
  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

Report this snippet  

You need to login to post a comment.