Chris SkorlinskiMicrosoft 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 Databaseshttp://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