Release Control package?

I am part of a small IT shop. A handful of people are responsible for Oracle development, Integration testing and Production environments. The same people also administer the Unix boxes hosting the Oracle databases. This has raised some red flags in the internal and external IT audits.

In particular, the area of promoting and deploying Oracle source code to Production.

I was wondering...is there some packaged software out there that can do the following:

1. Provide a front-end (preferably browser based) to accept a SQL file (containing stored code, DDL, etc) and run that against the Oracle database
2. Ability to generate reports against a known baseline of source code, DDL versus the database and report if any unauthorized (not via Step 1) changes have been made to the database
3. Generate various reports to show what got released to Prod on what date, by whom, etc. Management reports to satisfy the higher-ups in case there is a audit.
4. If some SQL fails to compile or results in invalid objects, it should re-run the known (baseline) version of that code. Of course, if the new SQL succeeds, it should become the baseline going forward.

You get the idea...

Is there anything like this out there? Or do people generally roll their own?

Thanks Received on Wed Feb 26 2003 - 19:34:16 CST