Re: Version control of Oracle Stored Objects.

On Fri, 04 Mar 2005, lignite_at_iol.ie wrote:
> 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?

[Quoted] Yes, give each developer his own schema and have him deploy the code from source control to that schema. When he is done fixing his code, he [Quoted] checks in. Then, only deploy code to QA, Staging, IDE's and Production [Quoted] from Source Control.

-- 
Galen deForest Boyer