Now that VAult works on SQL 2005, and SQL 2005 has support for DDL change triggers, it would be nice for the two to work together.
I have lots of "instances" of a database used for an application. We are constantly making changes to procs, etc, and have branches of the db.
If I want to make a change in version 1 of a proc, and need it merged to version 2, it is a pain.
Also it is not easy to track the history of proc changes. The same goes for triggers, functions, and other "code" that lives in a SQL database.
FR - SQL 2005 source control with vault.
Moderator: SourceGear