April 15, 2004 at 9:54 am
Our shop uses VB.NET and stored procs heavily. We also use SourceSafe which provides no easy way to capture the stored procs. Can you reocmmend any source control solution that seamlessly handles source code, stored procs, and maybe even sql schemas?
TIA,
Bill
P.S. I have seen MSDN articles on how to transfer stored procs to SourceSafe but it is a burden. Any it's not easy (impossible) to automate SourceSafe.
April 15, 2004 at 11:31 pm
Currently use this product and it works rather nicely...
http://www.xpressapps.com/manual/vers_contr_grp.htm
April 19, 2004 at 8:58 am
We are building VB.NET and ASP.NET applications, using VisualStudio.NET, and I currently wear both DBA and lead developer hats in our current environment. Therefore I have a full install of VS.NET Enterprise Developer available to me.
We work in a DEV-BETA-Production type environment with separate databases and web sites for each level. I've been working with the "Database Project" available from VS.NET with all changes being scripted, and those scripts stored as part of the project. I then use VS.NET's integration with VSS to maintain version controlI create a new datatbase project for each "phase" of our project, so I can group changes for easy rollout from Dev to Beta, then from Beta to production. VS.NET will even build command files to execute the scripts in your project for you.
I have only been using this methodology for a short time, and I'm still perfecting the procedures around it. However, it's been quite successful so far.
Ross Environmental Services
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply