Last 2.5 months' spare time has been spent building MSSQL.DataMask. Just released v22.214.171.124 after several weeks of beta feedback. Very fun project. Use it multiple times a day at my real job when doing database updates and ensuring dev, test, staging, and production db's all in synch. Use it to ensure full setup script database matches udpate script database.
Download from: http://www.wintestgear.com/products/MSSQLSchemaDiff/MSSQLSchemaDiff.html
Description: MSSQL Schema Diff is a free database comparison tool used to quickly and easily locate structural differences between two SQL Server databases. Results are clearly displayed with MSSQL objects in a familiar SQL Management Studio tree layout and property comparisons in a matching data grid. Intuitive icons and color codes make it easy to spot differences. Filter buttons make it easy to narrow down to just what is different or missing from one or the other database. Usage is simple; you select two MSSQL databases, click Compare, then browse the differences
Use MSSQL.SchemaDiff to:
• Troubleshoot and find errors caused by database differences
• Ensure consistency between dev, test, staging, and production database environments
• Learn what changed between database versions