6

Data porting

Chapter 6.

This chapter informs you about the considerations concerning data porting from 

a MySQL system to a DB2 UDB system.

The usage of tools and commands supporting data dumping from MySQL and 

loading data into DB2 UDB is described, and what you should be aware of when 

using the tools.

This chapter also discusses the differences in specific data formats and data 

types and how you can convert them from MySQL to DB2.

We also describe how the user account management

(user data, access rights, 

and privileges) is implemented in MySQL, and how you can port it to database 

access information within DB2 security.

Finally, the steps for how we did the data porting in our sample project are 

discussed in detail.

  Copyright IBM Corp. 2004. All rights reserved.

127