Re: Informix to Oracle Migration

Posted in 2005

DA Morgan — Tue, 05 Apr 2005 22:26:06 -0700 — source: Usenet: comp.databases.informix

Girish wrote: > Hi all, > > 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. > > Thanks & Regards, > > Girish. 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. Developers repeat after me: KaChing! -- Daniel A. Morgan University of Washington damorgan@x.washington.edu (replace 'x' with 'u' to respond)