This post on “How to design a release management strategy for Oracle pl/sql? ” was my question recently.
Is there any tools you may be using within your big projects for this need(maybe some opensource tools) and would you share your strategies?
These are perceived as the weak side of this great development environment and it is known there are also big PL/SQL based projects like Advanced Replication, Applications module, Workflow and Apex inside Oracle. But where are the tools that can be easily found and used for other development environments for PL/SQL?
Bob Baillie has done quite a lot of work in this area. As far as I know he hasn’t published any of his code, but he has talked quite a bit about his PatchRunner concept in discussion with Wilfred van der Deijl . Check out Bob’s blog: http://robertbaillie.blogspot.com/2005/08/database-patch-runner.html
Cheers, APC
Comment by radiofreetooting — September 6, 2007 @ 1:21 pm |
Hi Hasan
I have used the Oracle 9i Change Management Pack in the past to compare dbs after an upgrade from 8i to 10g. What I found it useful for was that it would do something like ‘diff’ the two different versions 8i and 10g of the same database after a migration (say from one box to another), on many aspects, and find the differences on many things, including procedures of PL/SQL. Would display them graphically even! It could even apply the different bit from the old one to the new one by generating the necessary scripts for your. Plus would let you save versions! I am not sure what does the 10g and 11g offer currently on this, maybe there is something in OEM.
It is worth having a look though on the 9i stuff below, as it can compare pl/sql procedures, diff them and let you store them in versions. It needs a kind of repository and off you go connect to 2 databases prod/dev start comparing saving and applying.
http://oraclelon1.oracle.com/docs/cd/B10501_01/em.920/a96679/overview.htm
Kind Regards and Iyiaksamlar!
Kubilay
Comment by kubilaycilkara — September 6, 2007 @ 5:43 pm |
APC, Kubilay thank you for your comments.
This blog is a gold mine in deed –
http://robertbaillie.blogspot.com/2007/09/database-build-script-greatest-hits.html
But still I can not find a single tool inside Oracle or opensource to automate these fundamental needs of any development environment.
Best regards.
Comment by H.Tonguç Yılmaz — September 7, 2007 @ 6:52 am |
Also this one is an interesting article –
http://myracle.wordpress.com/2007/09/05/plsql-code-versioning-possible-in-oracle-10g-with-flashack/
Comment by H.Tonguç Yılmaz — September 8, 2007 @ 6:22 am |
Jeff Atwood on database version control -
http://www.codinghorror.com/blog/archives/001050.html
Comment by H.Tonguç Yılmaz — February 5, 2008 @ 5:31 am |