Hi,

I would like if someone can help with a migration that I'm about to execute soon.
I will migrate an older Informix database to a newer ORacle 11 database and since it is my first Big migration I have some noob questions.

First of all, I would like to know if Oracle Migration Workbench really does what Oracle says and migrates smoothly an Informix database or can I expect problems within its usage?

I'm in doubt of using Orale Migration Workbench or making the migration "by hand".

This is another question I have ... If my choice goes to Migration By Hand, which steps do do you recommend. After thinking a little about it, I think that the next few steps are important:
- Export Informix schema:
- Tables
- Views
- Indexes
- Internal Funcions e Procedures
- ….
- Create scripts using PL/SQL syntax:
- Tables (Autonumber fields, have to be solved by using Triggers)
- Views
- Indexes
- Internal Funcions e Procedures
- Triggers (for autonumbers cases)
- ….
- Run the scripts and create the objects in Oracle:
- Tables
- Views
- Indexes
- Internal Funcions e Procedures
- Triggers must be created after the data migration, right?
- ….
- To import the data, I have two choices, right?:
- Export the data from Informix to flat files, and then import them to Oracle
- Create a small program in C#, by instance, that makes the export/import of the data to Oracle

I would appreciate any help, suggestions and advices on this issue.

Thanks!

Hi,

I just want to know if those steps are the correct ones. Or if I'm missing any .... or if there is someway easier ...

Anybody??