Advanced Search

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