/ Published in: DOS Batch
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"
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"
URL: http://msdn.microsoft.com/en-us/library/ms162843.aspx