Advice on upgrade SE (v.2.1 to 7.x !!) on SCO
We are intending to upgrade an old Informix database (version 2.1?)
and supporting 4GL (1.1) applications to current versions of the
software; so that we can get support, and also to enable us to use
some modern reporting tools to access the data. NB this is not my
idea, so please do not shout at me.
Has anyone ever tried this?
I've read the FAQ and monitored your group for a while, but obviously
the information on this kind of leap in versions is thin on the
ground. I'd be very grateful if you could you correct/clarify/add to
the following:
Seems that the problems with upgrading to version 7.x are:
* Performance : (Online only?), should I be looking at upgrading my
SCO box?
* rowids - some of our programs use rowid references for updates. The
other posts I've read seem to suggest that this is only an issue if
you use some of the clever features of the Online server. Is this
true, or should I start to worry about it (we've no intention of
going to Online - no DBA skills available etc).
* Buggy versions of Informix for SCO 3.2? I also hear that Informix
are no longer developing for this version of SCO. Should I care ?
advise pls.
More general advice gratefully received! Particualrly of the kind:
'don't bother upgrading to 7.x go to 4.0, it works with Business
Objects; doesn't kill your server; costs about $100; is completely
backwards compatible with all previous versions and will be supported
for the next 4yrs - giving you plenty of time to resign'. Or maybe
not. ;-)
Notes on current system:
---------------------------------------
The application is a sales order processing system developed in
INFORMIX-4GL using the RDS - all code is compiled as pcode. The
database is INFORMIX-SE. The app is not particualarly sophisticated
(create/update/delete/enquiry forms and reports).
Runs on a single processor Pentium PC (SCO 3.2), 64 Megs of RAM. 8/10
concurrent users - the performance is tolerable.
VERSIONS
------------------
I'm not sure what version the RDBMS is but dbschema and dbload both
report INFORMIX-SQL 2.1.
form4gl and fgldb both report INFORMIX-4GL 1.1.
TIA
Nick (nabson@derwent.co.uk)
Nick Abson : nabson@derwent.co.uk