Skip to main content

MySQL to DB2 Conversion Guide

An IBM Redbooks publication

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


Published on 02 December 2009

  1. .EPUB (4.1 MB)
  2. .PDF (5.0 MB)

Google Play Books

Share this page:   

ISBN-10: 0738433659
ISBN-13: 9780738433653
IBM Form #: SG24-7093-01

Authors: Whei-Jen Chen and Angela Carlson

    menu icon


    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