1

I want to migrate Database from mysql to Db2.

I need to do it using CLP and also without any tool. Can anyone help.

Thanks in advance.

Improve this question

1 Answer 1

Reset to default
3

You can use the IBM Data Movement Tool.

Follow the directions in this article.

If you really want to do it without the tool (I don't recommend this) then at a minimum you'll need to:

  • create storage in db2 (databases, tablespaces, etc.) that match your mysql database
  • look at your tables and translate any column types from their mysql types to DB2 types
  • make sure you recreate any indexes, key contraints, triggers
  • translate any other stored procedures and other database objects

This article has some information on data mapping to mysql.

Improve this answer
Sign up to request clarification or add additional context in comments.

Comments

Your Answer

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.