1

Introduction

Chapter 1.

In recent years the popularity of the MySQL relational database management 

system (RDMS) has soared due to its close association with the Linux, Apache, 

and PHP projects (LAMP). These open source projects have mutually benefited 

from the need to develop scriptable database driven Web applications. The 

Apache PHP module allows the program logic of a Web application to access a 

MySQL backend database and render dynamic Web content. An organization 

that has deployed MySQL may find that due to its limited features there is a need 

to migrate to a more robust RDMS such as the IBM DB2 UDB. In this redbook we 

describe in detail how such a migration to IBM DB2 UDB can be accomplished in 

a facile manner.

Switching database platforms from one to another however is often a big 

challenge for database administrator and developer. Complexity, total cost, and 

the risk of downtime are reasons that often restrain IT decision makers to start 

such a project. The primary goal of this book therefore is to show that migration 

from MySQL to DB2 is feasible, and to provide help in planning and 

implementing data migration from MySQL to DB2 UDB. This migration guide 

refers to the last general available versions of MySQL and DB2 UDB, which is 

MySQL 4.0 and DB2 UDB 8.1.

Confronted with this demand, a certain level of knowledge in both environments 

is required to start with the migration process.

  Copyright IBM Corp. 2004. All rights reserved.

1