Visual Studio Utility to Compare 2 SQL Server Databases

Chris Skorlinski
Microsoft SQL Server Escalation Services

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 Visual Studio Team Edition for Database Professionals

http://www.sql-server-performance.com/articles/per/Schema_Comparison_with_VSTE_DBPro_p1.aspx