During performance troubleshooting we often need to look at difference between two different databases. We’ve used SQL Server Tablediff Utility for the data changes but doesn’t help with schema changes. For schema differences you can use Database Compare tool available for Visual Studio. How to: Compare the Data of Two Databases http://msdn.microsoft.com/en-us/library/aa833428.aspx Schema Comparison with
Read More »
We recently need to find all the difference in data between 2 SQL Servers each with 300 SQL replicated tables. To find the differences, we were planning on using the TableDiff utility included with SQL 2005 which is a command line tool designed to provide TSQL needed to manually sync two table in two different
Read More »
I’m posting a collection of SQL Server 2008 Merge Replication Best Practices. The material below includes text from SQL Books Online, other white papers, KB articles, web postings, and little from experience I gained working with SQL Replication for almost 15 years. The “best practices” below are in no particular order. My objective was to
Read More »