Migrating Informix 7.2 to Oracle ?.?.?

[Scott Buckingham]

We have a client currently using an Informix 7.2 database and they want to migrate to Oracle 9i. Using Oracle's Migration Work Bench, I have seen references to moving to Oracle 7, but not all the way to 9. Therefore:
* - can OMWB handle this migration all the way to 9i?
* - if it can't go to 9i, can it take it to 8i )we can then convert it to 9i)?
* - is OMWB the best bet or are there other means?

Thanks in advance for your responses.

[Hein van den Heuvel]

Surely the 'migration work bench' will migrate to whatever version of Oracle you currently have running.
Is Oracle not glad to assist and answer detail question as they stand to get a new customer which surely they want to welcome and make happy?!
Still hopefully there will eb a reader here chich has hand-on experience with moving the data over.

Hein.

[Scott Buckingham]

Any others care to chime in? Also, I can't seem to find any "plug-ins" necessary to run the Migration Work Bench. The link that is included in the installation instructions just take me back to the same site where I originally downloaded the software (Oracle's TechNet site). There are no plug-ins to be found!

[Duncan Edmonstone · Accepted solution]

Well the latest workbench is here:

http://otn.oracle.com/software/tech/migration/workbench/index.html

But I can't see a plug-in for IDS 7.2

There is a 7.3 plug-in, you might want to try that.

HTH

Duncan

[Scott Buckingham]

Thanks, Duncan! You don't know how many times I've searched through the TechNet site for these! I must have overlooked them here a couple times because this page sure looks familiar!

We'll give the Informix7 plug-in a try