Getting sourcecontrol on stored procedures

Posted by Steffen on Stack Overflow See other posts from Stack Overflow or by Steffen
Published on 2010-03-25T07:33:27Z Indexed on 2010/03/25 7:43 UTC
Read the original article Hit count: 322

Filed under:

subversion

|

stored-procedures

|

sql

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 :-)

© Stack Overflow or respective owner

Related posts about subversion

Does Subversion have an analogue to VSS's links?

as seen on Stack Overflow - Search for 'Stack Overflow'
I am migrating a Visual SourceSafe code repository to Subversion and I am running into a problem. Here is a simplified layout of our current source code tree (in VSS): project_root\ |-libs\ |-tools\ |-arch_1\ | |-include | |-source |-arch_2\ |-include |-source My problem… >>> More
Complex reporting on subversion (possibly Export Subversion log into database for reporting)

as seen on Stack Overflow - Search for 'Stack Overflow'
What is the best way to do complex reporting on subversion logs like the following for each file? file, directory, last revision date, previous revision date(where revision date is at least 30 older than last), days diff(between revision dates) Since Subversion allows on revision to change multiple… >>> More
Can't install py-subversion on freebsd 8.2

as seen on Super User - Search for 'Super User'
I'm trying to install python bindings for subversion: # cd /usr/ports/devel/py-subversion # make ===> Patching for py26-subversion-1.6.15 ===> Applying extra patch /usr/ports/devel/py-subversion/../../devel/subversion/files /bindings-patch-subversion--bindings--swig--perl--native--Makefile… >>> More
Access denied error when building project in Xcode after fresh SVN checkout

as seen on Stack Overflow - Search for 'Stack Overflow'
I am seeing 2 strange access denied errors which I cant solve. This error occurs when a colleague checks out the project in SVN and it tries to find a file in my downloads folder - there is nothing in my download folder though: ProcessPCH /var/folders/f0/f01B78egHdyWY62v5MABJk+++TM/-Caches-/com… >>> More
Are there any subversion "dash board" web applications that can show me a list of recent commits from all my repositories?

as seen on Programmers - Search for 'Programmers'
I am looking for something like a subversion dashboard that at the very least can show me commits from across a group of repositories. Is there anything like this available? Since it could just as well be dead simple and I can't find anything immediately I am thinking if just scratching my own itch… >>> More

Related posts about stored-procedures

SubSonic 2.2 missing stored procedures in StoredProcedures.cs when generated with sonic.exe

as seen on Stack Overflow - Search for 'Stack Overflow'
We are trying to move from SubSonic 2.0.3 to 2.2 (not using .NET 3.5). When we regenerate the project using SubCommander\sonic.exe and try to compile we get some errors reporting missing members (which should have been automatically generated based on the stored procedures we have). On closer inspection… >>> More
SubSonic missing stored procedures in StoredProcedures.cs when generated with SubCommander sonic.exe

as seen on Stack Overflow - Search for 'Stack Overflow'
We have been using SubSonic to generate our DAL with a lot of success on VS2005 and SubSonic Tools 2.0.3. SubSonic Tools do not work on VS2008 (as far as we can work out) so we have tried to use SubCommander\sonic.exe and are now hitting some problems. When we regenerate the project using SubCommander\sonic… >>> More
Drop all stored procedures in MySQL or using temporary stored procedures

as seen on Stack Overflow - Search for 'Stack Overflow'
Is there a statement that can drop all stored procedures in MySQL? Alternatively (if the first one is not possible), is there such thing as temporary stored procedures in MySQL? Something similar to temporary tables? So far, for both tasks, I seem not to find any answers although there were people… >>> More
What is your best-practice advice on implementing SQL stored procedures (in a C# winforms applicatio

as seen on Stack Overflow - Search for 'Stack Overflow'
I have read these very good questions on SO about SQL stored procedures: When should you use stored procedures? and Are Stored Procedures more efficient, in general, than inline statements on modern RDBMS’s? I am a beginner on integrating .NET/SQL though I have used basic SQL functionality for… >>> More
Creating Stored Procedures in MySQL Using HeidiSQL 4&#146;s Stored Routine Editor

as seen on Internet.com - Search for 'Internet.com'
In the "Write MySQL Queries Using HeidiSQL 4" article, we learned how to connect to a MySQL database and execute queries against it using the free HeidiSQL GUI client. Today, we'll learn how to create a stored procedure using HeidiSQL's Stored Procedure Editor. >>> More