Restore Imformix Database to different server

Hello all,

I have a backup done on an IBM Informix database and need to extract the information contained in it.   We have a customer with an old card access system that was running an Informix database.   The system has since died and we are in the process of migrating to a new platform.   The new system runs on MSSQL and the manufacturer no longer supports the old system.

Is there any way that I can mount this backup to get at the tables?   I have downloaded the IBM Informix virtual appliance and have it running, but from what I can tell, in order to restore a database, the hardware and file structure need to be exactly the same, which it isn't.

It appears that I have a level 0 backup of the three databases.

Any suggestions?

Thank you!

Who is Participating?
robocatConnect With a Mentor Commented:
You are correct, in order to restore an Informix database, the hardware environment must be very similar. Not identical, but very similar.

The logical file structure must also be the same (path names, sizes etc) although this can be bypassed using logical links, and raw devices (disks) can be replaced by files.  This requires that the old system was carefully documented, in order to recreate the logical file structure.

What hardware and OS was the system running on? Did it use raw devices ?
jamesjcooperAuthor Commented:
I don't have access to the file system from the old machine, and can't seem to get any information from the original manufacturer.

The old machine was running Redhat Linux, not sure what version of Linux or Informix.   The hardware was an older Dell 1910 server.
I'm afraid you do need to know the exact version of Informix and the file system structure.
No filesystem backups ? No access to the old disks ?
jamesjcooperAuthor Commented:
It doesn't look like it, but I'm still trying to get access to the old box.
Duncan RoeSoftware DeveloperCommented:
Pursue that for sure. If the hard drives themselves are still OK it would be worth getting a spare system (from a swap meet, say) and installing them. Then boot off a live DVD like Knoppix, and you can work on the old drives forensically.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.