N/APosted on - 07/22/2011
I would like someone to help me with migration that I must execute soon. I will migrate an older Informix database to a newer Oracle 11g database. This is my first big migration experience and I have some questions.
First, I would like to know if Oracle Migration workbench already does what Oracle says and migrates easily or should I expect problems with its usage? My second question is, if I must do the migration manually, which steps do you recommend? I really need any help, suggestions and advice on this issue.
Data Migration from Informix database to oracle database
Here is the answer:
1. Download Oracle Migration Workbench from http://www.oracle.com/technetwork/topics/index-095746.html
2. Perform migration of tables.
3. Select the Generate SQL Loader scripts… after clicking on the tables folder in the Oracle Model UI Tab. This will generate Informix Unload scripts and the equivalent Oracle SQL Loader scripts. This is the best way to migrate large amounts of data.
There is also a user guide available on the official site and also you should be able to use the Oracle Migration Workbench for that. As you have a reasonable amount of data, you should review the workbench documentation and consider using the offline data migration feature.