Source safe for SQL

[Bigley]

Anyone ever come across a Source safe type feature for SQL 7 - third party or otherwise [sig][/sig]

 

[foxdev]

I use VSS in a sort of &quot;disconnected&quot; or &quot;stand-alone&quot; mode. I place my .sql scripts (for both SPs and DDL) in various folders under my project, and check them out/in as needed using the VSS client interface. [sig]<p>Robert Bradley<br><a href=mailto: > </a><br><a href=

http://www.foxdev.com/>FoxDev

- Visual FoxPro Development</a><br> [/sig]

 

[Bigley]

It's a nice idea Robert but is there anyway that you can actually force it on to other users so that you can lock them out? [sig][/sig]

 

[foxdev]

I'm not sure I know what you mean by &quot;force it on to other users&quot;.

If you mean force them to check it out/in of VSS, rather than just go directly to the database and overwrite what is already there, I can't think of a way to do this.

In many shops, there is only one (with an alternate) person who actually runs the scripts against the database. The other developers check the code out/in of VSS, and request the designated DBA run their changed scripts against the database in order to create the new SPs or add or modify the tables.

There are many bonuses to this approach, including being able to &quot;version&quot; your entire database.

The obvious disadvantage is a bit more beauracracy. [sig]<p>Robert Bradley<br><a href=mailto: > </a><br><a href=

http://www.foxdev.com/>FoxDev

- Visual FoxPro Development</a><br> [/sig]

 

[Bigley]

Yeh I meant force them to check it in/out, unfortunately I work in an environment where there are 6 of us working on the same app and the time issues of passing a script to a DBA have forced us down the 'Free for all' road.

Thank you for your comments. [sig][/sig]

 

[foxdev]

I feel your pain, Bigley...there just isn't an easy AND hassle-free solution (at least none that I can think of). [sig]<p>Robert Bradley<br><a href=mailto: > </a><br><a href=

http://www.foxdev.com/>FoxDev

- Visual FoxPro Development</a><br> [/sig]

 

[Bigley]

Thanks for trying anyway buddy.....my quest continues, I'll post it on this site if I come across anything [sig][/sig]