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?
>
> All (constructive) comments gratefully received.
>
> thank you.
> Capt. P

After you migrate it who is going to perform DBA and developer jobs? If it is the former Informix people they will likely need substantial retraining. I am aware of classes for Informix-to-Oracle I can refer you to off you contact me off-line.

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)