Data Migration from Informix database to oracle database

Asked By garfieldc14 200 points N/A Posted on - 07/22/2011

Hi experts,

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.

Thanks.

• Status: Open
• Question Views: 2592
• Answer Count: 1
• Vote Up 20 Vote Down

• Answer Accepted: No
• Question Category: Informix

Answered By shethkushal 5 points N/A #84924

Data Migration from Informix database to oracle database

Here is the answer:

1. Download Oracle Migration Workbench from here.

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.

About shethkushal

Questions
0

Answers
9

Best Answers
0

• Vote Up 0 Vote Down

• Posted on - 07/28/2011
• Question Category: Informix