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.
- 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
You need to login to post a comment.