Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2003
    Posts
    76

    Unanswered: Data Migration from Informix to Oracle 11

    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!

  2. #2
    Join Date
    Dec 2003
    Posts
    76

    Anybody??

    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??

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •