Fastest way from Informix 11 to Oracle 11
880947Aug 8 2011 — edited Aug 22 2011Hello,
I need to know the fastest way to migrate an Informix 11 DB to an Oracle 11 DB. Tools like ESF Database Migration Toolkit are very nice but, by using the ODBC Driver it will be slower than importing a dumpfile.
Actualy I use the way, creating a dumpfile with inserts, correct some signproblems, like ' and " and then I import it.
I tried to find out if Oracles Data Pump Import could be use an export which is generated from Informix, but I got no result yet.
Can anyone show me a way to migrate an Informix 11 DB to an Oracle 11 DB on the fly, who is faster then the ESF migration via ODBC or automatic dumpfile export/correction/import?
greetz René