Re: PLEASE HELP - Decision on PL/SQL tool

Depending on the degree of control, features, and platform, I have a few suggestions.

Basic check-in/check-out/versioning/branching: UNIX, use SCCS. It's free.

VMS/OpenVMS Use DECs CM tool.

Other platforms: Use PVCS.

Steve
804-262-6332

In <4ot7uk$hs6_at_gossamer.itmel.bhp.com.au> levy.lee.ls_at_bhp.com.au (Lee Levy) writes:
>
>In article <31ADE941.5120_at_iafrica.com>, John Kotsaftis
 <jkotsaft_at_iafrica.com> says:
>>
>>I am currently working on a large data warehousing project. We are
>>developing server side stored procedures in PL/SQL and need a good
>>project management tool to do this. We need to check in/check out
 code
>>and have version control.
>>
>>We installed Oracle Procedure Builder, and unfortunately it does not
>>support server side PL/SQL stored procedure management. I am
 currently
>>looking at Platinum SQL Coder.
>>
>>What is the best tool on the market to handle this kind of work? Is
>>there an Oracle Product that supports this.
>
>I had the same issue and also looked at SQLCoder.
>While it is a very nice product, I didnt go with it because it was
>too expensive for the 20 or so server side components we have.
>My problem is that I want to be able to stop people being able to
 bypass
>the config control.
>I found that you really cant - you cant stop them jumping into
>Forms Designer and manipulating the code directly.
>Even if you took that away, you cant stop them jumping into SQL
>and manipulating the table that holds the server side code...
>
>My eventual solution was a chekclist (ughh! more paperwork) that shows
>that they have cheked it out, they HAVE CONFIRMED THE CURRENT SOURCE
>VERSION AGAINST THAT ON THE DB and they have checked it back in.
>
>HIH
>Lee
>
>---------------------------------------------------
> Lee Levy, ISSD Technical Dream Team, Del Code (34)
> BHP Information Technology, ACN 006 476 213
> PO Box 261, Warrawong, NSW 2502, Australia
> PH: +61 42 75-5485 Fax: -5500 Tie: 8855-
> Internet : levy.lee.ls_at_bhp.com.au
>---------------------------------------------------
>Opinions expressed are mostly my own, so give me some credit.
Received on Tue Jun 04 1996 - 00:00:00 CEST