Synchronize Metadata Across SQL Server Database Copies

Thursday May 21st 2009 by DatabaseJournal.com Staff

Tracking changes when you have several copies of a database can be a huge chore. These step-by-step instructions will let you produce a report that will find differences for you.

[From SQL Server Magazine]

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

Mobile Site | Full Site