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.