Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> AW: Update schema while new data is coming in

AW: Update schema while new data is coming in

From: <Antje.Stejskal_at_ppimedia.de>
Date: Tue, 13 Nov 2007 12:13:09 +0100
Message-ID: <6D48B8403D926449BDE8440EC7EEC46D054260D4@max.ppinet.de>


Yes I am personally sceptical that it will work, but you know mangement whishes! We are mainly using other datrabases than Oracle so I missed a bit new features.Therefore I thought, maybe ... just ask. Upgrades should mainly add new tables and columnd to existing tables.  

Antje

-----Ursprüngliche Nachricht-----
Von: Niall Litchfield [mailto:niall.litchfield_at_gmail.com] Gesendet: Dienstag, 13. November 2007 11:42 An: Antje.Stejskal_at_ppimedia.de
Cc: oracle-l_at_freelists.org
Betreff: Re: Update schema while new data is coming in

I'd require of management and the customer that they only sent data to the old application that was entirely compatible with the new application. Or to put it another way it depends on the complexity of the application and the upgrade. If the new schema and application logic is 100% compatible with the old schema ( i.e you are just adding things on and not 'fixing' anything) then you'll likely get away with it - for a reasonable upgrade of a moderately complex application you are extremely likely to find data issues after the upgrade.

On Nov 12, 2007 9:47 AM, < Antje.Stejskal_at_ppimedia.de
<mailto:Antje.Stejskal_at_ppimedia.de> > wrote:

Hi,

we are having a web application that ist o be online availyble 7x24. We plan for the scenario that the application needs a software update (new tables , modified tables et. al.) Management and customer requires that the application is still running while the upgrade goes on. How would you solve this, that you have one server with the old schema where new data is coming in, meanwhile another server is brought up to latest release. And data of the old server (or delta of data) will be send to new server. We will propably have 2 servers anyway because of the traffic. Please help me with your ideas.

Regards
Antje Stejskal

--
http://www.freelists.org/webpage/oracle-l

<http://www.freelists.org/webpage/oracle-l>
-- Niall Litchfield Oracle DBA http://www.orawin.info <http://www.orawin.info/> -- http://www.freelists.org/webpage/oracle-l
Received on Tue Nov 13 2007 - 05:13:09 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US