Oracle-L: RE: Moving Code to Production

From: DENNIS WILLIAMS <DWILLIAMS_at_LIFETOUCH.COM>
Date: Thu, 22 May 2003 06:53:08 -0800
Message-ID: <F001.0059FD63.20030522065308@fatcity.com>

Ken - What code do you mean? I have always let the developers be responsible for their code. At some sites PL/SQL code might be considered the DBA responsibility.

What we are moving toward is a 3-environment setup, Production, Staging, and Development (or test). The idea is that when the developers are ready to promote something to Production, you will clone production to the Staging environment. Then they will provide scripts that will make the database changes against the Staging environment. Once that has been done, then testing will be performed to assure the quality of the result. When testing is complete, then the Production change will be scheduled and carried out.

I hope this responds to your issue.

Dennis Williams
DBA, 80%OCP, 100% DBA
Lifetouch, Inc.
dwilliams_at_lifetouch.com

-----Original Message-----
Sent: Thursday, May 22, 2003 9:27 AM
To: Multiple recipients of list ORACLE-L

Would like some feedback as to what to check, etc. when moving new code changes into the production environment.

Thanks much,
Ken Janusz, CPIM

--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: DENNIS WILLIAMS
INET: DWILLIAMS_at_LIFETOUCH.COM

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Thu May 22 2003 - 09:53:08 CDT