SQL 2000 SQL 2005 objects & Vault

[SimonG159]

Anyone have any guidelines or experience in using SourceGear Vault with SQL server objects? I can't see that Query Analyser works with source control but are there similar third party tools?

[jclausius]

Check out Red-Gate software and Apex. I haven't checked out their latest offereings, but I believe their tools still interop with Vault.

[Andras Belokosztolszki]

Anyone have any guidelines or experience in using SourceGear Vault with SQL server objects? I can't see that Query Analyser works with source control but are there similar third party tools?

Hi,
Red Gate's SQL Compare 6.2 Professional and later supports adding source control support to your SQL Server databases, and it does work with SourceGear Vault .

In more detail: SQL Compare can script the database schema, compare these scripts with the database directly, and synchronize the differences both from and to the creation scripts. These creation scripts are the bridge between your database and source control
As mentioned, it does work with SourceGear Vault, but working with Vault is not supported officially. SQL Compare communicates with SourceGear Vault via a common interface SCCI. This allows it to work with a large number of source control providers. The interface is not perfect, and SourceGear could probably help you to find out whether there are any issues in their support for this interface.

There are two main scenarios when SQL Compare communicates with Vault: First, when synchronizing towards scripts, SQL Compare can automatically check out the relevant files from Vault. Second, before comparisons, SQL Compare can retrieve the latest SQL Scripts from SourceGear Vault, and compare the retrieved latest scripts with a live database or another set of creation scripts.

Regards,
Andras