IBM DB2 to MySQL Migration Reference and Tools

Technical information on migration from IBM DB2 to MySQL.

Last Update: IBM DB2 10.1 and MySQL 5.6

IBM DB2 to MySQL Migration Tools

Data Types

Converting data types:

DB2 MySQL
CHAR Fixed-length character string CHAR
DATE Date (year, month and day) DATE
INT, INTEGER 32-bit integer INT, INTEGER
SMALLINT 16-bit integer SMALLINT
TIMESTAMP Date and time DATETIME
VARCHAR Variable-length character string VARCHAR

Built-in SQL Functions

Converting functions:

DB2 MySQL
1 CURRENT DATE CURRENT_DATE Get current date CURRENT_DATE

Queries

Converting SQL SELECT statement:

DB2 MySQL
SYSIBM.SYSDUMMY1 table A single row, single column dummy table FROM clause removed

SQL Statements

Converting SQL statements:

DB2 MySQL
VALUES expression Construct a result set SELECT expression