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

SQLines SQL Converter

SQLines Data

Migration to MariaDB

Migration to Oracle

Migration to SQL Server

Migration to MySQL

Migration to PostgreSQL

Migration to IBM DB2

Migration to Redshift

Migration to Snowflake

Migration to Apache Hive

Migration to Spark

Migration to Presto/Trino

Migration to Netezza

Migration to Greenplum

Migration to EsgynDB

Application Conversion

Database Reference