Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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.

share|improve this question
up vote 3 down vote accepted

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

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.

share|improve this answer
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 – 50LV3R Mar 21 '11 at 5:13

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.