Informix Upgrade - Migrating to Oracle, Sybase, or Staying with Informix?

Question

Earlier, I posted a question to confirm our current (albeit archaic) version of Informix here:

How do you determine the version of Informix on Solaris?

(Thanks to Jonathan and RET for this)

We are definitely planning an upgrade, but first we’ll discuss whether it’s more advisable to switch to Oracle or Sybase at this time. What is your opinion on this? I believe that although all 3 RDBMs have their own uniqueness, they should all cover the same foundation. So how to decide which database to use?

Big kicker - I need to know if we will update Informix (we are currently using 7.13), will we need to change our built-in sql C programs? If not, it makes sense to stick with Informix. Because if we went with Sybase / Oracle, etc., We would have a lot of work on our updates for software products.

But if switching to another database can offer greater returns in comparison, we will consider it anyway. I look forward to hearing your opinions.

Answer 1

I am an observer (I work at IBM on Informix) - respect my comments.

Informix ESQL/C, , . , - - ( C ) - ODBC, Oracle OCI, Sybase TDS .

Informix ESQL/C (Informix ClientSDK 3.50, ESQL/C 3.50, , ESQL/C 6.00, ) , .

- . , , . (, , , ). , , .

Informix SE 7.26 - , , . , CSDK, ( INFORMIXDIR, , ).

Dynamic Server (IDS) Informix 11.50 , (DB-Export) SE (DB-Import) IDS. , IDS. IDS , SE, .

, - Informix. , .

---

IDS, ?

IDS SE, . IDS SE. , , , - , , :

• SE CREATE TABLE C-ISAM ; IDS . CREATE TABLE ( IDS , SE , VARCHAR), .
• SE CREATE AUDIT DROP AUDIT IDS ( ).
• SE START ROLLFORWARD; IDS ( IDS ).

, , . IDS , LOG MODE ANSI, SE. IDS - . IDS - , . SE . , , , . , , SE IDS. , , , , COMMIT ROLLBACK.

, SE ( , ). IDS SE - . IDS - (, ) , , .

CSDK 3.50 , .

Answer 2

Informix .

, , , O S, . : , $100 . + , $20 . P.a. . .

, , RDBMS , , , . ( - ). , ,

, , , , , . .

, .

Answer 3

Informix DB , GeneXus. Informix - , , . Informix, GeneXus IDE - . GeneXus, .