5

Database porting

Chapter 5.

After the migration planning, and software and hardware setup, the next main 

task is to migrate the source MySQL database structure onto DB2 UDB. 

In this chapter we discuss process of porting the database structure from Mysql 

4.0.1 server to DB2 UDB V8.1 server. Before doing this we need to look into the 

difference between the MySQL and DB2 UDB structure.

In the first section we discuss the data type mapping, followed by DDL 

differences. The DDL difference section provides a basic syntax difference 

between MySQL and DB2 UDB.

In the succeeding section we provide additional considerations required to keep 

in mind while porting the database schema from MySQL to DB2 UDB.

The last section provides detailed information of the database schema porting 

steps using three different approaches:

Porting using MTK

Manual porting

Metadata transform

  Copyright IBM Corp. 2004. All rights reserved.

89