Re: Source Control for DB objects
- From: Marco Gralike <Marco.Gralike@xxxxxxx>
- To: "oracle@xxxxxxxxxx" <oracle@xxxxxxxxxx>, "JChirco@xxxxxxxxxx" <JChirco@xxxxxxxxxx>
- Date: Wed, 3 Aug 2011 20:39:44 +0200
(Ab)using the database as a versioning environment ;-)
http://xace.sourceforge.net (compatible from 9.2 and onwards) based on XMLDB
and APEX
From: Morten Egan <oracle@xxxxxxxxxx<mailto:oracle@xxxxxxxxxx>>
Reply-To: "oracle@xxxxxxxxxx<mailto:oracle@xxxxxxxxxx>"
<oracle@xxxxxxxxxx<mailto:oracle@xxxxxxxxxx>>
Date: Wed, 3 Aug 2011 19:52:22 +0200
To: "JChirco@xxxxxxxxxx<mailto:JChirco@xxxxxxxxxx>"
<JChirco@xxxxxxxxxx<mailto:JChirco@xxxxxxxxxx>>
Cc: Oracle-L <oracle-l@xxxxxxxxxxxxx<mailto: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<mailto: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
Other related posts:
