MySQL

database

MySQL 

DDL

Export DDL

script

(mysqldump/MTK)

DB2

DDL

Convert DDL

script

(MTK)

DB2 

Create database

run DB2 DDL

database

(MTK)

Figure 2 3   Database structure porting process

Export DDL from MySQL databases

You have to retrieve the information about tables, keys, and indexes from your 

source MySQL database.

Tools like MTK can do most parts of this task automatically. You should check 

the results of the output of the tool you use. Of course you can also do this step 

manually, but be aware to cover all the database objects.

Convert DDL to DB2 syntax

As the DDL used by MySQL is a little different from the DDL used by DB2 UDB, 

the DDL used to create MySQL database and objects have to be converted to 

DB2 UDB syntax.

This part is also supported by tools like MTK; again, you can do it manually. In 

this case be aware of the different data types that MySQL and DB2 UDB use.

If you plan to change the logical model of your database structure to enhance 

your application and take advantage of the DB2 UDB's functions and features, 

the DDL should be modified in this step.

56 

MySQL to DB2 UDB Conversion Guide