Advice on Informix/Oracle switch
Posted in 2000
Topics: Connectivity: ESQL/C, 4GL & Embedded SQL, Server Administration
We've been using Informix since 1986 and are VERY happy with it. Unfortunately, we've recently come under a new organization which has mandated that we switch from our current HP/Informix environment to their Sun/Oracle environment. We're NOT happy about it, but have no choice. Does anyone have experience with both Informix and Oracle who can answer the following questions for me: 1. What are the Oracle equivalents of the following Informix products which we use? Informix SE Informix 4GL Informix SQL Informix ESQL/C 2. How stable is the corresponding Oracle database engine compared to Informix? 3. Does the corresponding Oracle database engine require more systems administration? (SE administration is minimal, which is great for a 3 person shop) 4. We have been told there are tools which convert Informix code to Oracle. Do they really work, or would we be better recoding everything from scratch? All of our data entry software is written in 4GL, and our communication software with remote systems is in ESQL/C. 5. What advice can you give us on training, etc. for this conversion effort. Thanks. Willis Gregory