Sdílet prostřednictvím

tablediff

  • Článek

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: https://msdn.microsoft.com/en-us/library/ms162843.aspx

It’s also listed as one of the top 10 hidden gems in SQL Server 2005 https://www.microsoft.com/technet/prodtechnol/sql/bestpractice/gems-top-10.mspx

Comments