IBM DB2 to MySQL Migration

SQLines provides services to help you transfer data, convert database schema (DDL), views, stored procedures, functions, triggers, queries and SQL scripts from IBM DB2 to MySQL.

We also help convert embedded SQL statements in C/C++ (ODBC, ESQL/C), C#, Java, PowerBuilder, VB/VB.NET, ASP/ASP.NET, Perl, PHP, Python, Linux shell and other applications. SQLines can also assist you to convert COBOL stored procedures and programs to MySQL procedural SQL, Java, Python or any other language.

Databases:

  • IBM DB2 for LUW, z/OS and OS/400 11.x, 10.x, 9.x, 8.x and 7.x
  • MySQL 8.x, 6.x, 5.x

IBM DB2 to MySQL Migration Reference

Technical information on migration from IBM DB2 to MySQL:

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