Helmut, Not sure of the scope of your request, but I'll try and help.
If you are talking about ERP packages, I think it's easier to control - you only move stuff after much testing in a development/user test environment, and it all goes as a package. If you are talking about home-grown stuff, change control starts at the development level. For the current project that I am on, I (the Dba team) established a formal change request application for the developers. They submit a request to change a database object. the request gets reviewed and implemented by the DBA team in development. There are four check boxes for each request that indicate when the request was implemented in each of the environments (Dev, User Test, Train & Prod). Reports are run to indicate which request is "eligible" to be moved to the next level (implemented in Dev, but not in User test). When a build is requested, this report is reviewed, and things are moved up as needed. So we always know when things are moved up and what request is where. A pretty simple application (written in MSAccess) that is working well for us. Hope this helps. Tom Mercadante Oracle Certified Professional -----Original Message----- Sent: Friday, October 31, 2003 2:59 AM To: Multiple recipients of list ORACLE-L Hi! A somewhat off-topic question this time. I am put in charge of defining the procedure of moving projects from test/development into the production environment. This is to be seen from the entire IT-perspective (i.e. not just databases, but also Unix, Oracle and SAN). I.e. we should come up with check-lists and the like; although having an eye on quality assurance... We urgently need to set procedures up for that since the last time this was a nightmare... Did anybody out there work on a similar project? What are the procedures that you are following? Any input would be appreciated. This is 9.2 on HP-UX 11. Thanks, Helmut Helmut Daiminger WWK Lebensversicherung a.G. Marsstrasse 37 80292 M�nchen Telefon: (0 89) 51 14 - 3490 Fax: (0 89) 51 14 - 27 62 mailto:[EMAIL PROTECTED] http://www.wwk.de *** select 'bye for now' from sys.dual *** -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Daiminger, Helmut INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mercadante, Thomas F INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
