diff本地软件包与数据库软件包 [英] diff local package with database package

问题描述

我需要以某种方式将pl sql软件包的本地版本与数据库中存储的版本进行比较.有什么简单"的方法可以做到吗? 目前，我从数据库下载软件包，将其保存在某些文件中，然后使用某些diff工具执行diff.这有点麻烦，所以我想在ide中拥有这样的功能(最好是使用pl sql developer).

I need somehow compare local version of pl sql package with the one that is stored in database. Are there any "easy" way to do it? Currently I download package from database, save it in some file and perform diff using some diff tool. That is a bit cumbersome, so I would like to have such feature in ide (pl sql developer is preferable).

推荐答案

通常，开发人员使用版本控制软件检查差异，维护版本历史记录并帮助协调团队开发代码. PL/SQL代码应该没有什么不同.处理代码发布的方法有很多，以下只是我见过的事情，不一定是最佳"方法.

Typically developers use versioning software to check differences, maintain version history, and help coordinate team development of code. PL/SQL code should be no different. There's many ways to handle code releases, the following is just what I've seen done, not necessarily the "best" way.

在我所看到的Oracle环境中，使用了CVS或SVN.大多数方法涉及从存储库中签出最新代码，进行编辑(标记/分支)和签入.测试代码(开发实例)并准备发布时，DBA要么从存储库中获取发布脚本并应用，要么由一个人来执行.负责将正确的发布脚本移交给DBA(根据我的经验，这很常见).请注意，这里的数据库通常是镜像生产实例的用户接受实例.如果应用测试通过，则该代码将提升为正式生产.

In the Oracle environments I've seen, CVS or SVN is used. Most approaches involve checking out latest code from repository, editing (tagging/branching), and checking in. When code is tested (development instance) and release is ready, the DBAs either grab the release scripts from repository and apply, or one individual is tasked with handing over the correct release scripts to DBAs (more common from my experience). Note that the database here is typically a user acceptance instance that mirrors the production instance. If app testing passes, the code is promoted to production.

如果您想直接在数据库和IDE之间进行同步，我看到的一个选择是Toad Team Coding. Toad不是免费的，并且此选项将需要在数据库上安装其他对象(元数据/跟踪表等).一个很好的总览在这里，并且很好设置文章在此处找到.

If you want to sync directly between the database and your IDE, the one option I've seen is Toad Team Coding. Toad is not free, and this option will require additional objects installed on the database (metadata/tracking tables, etc). A good overview is found here, and good setup article is found here.

团队编码非常酷，但是我只会安装在开发环境中.如何从那里通过系统升级代码由您决定.

Team coding is very cool, but I would only install on a development environment. How you promote the code from there through your system is up to you.

这篇关于diff本地软件包与数据库软件包的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！