MySQL to DB2 Conversion Guide

An IBM Redbooks publication

Note: This is publication is now archived. For reference only.

Published 01 December 2009

cover image

ISBN-10: 0738433659
ISBN-13: 9780738433653
IBM Form #: SG24-7093-01
(476 pages)

More options

Rate and comment

Authors: Whei-Jen Chen, Angela Carlson

Abstract

Switching database vendors is often considered an exhausting challenge for database administrators and developers. Complexity, total cost, and the risk of downtime are often the reasons that restrain IT decision makers from starting the migration project. The primary goal of this book is to show that, with the proper planning and guidance, converting from MySQL to IBM® DB2® is not only feasible but straightforward.

If you picked up this book, you are most likely considering converting to DB2 and are probably aware of several of the advantages of to converting to DB2 data server. In this IBM Redbooks® publication, we discuss in detail how you can take advantage of this industry leading database server.

This book is an informative guide that describes how to convert the database system from MySQL™ 5.1 to DB2® V9.7 on Linux® and the steps that are involved in enabling the applications to use DB2 instead of MySQL.

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

Table of contents

Chapter 1. DB2 for Linux, UNIX, and Windows
Chapter 2. MySQL database
Chapter 3. Planning the conversion from MySQL to DB2
Chapter 4. Conversion scenario
Chapter 5. Installation
Chapter 6. Database conversion
Chapter 7. Data conversion
Chapter 8. Application conversion
Chapter 9. Database administration
Chapter 10. Testing and tuning
Chapter 11. Advanced DB2 features
Appendix A. Mapping MySQL built-in functions and operators
Appendix B. Sample code for user-defined functions

Follow IBM Redbooks

Follow IBM Redbooks