SQL Server to IBM DB2 Converter

Tables, keys and rows into DB2, once or as a sync, with saved jobs you can run again.

Version: 5.7.0
Release Date: Nov. 4, 2026
Size: 48.4 MB
Platform: Windows 10 or later

Rather not run it yourself?

Let us do the migration →

Move a SQL Server database into IBM DB2 without writing the DB2 schema by hand. DBConvert creates the tables, keys and indexes, picks a DB2 type for every column, and copies the rows server to server.

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

Convert once, or keep DB2 in step

Conversion

Creates the DB2 tables and loads the rows. Rows go in large batches. A row DB2 refuses is named in the log with the server's reason, and the rest of its batch still arrives.

Synchronization into DB2

Carries inserts, updates and deletes from SQL Server into DB2 each time the job runs. It works in one direction: DB2 is never the source of a sync. How sync works

How SQL Server types map to DB2

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

In SQL Server	In DB2
`tinyint`, `smallint`, `bit`, `int`	`SMALLINT` for the first three, `INTEGER` for `int`, `BIGINT` for `bigint`.
`decimal`, `numeric`, `money`	`DECIMAL` up to 31 digits. Wider ones become `DECFLOAT(34)`, which holds 34 digits exactly. `money` becomes `DECIMAL(19,4)`.
`datetime`, `datetime2`, `datetimeoffset`	`TIMESTAMP(n)` with the same fraction digits. A `datetimeoffset` arrives as its UTC instant.
`time`	`TIME`. DB2 keeps whole seconds, so a time with a fraction is refused and named in the log, never cut.
`varchar`, `char`, `nvarchar`, `nchar`	`VARCHAR` and `CHAR`, sized in characters. `nvarchar` and `nchar` become `VARGRAPHIC` and `GRAPHIC`. `(max)` and `text` become `CLOB`.
`varbinary`, `image`, `uniqueidentifier`	`VARBINARY` or `BLOB`, byte for byte. `uniqueidentifier` becomes `CHAR(36)`.
Identity, defaults	An identity column keeps its values and the next insert continues after them. Defaults arrive exactly, quotes included.

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

SQL Server

SQL Server 2008-2022, including Express editions
Azure SQL Database and Amazon RDS for SQL Server
SQL Server schemas (dbo, custom schemas)
Windows authentication or SQL authentication

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

DBConvert Studio

30+ databases · cloud · scheduled sync

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

How to migrate SQL Server to IBM DB2

Setup: connect SQL Server and IBM DB2

Pick Convert or Sync, then choose the source and destination connections side by side on one screen. A connection is saved once and reused by every job.

SQL Server source

Connect by TCP/IP or Named Pipes, use Azure SQL, or read from Amazon RDS for SQL Server.

DB2 target

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

Steps 2-3: the same for every database pair

Open the full guide

See all features

More guides for SQL Server ↔ IBM DB2

Move SQL Server data into IBM DB2

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

Download DBConvert 5.7.0 Order from US$ 199

Windows 10 or later · 48.4 MB