Re: Informix to Oracle migration
--Alt-Boundary-15354.870137578 Content-type: text/plain; charset=US-ASCII Content-transfer-encoding: 7BIT Content-description: Mail message body We have a very large number of customers who have already done this, I will point out where the main work is. On 27 Feb 2004 at 12:29, 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?) 1. The schema conversion is done automatically taking care of all types including serial, datetime etc. All you have to do is to create a 4GL program from your exported schema file, more detail on our website. > 2. Number of lines of 4GL No problem, we have customers with over 7,000 K of 4gl and sql/c lines. > 3. Number of stored procedures and triggers This bit has to be done manually, but the call from the 4GL remains the same. > 4. Total number of tables No issue > 5 Volume of data No issue > 6. Availability of original programmers/BAs Only people who know how to run the application. > 7. Quality of documentation Not really unless you wish to change the program. Our experience show that in the worst cases < 1% of the code needs to be changed. > > 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 > > ---------------------------------------------------------------------------------------------- ---------------------------- Hydra 4 = Informix Compatible 4GL Compiler with various GUI Front End and Graphical IDE. Where to find: http://www.querix.com ---------------------------------------------------------------------------------------------- ----------------------------- --Alt-Boundary-15354.870137578 Content-type: text/html; charset=US-ASCII Content-transfer-encoding: 7BIT Content-description: Mail message body <?xml version="1.0" ?><html> <head> <title></title> </head> <body> <div align="left"><font face="Arial"><span style="font-size:10pt">We have a very large number of customers who have already done this, I will point out where the main work is.</span></font></div> <div align="left"><br/> </div> <div align="left"><font face="Arial"><span style="font-size:10pt">On 27 Feb 2004 at 12:29, Captain Pedantic wrote:</span></font></div> <div align="left"><br/> </div> <div align="left"><font face="Arial" color="#7f0000"><span style="font-size:10pt">> A potential customer has asked me to provide an estimate of how long it</span></font></div> <div align="left"><font face="Arial" color="#7f0000"><span style="font-size:10pt">> will</span></font></div> <div align="left"><font face="Arial" color="#7f0000"><span style="font-size:10pt">> take to migrate their 4GL suite running on Informix "to Oracle".</span></font></div> <div align="left"><font face="Arial" color="#7f0000"><span style="font-size:10pt">> </span></font></div> <div align="left"><font face="Arial" color="#7f0000"><span style="font-size:10pt">> (I'm reminded here of Obnoxio's post of a while ago ridiculing another</span></font></div> <div align="left"><font face="Arial" color="#7f0000"><span style="font-size:10pt">> rather vague question: "I have a piece of string in my pocket.  How long</span></font></div> <div align="left"><font face="Arial" color="#7f0000"><span style="font-size:10pt">> is</span></font></div> <div align="left"><font face="Arial" color="#7f0000"><span style="font-size:10pt">> it?  It's red by the way ...")</span></font></div> <div align="left"><font face="Arial" color="#7f0000"><span style="font-size:10pt">> </span></font></div> <div align="left"><font face="Arial" color="#7f0000"><span style="font-size:10pt">> Seriously, though, what sort of things should we be asking beyond</span></font></div> <div align="left"><font face="Arial" color="#7f0000"><span style="font-size:10pt">> these?:</span></font></div> <div align="left"><font face="Arial" color="#7f0000"><span style="font-size:10pt">> </span></font></div> <div align="left"><font face="Arial" color="#7f0000"><span style="font-size:10pt">> 1. Complexity of schema (what sort of things, other than serial, are</span></font></div> <div align="left"><font face="Arial" color="#7f0000"><span style="font-size:10pt">> going to be difficult to convert?)</span></font></div> <div align="left"><br/></div> <div align="left"><font face="Arial"><span style="font-size:10pt">1.  The schema conversion is done automatically taking care of all types including serial, datetime etc.  All you have to do is to create a 4GL program from your exported schema file, more detail on our website.</span></font></div> <div align="left"><br/> </div> <div align="left"><font face="Arial" color="#7f0000"><span style="font-size:10pt">> 2. Number of lines of 4GL</span></font></div> <div align="left"><br/></div> <div align="left"><font face="Arial"><span style="font-size:10pt">No problem, we have customers with over 7,000 K of 4gl and sql/c lines.</span></font></div> <div align="left"><br/> </div> <div align="left"><font face="Arial" color="#7f0000"><span style="font-size:10pt">> 3. Number of stored procedures and triggers</span></font></div> <div align="left"><br/></div> <div align="left"><font face="Arial"><span style="font-size:10pt">This bit has to be done manually, but the call from the 4GL remains the same.</span></font></div> <div align="left"><br/> </div> <div align="left"><font face="Arial" color="#7f0000"><span style="font-size:10pt">> 4. Total number of tables</span></font></div> <div align="left"><br/></div> <div align="left"><font face="Arial"><span style="font-size:10pt">No issue</