版本化存储过程/PLSQL? [英] versioning stored procedures/PLSQL?

问题描述

是否有有效的方法来版本化用PL/SQL编写的存储过程? (我之所以只提到PL/SQL，是因为可能存在一个特定的工具，任何针对存储过程版本控制的答案都是理想的选择.)

解决方案

在我当前的工作中，团队现在正在使用以下方法对PL/SQL进行版本控制.在编译PL/SQL时，无论编译成功还是不，一条记录将被插入到日志表中.除了深夜，还有一个JAVA代理被安排为自动运行，以检查是否需要将PL/SQL源签入CVS.

更新

现在链接到博客的地址是 http://technology.amis.nl/blog/846/plsql-source-code-control-inside-the-database-after-compile-trigger-for-自动归档

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 ideal).

解决方案

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

这篇关于版本化存储过程/PLSQL?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！