Re: SQL and configuration management using Oracle Repository Object Navigator 9ias

bpg wrote:
> Hi,
>
> We are developing a forms based application using 9ias developer suite
> under windows2000. We use the Oracle Repository Object Navigator (RON)
> for version control and general configuration management – no problem
> there. We are not using Designer. However unlike forms, as SQL can be
> stored in the DB there is no requirement to maintain SQL scripts in
> the file system from where they can be checked in/out to the RON. For
> proper version control our developers store SQL in flat files and
> check in/out, however occasionally changes are made to the SQL in the
> database causing it to get out of synch with the repository. To ensure
> correctness we can replace the SQL in the repository with an extract
> from the DB but this is not entirely satisfactory
>
> Any body any suggestions as to how best to manage SQL in such an
> environment to minimize risk and maximize control
>
> Cheers
>
> bg

What I've done in the past is to write a script which nightly extracts source code & then deposits it into the production locations. Simply put if/when you do NOT make changes within the repository, then your changes go way overnight. Folks quickly learn that they MUST work with the repository if they want their changes to remain. Received on Wed May 14 2003 - 02:18:34 CEST