Re: Informix to Oracle Migration

"Obnoxio The Chav" <obnoxio@serendipita.com> wrote in message news:1112782204.89c1281ee2350058f25f9fe910a55fd8@teranews... > > > 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..." > And more people to support it, higher running costs, more hassle etc etc