sql server scripts (stored procs, schema etc), vaultable?

[Salman]

Hey,

Do you guys have any neat tricks/ suggestions on how we could use the vault to store sql server related scripts? (stored procedures, and schema scripts etc).

This would be a great feature if its there, and if not, any suggestions on how best to keep versions on this?

[jclausius]

others may have different solutions, but here are my personal experiences.

i prefer to store all my scripts in a small number of files. i then use vault to checkout out /in the .sql files.

with our latest project - bug tracking - (see integrated bug tracking here - http://software.ericsink.com/SourceSafe_to_Vault.html), we switched to using vs.net's internal capability by adding a database project to the bug tracking solution. i'm glad to report, so far... so good.

this is not all that you can do. i have experimented, but not fully tested vs.net's capability of storing each database object inside its own file. as you edit the object in visual studio.net, it automatically checks the file out from vault.

setup is a little weird here, as you will need to add a database to the server explorer, and then "drag" the objects from the database over to the database project. at this point, vs.net will generate scripts, and add them to the vault database. once this has been done, you just checkout, edit, checkin each database object.

hth

[Guest]

how do you make it so it automagically checks the file out and doesn't ask me all the time to checkout the file?

I really like Vault so far, great work I must say.

[dan]

how do you make it so it automagically checks the file out and doesn't ask me all the time to checkout the file?

In the GUI client, go to Tools->Options->Always keep files checked out, and in the IDE client, go to Tools->Options->Source Control->General and check the "keep items checked out when checking in"