5

Does any one have experience on migration from DB2 to MySQL ?

Please share with me.

I tried googling, but I have not received much information on this.

RolandoMySQLDBA
185k34 gold badges327 silver badges541 bronze badges
asked Mar 18, 2011 at 1:41

1 Answer 1

3

Years ago, I saw versions of MySQL available for certain operating systems. One of them had a version MySQL for IBM DB2.

http://dev.mysql.com/doc/refman/5.1/en/se-db2.html

http://www.redbooks.ibm.com/redbooks/pdfs/sg247705.pdf

http://www.docstoc.com/docs/9314480/IBM-DB2-Storage-Engine-for-MySQL--Presentation

If you install MySQL with DB2 Storage Engine, you could migrate the data you want from DB2 into MyISAM tables or InnoDB tables. Then mysqldump every MyISAM or InnoDB table to SQL Text Files.

I hope this helps !!!

UPDATE : I read the first link page. It says as of MySQL 5.1.54, that storage engine is gone. If you can get a hold of MySQL 5.1.35 - 5.1.53 for any IBM OS, you can proceed from there. At least, you can contact MySQL (eh, Oracle [I hate saying that, it just does not roll off the tongue]) and see if you can get those older binaries.

answered Mar 18, 2011 at 3:48
2
  • thanks Rolando, its a great suggestion, I will look into it, at this moment, I have decided to use MySQL migration toolkit to migrate the databases from ibm db2 to mysql Commented Mar 21, 2011 at 5:13
  • @50LV3R, can share how u use MySQL migration toolkit to migrate db2 database to mysql? Commented Nov 21, 2019 at 9:28

Your Answer

Draft saved
Draft discarded

Sign up or log in

Sign up using Google
Sign up using Email and Password

Post as a guest

Required, but never shown

Post as a guest

Required, but never shown

By clicking "Post Your Answer", you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.