Re: Informix to Oracle Migration
A poster asked for alternatives to QueriX's Hydra compiler (which they had licensing problems with) so they could compile Informix 4GL/ESQL-C code against an Oracle database as part of an Informix-to-Oracle migration. No one named an alternative tool. Instead the thread turned into advice against the migration at all — arguing Oracle's architecture (multiversion read consistency, locking behaviour) would require real recoding, not just recompiling — plus vendor-lock-in and cost jabs, a dispute over which product costs more, and quibbles about typos. No resolution is recorded.
Auto-generated by DrWatson from the posts below — may be imperfect; read the full thread.
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..." -- Bye now, Obnoxio "C'est pas parce qu'on n'a rien ' dire qu'il faut fermer sa gueule" - Coluche "I'm trying to see things your way, but I can't get my head up my ass" - JCH "Ogni uomo mi guarda come se fossi una testa di cazzo" - Marco Travel broadens a person. You look as if you have been all over the world. I went to the airport to check in and they asked what I did because I looked like a terrorist. I said I was a comedian. They said, "Say something funny then." I told them I had just graduated from flying school. -- Ahmed Ahmed http://i2.photobucket.com/albums/y41/Obnoxio/thinkIfoundtheproblem.jpg sending to informix-list
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
[snipp] >Obnoxio The Chav wrote: >> DA Morgan said: >> >>>Girish wrote: >>> >> >In other words: Congratulations you are locked in. Help increase >Oracle's GPM with your support contract :-) > >Cheers >Serge Or; asthe 1st repondent said: "KACHING!!!!" And WHY would you want to migrate this to Oracle. Does your company have too much money? Regards, Robert A. Reissaus IBM/Informix Consultant Amsterdam the Netherlands
Serge Rielau wrote: > 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 Interesting job of snipping ... I never wrote what appears to be attributed to me. -- Daniel A. Morgan University of Washington damorgan@x.washington.edu (replace 'x' with 'u' to respond)
r.a.reissaus@risdi.com wrote: > [snipp] > >>Obnoxio The Chav wrote: >> >>>DA Morgan said: >>> >>> >>>>Girish wrote: >>>> >>> >>In other words: Congratulations you are locked in. Help increase >>Oracle's GPM with your support contract :-) >> >>Cheers >>Serge > > Or; asthe 1st repondent said: > "KACHING!!!!" > And WHY would you want to migrate this to Oracle. Does your company > have too much money? > Regards, > Robert A. Reissaus > IBM/Informix Consultant > Amsterdam > the Netherlands What makes you think Oracle costs more than Informix? -- Daniel A. Morgan University of Washington damorgan@x.washington.edu (replace 'x' with 'u' to respond)
DA Morgan wrote: > Serge Rielau wrote: > >> Obnoxio The Chav wrote: >> >>> DA Morgan said: >>> <snip> >>>> 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. <snip> I am still trying to work out the above sentence. Interestingly my word of the day is tortology - spooky.
TBP wrote: > DA Morgan wrote: > >> Serge Rielau wrote: >> >>> Obnoxio The Chav wrote: >>> >>>> DA Morgan said: >>>> > > <snip> > >>>>> 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. > > > <snip> > > I am still trying to work out the above sentence. > > Interestingly my word of the day is tortology - spooky. Tautology! tau'tol'o'gy Audio pronunciation of "tautology" ( P ) Pronunciation Key (t'-tl-j) n. pl. tau'tol'o'gies 1. 1. Needless repetition of the same sense in different words; redundancy. 2. An instance of such repetition. 2. Logic. An empty or vacuous statement composed of simpler statements in a fashion that makes it logically true whether the simpler statements are factually true or false; for example, the statement Either it will rain tomorrow or it will not rain tomorrow. Mashed!
"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
"DA Morgan" <damorgan@x.washington.edu> wrote in message news:1112795987.285122@yasure... > r.a.reissaus@risdi.com wrote: > > > [snipp] > > > >>Obnoxio The Chav wrote: > >> > >>>DA Morgan said: > >>> > >>> > >>>>Girish wrote: > >>>> > >>> > >>In other words: Congratulations you are locked in. Help increase > >>Oracle's GPM with your support contract :-) > >> > >>Cheers > >>Serge > > > > Or; asthe 1st repondent said: > > "KACHING!!!!" > > And WHY would you want to migrate this to Oracle. Does your company > > have too much money? > > Regards, > > Robert A. Reissaus > > IBM/Informix Consultant > > Amsterdam > > the Netherlands > > What makes you think Oracle costs more than Informix? Um - needs more people to tune it and keep it running, developers cost more, and it's expensive to buy? And that's on a new site. You're surely not suggesting that a port to Oracle., plus training, new staff and licencing costs is likely to cost less?