Convert Online

Migration to MariaDB

IBM DB2 to MariaDB
Informix to MariaDB
Sybase ASE to MariaDB
Oracle to MariaDB
SQL Server to MariaDB

Migration to MySQL

IBM DB2 to MySQL
Informix to MySQL
Sybase ASE to MySQL
Oracle to MySQL
SQL Server to MySQL

Migration to Oracle

IBM DB2 to Oracle
Informix to Oracle
Sybase ASE to Oracle
Sybase ASA to Oracle
SQL Server to Oracle
Teradata to Oracle
PostgreSQL to Oracle
MySQL to Oracle

Migration to SQL Server

IBM DB2 to SQL Server
Informix to SQL Server
Sybase ASE to SQL Server
Sybase ASA to SQL Server
Oracle to SQL Server
MySQL to SQL Server

Migration to PostgreSQL

IBM DB2 to PostgreSQL
Informix to PostgreSQL
Sybase ASE to PostgreSQL
Sybase ASA to PostgreSQL
Oracle to PostgreSQL
SQL Server to PostgreSQL

Migration to Redshift

SQL Server to Redshift

Migration to Netezza

Oracle to Netezza

Migration to Greenplum

IBM DB2 to Greenplum
Oracle to Greenplum

Migration to EsgynDB

Oracle to EsgynDB
Teradata to EsgynDB

Application Conversion

Java
C# .NET
PowerBuilder
COBOL
Informix 4GL
Progress 4GL

SQLines Data

Overview
Command Line
Configuration File
Connection Strings
New Features

SQLines SQL Converter

New Features

Database Reference

Oracle
SQL Server
IBM DB2
MySQL
PostgreSQL
Sybase
Sybase ASA
Informix
Teradata


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