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?
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
checks in. Then, only deploy code to QA, Staging, IDE's and Production
from Source Control.
--
Galen deForest Boyer
Received on Tue Mar 08 2005 - 21:22:05 CST
