Synchronize Metadata Across SQL Server Database Copies

DBAs often encounter change-tracking problems when they try to keep multiple copies of a database synchronized across various environments. In addition to the standard development, test, quality assurance, and production versions, there can be copies of the database for implementations by divisions, departments, and development teams. You need to be able to check the status of database definitions quickly and easily to see if they're synchronized to support application changes that depend on the database structure.

The article continues at http://www.sqlmag.com/Articles/Index.cfm?ArticleID=101901