Oracle存储对象的版本控制。 [英] Version control of Oracle Stored Objects.

问题描述

我们有Oracle 9i数据库的实现。我们有一个由20名b
开发人员组成的团队。我们使用PL / SQL DEVELOPER和Visual

源安全来控制源。


我们目前遇到的问题是版本控制之一。对于

时刻，2位开发人员可以编辑和编译一个包。因为在数据库服务器上编译了包

，有可能正在编辑一个源。
$开发人员的b $ b可能会被另一个人覆盖。

PL / SQL中没有任何内容强制用户签出和编辑。我们将Visual Source

安全完全集成到PL / SQL Developer中。但是它只能获得

.VSS不能识别ORacle。

是否有可用于版本的产品

控制Oracle Aware的Oracle存储对象？


有没有更好的产品？这样做的方式？


TIA

Lig


Pl回复

褐色AT iol DOT即

We have an implementation of Oracle 9i database. We have a team of 20
developers working on a project. We use PL/SQL DEVELOPER and Visual
Source Safe to cotrol the source.

The problem we have at the moment is one of version control.For the
moment, 2 developers can edit and compile a package.Because the package
is compiled on the DB Server,It is possible that a source being edited
by a developer could be overwritten by another.There is nothing in
PL/SQL that forces a user to check out and edit. We have Visual Source
safe fully integrated into PL/SQL Developer.But that''s only as much as
it gets.VSS is not ORacle aware.
Are there any products out there that can be used for Version
controlling Oracle Stored Objects that are Oracle Aware?

Is there a better way of doing this?

TIA
Lig

Pl reply to
lignite AT iol DOT ie

推荐答案

Lig写道：

我们有一个Oracle 9i数据库的实现。我们有一个由20名开发人员组成的团队。我们使用PL / SQL DEVELOPER和Visual
Source Safe来控制源代码。

目前我们遇到的问题是版本控制问题。对于
时刻，2个开发人员可以编辑和编译一个包。因为在数据库服务器上编译了包
，开发人员正在编辑的源可能会被另一个人覆盖。
中没有任何内容。强制用户签出和编辑的PL / SQL。我们将Visual Source安全地完全集成到PL / SQL Developer中。但是它只有它得到的数量.VSS不是ORacle意识到的。

有没有哪些产品可以用于控制Oracle Aware的Oracle存储对象？

有没有更好的方法呢？

TIA

Pl回复
褐煤AT iol DOT ie

We have an implementation of Oracle 9i database. We have a team of 20
developers working on a project. We use PL/SQL DEVELOPER and Visual
Source Safe to cotrol the source.

The problem we have at the moment is one of version control.For the
moment, 2 developers can edit and compile a package.Because the package
is compiled on the DB Server,It is possible that a source being edited
by a developer could be overwritten by another.There is nothing in
PL/SQL that forces a user to check out and edit. We have Visual Source
safe fully integrated into PL/SQL Developer.But that''s only as much as
it gets.VSS is not ORacle aware.
Are there any products out there that can be used for Version
controlling Oracle Stored Objects that are Oracle Aware?

Is there a better way of doing this?

TIA
Lig

Pl reply to
lignite AT iol DOT ie

在PL / SQL Developer中安装CVS接口：
http://www.allroundautomations.nl/plsvcs.html


-

问候，

Frank van Bortel

install the CVS interface in PL/SQL Developer:
http://www.allroundautomations.nl/plsvcs.html

--
Regards,
Frank van Bortel

Frank van Bortel写道：

Frank van Bortel wrote:

Lig写道：

Lig wrote:

我们有一个Oracle 9i数据库的实现。我们有一个由20名开发人员组成的团队。我们使用PL / SQL DEVELOPER和Visual
Source Safe来控制源代码。

目前我们遇到的问题是版本控制问题。对于
时刻，2个开发人员可以编辑和编译一个包。因为在数据库服务器上编译了
包，开发人员正在编辑的源可能会被另一个包覆盖。没有任何内容强制用户签出和编辑的PL / SQL。我们已经将Visual Source安全地完全集成到PL / SQL Developer中。但是只有它得到的才能获得.VSS不是ORacle意识到的。

有没有哪些产品可以用于控制Oracle Aware的Oracle存储对象？

有没有更好的方法呢？

TIA

Pl回复
褐煤AT iol DOT ie

We have an implementation of Oracle 9i database. We have a team of 20
developers working on a project. We use PL/SQL DEVELOPER and Visual
Source Safe to cotrol the source.

The problem we have at the moment is one of version control.For the
moment, 2 developers can edit and compile a package.Because the
package is compiled on the DB Server,It is possible that a source
being edited by a developer could be overwritten by another.There is
nothing in PL/SQL that forces a user to check out and edit. We have
Visual Source safe fully integrated into PL/SQL Developer.But that''s
only as much as it gets.VSS is not ORacle aware.
Are there any products out there that can be used for Version
controlling Oracle Stored Objects that are Oracle Aware?

Is there a better way of doing this?

TIA
Lig

Pl reply to
lignite AT iol DOT ie

在PL / SQL Developer中安装CVS接口：
< a rel =nofollowhref =http://www.allroundautomations.nl/plsvcs.htmltarget =_ blank> http://www.allroundautomations.nl/plsvcs.html

只是意识到你（可能）拥有它（完全集成......）


总会有办法绕过它 - 你仍然可以使用SQL * Plus或其他任何方式进行更改。


唯一的办法是让开发人员知道你是认真的

关于源安全。如果不使用它就会威胁它们，不管它需要什么，它们都会在星期一早上带着干净的数据库惊喜。

-

问候，

Frank van Bortel

Just realize you (probably) have that (fully integrated...)

There will always be ways to go around it - you can still
use SQL*Plus, or whatever to make changes.

The only way is to let your developers know you are serious
about source safe. Threaten to fire them if not used, surprise
them with a clean database on a Monday morning, whatever it takes.
--
Regards,
Frank van Bortel

Frank van Bortel< fv ******** @ netscape.net>在消息新闻中写道：< d0 ********** @ news5.zwoll1.ov.home.nl> ...

Frank van Bortel <fv********@netscape.net> wrote in message news:<d0**********@news5.zwoll1.ov.home.nl>...

Lig写道：

我们有Oracle 9i数据库的实现。我们有一个由20名开发人员组成的团队。我们使用PL / SQL DEVELOPER和Visual
Source Safe来控制源代码。

目前我们遇到的问题是版本控制问题。对于
时刻，2个开发人员可以编辑和编译一个包。因为在数据库服务器上编译了包
，开发人员正在编辑的源可能会被另一个人覆盖。
中没有任何内容。强制用户签出和编辑的PL / SQL。我们将Visual Source安全地完全集成到PL / SQL Developer中。但是它只有它得到的数量.VSS不是ORacle意识到的。

有没有哪些产品可以用于控制Oracle Aware的Oracle存储对象？

有没有更好的方法呢？

TIA


回复
褐煤AT iol DOT即

We have an implementation of Oracle 9i database. We have a team of 20
developers working on a project. We use PL/SQL DEVELOPER and Visual
Source Safe to cotrol the source.

The problem we have at the moment is one of version control.For the
moment, 2 developers can edit and compile a package.Because the package
is compiled on the DB Server,It is possible that a source being edited
by a developer could be overwritten by another.There is nothing in
PL/SQL that forces a user to check out and edit. We have Visual Source
safe fully integrated into PL/SQL Developer.But that''s only as much as
it gets.VSS is not ORacle aware.
Are there any products out there that can be used for Version
controlling Oracle Stored Objects that are Oracle Aware?

Is there a better way of doing this?

TIA
Lig

Pl reply to
lignite AT iol DOT ie

在PL / SQL Developer中安装CVS接口：
< a rel =nofollowhref =http://www.allroundautomations.nl/plsvcs.htmltarget =_ blank> http://www.allroundautomations.nl/plsvcs.html

当VSS（据说）使用
时，2位开发人员如何编辑包？这听起来像开发人员没有正确使用源代码控制

和动态编辑PL / SQL。很可能你应该得到你的DBA

撤销

开发者的CREATE PACKAGE / FUNCTION / PROCEDURE特权，只让你的DBA执行相应的发布版本

环境


Andy

How can 2 developers edit a package when VSS is (supposedly) being
used? This sounds like developers not using source control properly
and editing PL/SQL on the fly. Prehaps you should get your DBA to
revoke the CREATE PACKAGE/FUNCTION/PROCEDURE privilige from the
developers and only let your DBA perform releases to the appropriate
environments

Andy

这篇关于Oracle存储对象的版本控制。的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！