The tool will then parse this myqsldump file to make it DB2 UDB compatible. 

This new file will also be stored in the current directory with the name 

.db2.create.

The tool will then create the structure of the database in DB2 UDB by using 

this parsed file.

A log of all DB2 UDB commands with associated output is stored in a file in 

the current directory by the name 

.db2.log.. Examine

 this log 

for any errors that might occur. 

When database conversion is finished, you can migrate your data, 

applications and other components which uses DB2 UDB. It is very important 

that you verify the migrated data after running the tool. 

There are a few limitation in the current version of MTK

MTK does not support the conversion of BLOB data type, so manual 

conversion is required for this.

MTK may not work properly for a timestamp because of different date time 

formats, so manual conversion is required for this.

MTK may not work properly for very complex databases. So extra care has to 

be taken while converting very complex databases.

Data type mapping in MTK are fixed and cannot be changed, so manual 

change in script is required if you want to change the mapping.

Other migration tools

There are other migration tools which can be used to port MySQL database to 

DB2 UDB. 

SQLWays

SQLWays 3.6 is an advanced migration tool from Ispirer Systems Ltd. that 

ensures quick and easy transfer of database structures and data from MySQL 

to DB2 UDB

. 

SQLWays runs only on Microsoft Windows 9x/NT/2000/XP

SqlPorter

The SQLPorter Migration Toolkit is a tool from RealSoftStudio Inc. that 

simplifies the process of migrating data and databases across different 

databases on different platforms. The SQLPorter Migration Toolkit allows you 

to migrate an entire database (data and schema) in an integrated, visual 

environment. The SQLPorter Migration Toolkit employs an intuitive user 

interface and a series of wizards to simplify the migration process. All 

components of the Migration Workbench are written in C++. It is supported 

both on Windows and Linux system. 

 Chapter 5. Database porting 

113