Re: Source Control for DB objects

  • From: Jeremy Schneider <jeremy.schneider@xxxxxxxxxxxxxx>
  • To: Joel.Patterson@xxxxxxxxxxx
  • Date: Thu, 4 Aug 2011 09:30:10 -0500

Personally I'm a big fan of git for version control... and I do have a bit
of a personal soap-box about how DBAs are really developers but act like
they're not.  (We don't ever seem to follow many well-thought out practices
about code development... even though we often manage thousands of lines of
code in shell scripts/SQL and change lots of configuration & schema related
things spontaneously without any kind of record or reproducibility...)

At two recent large orgs where I worked, they were still using CVS for the
DBA group.  This was not because CVS is great, but just because it was there
and the DBA's didn't care much about recent advancements in development
practices.  (Very recent quote from one DBA: "if it's not broke, then don't
fix it.")  Subversion does seem to be pretty popular on the whole - and it
is integrated with quite a few tools.  Although I think that you can
increasingly find plugins for the more recent source control packages too
(like git or mercurial)... and of course there are the commercial
alternatives too, like clearcase (used at another large org where I
worked).  If I remember right, Oracle's OSS website runs on subversion and
the linux kernel uses git.

I'm interested to follow this thread - and hear what other people are
using.  In particular, I'd also be curious what development tools you use
(Oracle's SQL Developer? Toad?) and if your tools integrate with your source
control system for PL/SQL scripts.  I'd also be curious to hear what you put
into change control - just PL/SQL code, or also system configuration/schema
updates?  How about shell scripts?

-Jeremy


On Wed, Aug 3, 2011 at 1:42 PM, <Joel.Patterson@xxxxxxxxxxx> wrote:

> **
>
> It used to be that Source Safe had some security issues, inferior to what
> was then ‘PVCS’, and not really fixable.   I forgot what it was exactly, but
> keep that in mind.  I think it was a back door or something like that.****
>
> ** **
>
> **Joel P**atterson
> Database Administrator
> 904 727-2546 ****
>   ------------------------------
>
> *From:* **oracle-l-bounce@xxxxxxxxxxxxx** [mailto:**
> oracle-l-bounce@xxxxxxxxxxxxx**] *On Behalf Of *Morten Egan
> *Sent:* Wednesday, August 03, 2011 1:52 PM
> *To:* JChirco@xxxxxxxxxx
> *Cc:* oracle-l@xxxxxxxxxxxxx
>
> *Subject:* Re: Source Control for DB objects
> ****
>
>  ** **
>
> I know most of my customers that do use source control for their code, use
> subversion, and I do as my customers do :)
>
>
> Though I do see something interesting happening with the Editions feature
> in oracle 11g. Currently I dont see it as a replacement for other source
> control systems (mostly because you can only have a single threaded
> versioning model, i.e. only one edition can be a child of the parent
> edition), but given time to improve I can definitely see the opportunity to
> do the versioning inside the development database itself.
>
> One of my current wacky ideas, for (ab)using the edition feature right now,
> would be to create a string of editions every morning (one for every
> developer), let them work all day and then have a merging process after a
> days work, then repeating the process again the next morning. But at the
> current level of the feature, that would require a lot of "manual merging"
> procedures .... but could be a fun experiment.****
>
>  2011/8/1 Jeff Chirco <JChirco@xxxxxxxxxx>****
>
> What is everybody using as a source control for your
> packages/procedures/functions etc…?  And how do you have it configure/setup?
> ****
>
> We are currently using Microsoft Visual Source Safe and it works ok but I
> would like to see if there is a different way or something better.  I create
> a different Project for each schema and put all
> packages/procedures/functions etc… inside that project and then we check out
> the individual package when needed.****
>
> I would also like to see if there is something different that could handle
> multiple check outs by different users.  I know this could get messy.****
>
>  ****
>
>
>
>
> --
> Regards,
> Morten Egan
> http://www.dbping.com****
>



-- 
http://www.ardentperf.com
+1 312-725-9249

Jeremy Schneider
Chicago

Other related posts: