Re: Informix to Oracle migration

Captain Pedantic wrote:

> A potential customer has asked me to provide an estimate of how long it
> will take to migrate their 4GL suite running on Informix "to Oracle".
>
> (I'm reminded here of Obnoxio's post of a while ago ridiculing another
> rather vague question: "I have a piece of string in my pocket. How long
> is
> it? It's red by the way ...")
>
> Seriously, though, what sort of things should we be asking beyond these?:
>
> 1. Complexity of schema (what sort of things, other than serial, are going
> to be difficult to convert?)
> 2. Number of lines of 4GL
> 3. Number of stored procedures and triggers
> 4. Total number of tables
> 5 Volume of data
> 6. Availability of original programmers/BAs
> 7. Quality of documentation
>
> Assuming they don't want to re-write their app, they have to use a
> third-party "universal" compiler like 4Js or Querix (or of course
> Websphere
> EGL, if they've the time to kill). Any other options?

Querix would probably be the best bet. Many years ago, someone I knew did it and raved about the ease of the migration and performance improvements, but then of course, they did a massive hardware upgrade at the same time. :o)

> All (constructive) comments gratefully received.

-- 
"C'est pas parce qu'on n'a rien à dire qu'il faut fermer sa gueule"
- Coluche