IBM DB2
MySQL

IBM DB2 to MySQL Converter

DB2 tables, keys and rows into MySQL, with saved jobs you can run again.

Version
5.8.0
Release Date
Nov. 8, 2026
Size
46.4 MB
Platform
Windows 10 or later
Download DBConvert Order from US$ 199

Rather not run it yourself?

Let us do the migration →

Move an IBM DB2 database into MySQL. DBConvert creates the MySQL tables, keys and indexes, picks a type for every DB2 column, and copies the rows server to server.

  • Reads DB2 for Linux, UNIX and Windows 11.1 and later.
  • Writes to MySQL, MariaDB, Percona Server, Amazon RDS or Aurora, Azure Database for MySQL, or Google Cloud SQL.
  • Reaches a DB2 server through the built-in SSH tunnel.
  • Runs on Windows as a desktop application.
  • The same download converts MySQL into DB2.

Large DB2 tables, read in parallel

A large table is split into ranges of its key and read on several threads at once. Every row is read once, without paging through the table. Keys of SMALLINT, INTEGER, BIGINT and VARCHAR are split.

How DB2 types map to MySQL

These are the defaults. Change any column's type on the Tables step before a row moves.

Scroll sideways to see all columns.

In DB2 In MySQL
SMALLINT, INTEGER, BIGINT, BOOLEAN The same integer types. BOOLEAN becomes TINYINT(1).
DECIMAL, DECFLOAT DECIMAL keeps its precision. DECFLOAT arrives as text, every digit kept.
TIMESTAMP DATETIME with up to 6 fraction digits. Not MySQL TIMESTAMP, which stops at 2038.
VARCHAR, CLOB, XML VARCHAR up to 4,000 characters, MEDIUMTEXT beyond. CLOB and XML become LONGTEXT.
BLOB, VARBINARY VARBINARY or LONGBLOB, byte for byte.

What stays behind

DBConvert moves tables, columns, keys, indexes, foreign keys, defaults and rows. Views, procedures, functions and triggers are not converted: rewrite them by hand for the new database.

DB2 means DB2 for Linux, UNIX and Windows 11.1 or later. DB2 for z/OS and IBM i (AS/400) are not supported.

Supported versions and services

IBM DB2

  • IBM DB2 for Linux, UNIX and Windows 11.1 and later
  • Setup downloads the IBM Data Server Driver for ODBC and CLI from IBM. Installing offline

MySQL

  • MySQL 5.x, 8.x; MariaDB; Percona Server
  • Amazon RDS / Aurora MySQL, Azure Database for MySQL, Google Cloud SQL
IBM DB2

All IBM DB2 Tools

Other directions and pairs
MySQL

All MySQL Tools

Migration & sync options

Reverse Conversion

MySQL to IBM DB2

DBConvert Studio

30+ databases · cloud · scheduled sync

Need more database pairs? One tool covers 30+ databases.

How to migrate IBM DB2 to MySQL

1

Setup: connect IBM DB2 and MySQL

Choose the source and destination connections side by side on one screen. A connection is saved once and reused by every job.

DB2 source

Enter the host, port (50000 by default), database name, user and password. Leave the schema empty for the login's own. See Connect IBM DB2.

MySQL target

Follow the MySQL connection guide for MySQL, MariaDB / Percona, RDS / Aurora, or Google Cloud SQL.

Verify the copy

With Verify after the run on, the destination is checked when the copy ends: schema, totals and rows. The window shows which tables, rows and columns differ.

How Verify works

Steps 2-3: the same for every database pair

See all features

More guides for IBM DB2 ↔ MySQL

Move IBM DB2 data into MySQL

Download the current build and run the first job against your own database.

Download DBConvert 5.8.0 Order from US$ 199

Windows Windows 10 or later · 46.4 MB