Getting sourcecontrol on stored procedures

Question

First off the technical stuff:

We're using VS 2008 pro and running a MS SQL 2008 server. For sourcecontrol we use Subversion.

We'd really like to keep our stored procedures in subversion, so we can tell what was changed, when and so forth.

However in order for this to work, it has to be seamless, otherwise the developers are just going to forget getting the procedures included in their commits.

So are there any good solutions for this ?

I'm certain we can't be the only company with this issue :-)

Answer 1

In Visual Studio 2008, you can create a database project which will allow you to store all of your Stored Procedures and any other SQL statements within a nice project, which can then be housed in Subversion.