View online
More options
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.
Guides complete conversion of MySQL database and application to DB2
Enriches applications through advanced DB2 features
Converts an application with detailed examples
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
Disclaimer
These pages are Web versions of IBM Redbooks- and Redpapers-in-progress. They are published here for those who need the information now and may contain spelling, layout and grammatical errors.
This material has not been submitted to any formal IBM test and is published AS IS. It has not been the subject of rigorous review. Your feedback is welcomed to improve the usefulness of the material to others.
IBM assumes no responsibility for its accuracy or completeness. The use of this information or the implementation of any of these techniques is a customer responsibility and depends upon the customer's ability to evaluate and integrate them into the customer's operational environment.