开发者

versioning stored procedures/PLSQL?

Is there an efficient way to version store procedures written in PL/SQL? (I only mention PL/SQL because there may exist a particular tool, any answer directed to versioning of stored procedures is id开发者_如何转开发eal).


In my current job , the team is now using the following method to version control the PL/SQL .When compiling the PL/SQL , no matter compile successfully or not , a record will be inserted into the log table . Besides in the mid-night , there is an JAVA agent to be scheduled to run automatically check if the PL/SQL source needed to check into the CVS.

Update

Link to blog now is AMIS TECHNOLOGY BLOG


The following link no longer works

http://technology.amis.nl/blog/846/plsql-source-code-control-inside-the-database-after-compile-trigger-for-automatic-archiving


Can you use a 'regular' version control system? All of our deployed/deployable stored procs are controlled just like application code.

It's been a while since I've dealt with PL/SQL, so I don't have anything to offer on the package definitions.

Granted, this isn't in the database, but...


We built a tool so that we can manage our PL/SQL code in the Oracle Database. It hooks Git to the Oracle database and helps you manage your PL/SQL code base easily. You can do basic Git tasks such as commiting, resetting, branching, cloning, merging, pulling etc... and Gitora automatically updates the PL/SQL code in the database.

You can download it at www.gitora.com.


Oracle's free SQL Developer tool has integration with CVS and Subversion for version control of PL/SQL code.

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜