This guide presents the best practices in migration strategy and planning, migration tools, and practical migration examples. It is intended for technical staff involved in a MySQL to DB2 UDB conversion project.

This redbook also provides step-by-step instructions for installing and using the IBM DB2 Migration Toolkit (MTK) to port the database objects and data from MySQL to DB2 UDB.

Application programming and conversion considerations are discussed along with the differences in features and functionality of MySQL and DB2 UDB.

Examples are used throughout the book to illustrate conversions of database access, database administration, SQL statements (DDL, DML) and others, as well as testing and tuning your DB2 UDB system.