IBM DB2 9.7 MySQL to DB2 Conversion Guide

The MySQL to DB2 Conversion Guide describes how to convert MySQL databases and applications to DB2. It enriches applications through advanced DB2 features and converts an application with detailed examples.


IBM DB2 9.7 MySQL to DB2 Conversion Guide - cover page
Brand
IBM
Category
Other software
Document type
Other
Language
English
Pages
473
File format
PDF
File size
5.3 MB
Published
29 November, 2023
Updated
29 November, 2023
Model
DB2 9.7
MD5 checksum
D740C5F996D6A44DF81E4877B41A97AE

About this manual

This IBM Redbooks publication, MySQL to DB2 Conversion Guide, is a technical guide for moving a MySQL database and application to DB2. It applies to DB2 9.7 for Linux, UNIX, and Windows and to MySQL 5.1, and the second edition is dated December 2009.

The guide covers DB2 and MySQL architecture, conversion planning and assessment, a conversion scenario, installation, database and data conversion, application conversion, administration, and testing and tuning. It also includes appendices that map MySQL built-in functions and operators and provide sample code for user-defined functions.

What's inside

  • DB2 for Linux, UNIX, and Windows
  • MySQL database
  • Planning the conversion from MySQL to DB2
  • Conversion scenario
  • Installation
  • Database conversion
  • Data conversion
  • Application conversion
  • Database administration
  • Testing and tuning

Specifications

Target databaseDB2 9.7 for Linux, UNIX, and Windows
Source databaseMySQL 5.1

Frequently asked questions

What versions does this guide apply to?

It applies to DB2 9.7 for Linux, UNIX, and Windows and MySQL 5.1.

What is the document number of this IBM Redbooks guide?

The document number is SG24-7093-01.

Who are the authors listed on the cover?

The cover lists Whei-Jen Chen and Angela Carlson.

When was the second edition published?

The second edition is dated December 2009.

Download PDF (5.3 MB)

More IBM Manuals


View all IBM manuals →