Visual Studio Utility to Compare 2 SQL Server Databases

Share this Post

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


Share this Post
Tags:

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.