Have a look at http://www.red-gate.com/sql_compare.htm

>I am trying to improve upon my methodology for managing changes to sql server databases. Please note that I am talking about changes to the METADATA, i.e. to the data dictionary, not changes to transaction data. Here are the issues I am trying to address:
>
>1) I need a way to track the evolution of the database definitions/objects from a fixed starting point in time. I work with a product called Visual Accountmate/SQL - VAMSQL, by Accountmate Software Corporation - ASC. When ASC releases a new version of their software, they don't do a very good job (in fact they do a TERRIBLE job) of documenting the changes since the last release. Many things change of course from forms, classlibs, dbc, views and data, etc. Right now I am mostly concerned with changes to the sql database and to remote views.
>
>2) Also, VAMSQL is open source (mostly) and I modify it heavily, including the database.
>
>3) Ideally I'd like to be able to take a 'snapshot' of the metadata starting at a given point in time/build number. Thereafter, I'd like to maintain a history of all changes to the database.
>
>4) Also, VAMSQL supports multiple companies, within an installation, with one sql database per company. The same codebase supports all companies, so generally speaking, the data changes for a given installation need to be propagated across multiple databases. Also, I need to be able to manage multiple installations and easily update all the databases with a given set of changes - e.g. add support for Landed Cost for 3 out of 5 clients.
>
>I am wondering what commercial tools are out there to enhance sql server's data dictionary facilities, audit and change tools, etc. Any suggestions would be appreciated.