Re: Informix to Oracle Migration

Obnoxio The Chav wrote: > DA Morgan said: > >>Girish wrote: >> >> >>>We have an application written in Informix 4gl and Esql/C which >>>communicates with Informix database. >>> >>>We are doing an exercise of migrating this application from Informix >>>to Oracle database. For compiling this, right now Hydra compiler is >>>used which is a third party tool from QueriX. We are facing some >>>issues with this tool because of license restrictions. >>> >>>If anybody has any info about any other such tool which can compile >>>Informix4gl code communicating with Oracle database, please reply to >>>my ID. >> >>I would strongly urge you to not do that which you are contemplating. >>The underlying concepts and architecture of Oracle are substantially >>different from those in Oracle and likely you will be lucky if it is >>just unscalable and performs poorly. To work in an environment with >>multiversion read consistency where reads don't block writes and writes >>don't block reads means recoding. > > > I agree with the heffalump, but it seems to me that Oracle's official > response would be "chuck more tin at it..." > In other words: Congratulations you are locked in. Help increase Oracle's GPM with your support contract :-) Cheers Serge -- Serge Rielau DB2 SQL Compiler Development IBM Toronto Lab