--0-34603135-1077901312=:10106
Content-Type: text/plain; charset=us-ascii

If that Informix box is used for OLTP and when you go to Oracle, you will experience lack of performance.

Then when you revert it back you will have to spend that amount of money.

If the money is not in question here, then the experiece of it would be invaluable to you as a dba.

Thats my 2 cents in high level.


Captain Pedantic <theharlequin36@hotmail.com> 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



---------------------------------
Do you Yahoo!?
Get better spam protection with Yahoo! Mail
--0-34603135-1077901312=:10106
Content-Type: text/html; charset=us-ascii

<DIV>If that Informix box is used for OLTP and when you go to Oracle, you will experience lack of performance.</DIV>
<DIV>&nbsp;</DIV>
<DIV>Then when you revert it back you will have to spend that amount of money.&nbsp; </DIV>
<DIV>&nbsp;</DIV>
<DIV>If the money is not in question here, then the experiece of it would be invaluable to you as a dba.</DIV>
<DIV>&nbsp;</DIV>
<DIV>Thats my 2 cents in high level.</DIV>
<DIV><BR><BR><B><I>Captain Pedantic &lt;theharlequin36@hotmail.com&gt;</I></B> wrote:</DIV>
<BLOCKQUOTE class=replbq style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #1010ff 2px solid">A potential customer has asked me to provide an estimate of how long it will<BR>take to migrate their 4GL suite running on Informix "to Oracle".<BR><BR>(I'm reminded here of Obnoxio's post of a while ago ridiculing another<BR>rather vague question: "I have a piece of string in my pocket. How long is<BR>it? It's red by the way ...")<BR><BR>Seriously, though, what sort of things should we be asking beyond these?:<BR><BR>1. Complexity of schema (what sort of things, other than serial, are going<BR>to be difficult to convert?)<BR>2. Number of lines of 4GL<BR>3. Number of stored procedures and triggers<BR>4. Total number of tables<BR>5 Volume of data<BR>6. Availability of original programmers/BAs<BR>7. Quality of documentation<BR><BR>Assuming they don't want to re-write their app, they have to use a<BR>third-party "universal" compiler like 4Js or Querix (or of course Websphere<BR>EGL, if
they've the time to kill). Any other options?<BR><BR>All (constructive) comments gratefully received.<BR><BR>thank you.<BR>Capt. P<BR><BR></BLOCKQUOTE><p><hr SIZE=1>
Do you Yahoo!?<br>
Get better spam protection with <a href="http://us.rd.yahoo.com/mailtag_us/*http://antispam.yahoo.com/tools">Yahoo! Mail</a>
--0-34603135-1077901312=:10106--
sending to informix-list