Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2003
    midwest USA

    Unanswered: Converting from Informix

    We need to move our unix-based informix apps. to another database platform and can't decide on DB2 UDB or Oracle. We haven't found anyone who has converted IFMX to DB2 UDB. Anyone out there that has converted IFMX to O?

  2. #2
    Join Date
    Jul 2003
    I have.

    This was done by converting informix into flatfiles and then using sqlloader to load into Oracle.

    There is most likely an easier way than this I would assume.

    We redesigned the whole db, so loading the flatfiles into temp-tables and then writing conversion-load scripts seemed the best way to go.

    We also had someone write an interesting Perl script which pre-wrote all the sqlloader ctl files and all the table creation scripts. It was pretty interesting.
    - The_Duck
    you can lead someone to something but they will never learn anything ...

Posting Permissions

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