Tablediff is a really handy tool which can be used to fix data sync issues. It is located in the 90\COM directory. If you are ever in a situation whereby replica databases are out of sync then tablediff can save your life. It will compare two tables and generate and output, which includes the T-SQL to fix the data, really handy for avoiding a re-initialisation of the data.
Take a look at the info here: http://msdn.microsoft.com/en-us/library/ms162843.aspx
It’s also listed as one of the top 10 hidden gems in SQL Server 2005 http://www.microsoft.com/technet/prodtechnol/sql/bestpractice/gems-top-10.mspx
.jpg)
No comments:
Post a Comment