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?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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 ?

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
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.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today

From novice to tech pro — start learning today.