Migrate Oracle database to Informix database

Posted in 2021

Topics: Migration, Import/Export & Data Conversion

MOHD FADZIL JUSOH — source: IBM Community (ConnectedCommunity.org) Informix forum

Hi, Please help to suggest any migration tools that support to migration oracle database to informix database. Currently we only prepared SQL script to unload from oracle database & load to informix database, but have issue with datatype clob/blob. Please advice. Thank You ------------------------------ MOHD FADZIL JUSOH ------------------------------ #Informix

↪ replying to MOHD FADZIL JUSOH

Hrvoje Zokovic — source: IBM Community (ConnectedCommunity.org) Informix forum

Once upon a time, in a land far, far away, there was a beautiful utility (mtk) who had become lost. Mtk is short for migration toolkit and it was made by IBM There's still manual for that: ftp://ftp.software.ibm.com/software/data/db2/migration/mtk/mtk_2050.pdf Also, there is some tool (I never used it) here https://github.com/IBM/idmt HTH Hrvoje ------------------------------ Hrvoje Zokovic ------------------------------

↪ replying to MOHD FADZIL JUSOH

Andreas Legner — source: IBM Community (ConnectedCommunity.org) Informix forum

What precise issue? ------------------------------ Andreas Legner ------------------------------