Andy Levy wrote:
> On 4/25/06, Ruslan Sivak <rsivak@istandfor.com> wrote:
>
>> Is there some utility somewhere which allows MS SQL Server's stored
>> procedures to be kept in subversion?
>>
>
> The stored procedures are kept within the database itself. What you
> can do (and I would do, if the need was large enough), is have the
> developers/DBAs write the SPs outside SQL Server, save to files, and
> manage those files via SVN. It does require some discipline, but if
> you separate by role the individuals installing the SPs from those
> writing them, it can be done. You can do your table & view definitions
> this way as well, and track your user accounts/roles/permissions as
> well.
>
I think what you are looking for is something similar to what VSS has
done with its integration into SQL Server.
The dt_addtosourcecontrol, dt_checkinobject, dt_checkoutobject,
dt_isundersourcecontrol, etc stored procedures will all allow links
directly from the database to source code control. Unfortuantely they
are only written for VSS. I've not really looked into these much
because we primarily work on Oracle databases and use Subversion in my
department. Although the concept is pretty intriguing where you could
write a set of procedures that will check in your stored procedures from
the database and allow you to work almost exclusively inside the
database without having to worry about external flat files, I don't
think anyone has paid much attention to this yet.
Oh the possibilities if only I had more time...
Regards,
Frank
Received on Tue Apr 25 18:23:13 2006