RE: Informix to Oracle migration

I believe that 4Js have a document outlining the datatype conversion difficulties. Maybe you should ask them about this. But I would ask them how long it took to TEST the application in the first place. That is going to be the biggest part of the process. Or don't people believe in testing anymore? Malcolm -----Original Message----- From: owner-informix-list@iiug.org [mailto:owner-informix-list@iiug.org] On Behalf Of Captain Pedantic Sent: 27 February 2004 12:29 To: informix-list@iiug.org Subject: Informix to Oracle migration 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 sending to informix-list

malcolm weallans wrote: > > Or don't people believe in testing anymore? Please explain this unfamiliar term...? -- "C'est pas parce qu'on n'a rien ' dire qu'il faut fermer sa gueule" - Coluche