Re: How-To or Good Practices on Code Releases

[Yechiel Adar]

Title: How-To or Good Practices on Code Releases

Whenever I install a new release of software my boss wants to know: How do you return to the old version if this does not work?   For each install script require an undo script.   We are using toad to compare schemas and it can also generate script to convert from one schema to the other.   Yechiel Adar Mehish ----- Original Message ----- From: Jamadagni, Rajendra To: Multiple recipients of list ORACLE-L Sent: Wednesday, November 13, 2002 5:29 PM Subject: How-To or Good Practices on Code Releases Friends ... I have a (sort of) problem ... what are the best practices to manage code releases to production environment ... currently we get a bunch of scripts from development team, and we release code to production on the schedule (currently twice a month). But this is not complete. The scripts we get consists of various DML and DDL statements. We do not have a mechanism to roll-back these changes in place and I am seeking your opinion on ways to achieve these. Also we would like to implement script dependencies (which we manage manually right now) and rollback mechanism. Are there any good practices papers? I know these would be site specific, but I am looking for common methods. Hope I make myself clear ... (and if it matters it is Oracle 9.2 and Forms/Reports) application. Raj ______________________________________________________ Rajendra Jamadagni              MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art!