Withdata Software

Migrate SQL Server to DB2

Shiji Pan

1 year ago

Want to migrate from SQL Server to DB2 ?

Try Withdata DBCopier, a SQL Server to DB2 converter for Windows, Mac, and Linux, Migrate SQL Server to DB2, Easy and Fast.

Step by Step, just a few mouse clicks.
Create DB2 tables with auto mapping data types. Create DB2 indexes.

Download Withdata DBCopier
Windows 64 bit
Windows 32 bit
Linux .deb (For Debian, Ubuntu) 64 bit
Linux .rpm (For Red Hat, Fedora, SUSE) 64 bit
MacOS 64 bit

Migrate from SQL Server to DB2

Login to SQL Server -> Login to DB2 -> Select tables to migrate -> Migrate from SQL Server to DB2

Choose source SQL Server database and logon.

Choose target DB2 database and logon.

Click “Wizard – Import All Tables” at task dialog.

then show the wizard.

1. Open source SQL Server.

2. Set “Import Type”.

3. Select DB2 tables to migrate.

4. Migrate from SQL Server to DB2.

Create DB2 tables. Copy SQL Server data to DB2. Create DB2 indexes.

FAQ

What is Withdata DBCopier?

Withdata DBCopier is an on-premise data conversion software that helps you to copy data between databases. Download Withdata DBCopier

How long does it take to migrate from SQL Server to DB2?

DBCopier works fast. It convert millions of rows within a minute.

Is it safe to migrate from SQL Server to DB2 using DBCopier?

Of course! DBCopier migrate from SQL Server to DB2 locally, absolutely safe.

Can I migrate from SQL Server to DB2 on Linux, Mac OS?

Yes, you can. DBCopier has Linux, Mac OS, and Windows version.

More about SQL Server to DB2 converter

Download Withdata DBCopier
Windows 64 bit
Windows 32 bit
Linux .deb (For Debian, Ubuntu) 64 bit
Linux .rpm (For Red Hat, Fedora, SUSE) 64 bit
MacOS 64 bit

See also:

Sync data from SQL Server to DB2

SQL Server → DB2 reference

Type mapping

Value kind	in SQL Server	in DB2
Int	`int`	`INTEGER`
Bigint	`bigint`	`BIGINT`
Decimal	`decimal(p,s)`	`DECIMAL(p,s)`
Float	`float`	`DOUBLE`
Text	`nvarchar(n)`	`VARCHAR(n)`
Long text	`nvarchar(max)`	`CLOB`
Date	`date`	`DATE`
Datetime	`datetime2`	`TIMESTAMP`
Binary	`varbinary(max)`	`BLOB`
Boolean	`bit`	`SMALLINT`

Dialect differences

Both SQL Server and DB2 are database servers, so the differences below are dialect-level: the same concept is spelled differently on each side.

Property	in SQL Server	in DB2
port	`1433`	`50000`
identifiers	`[square brackets]`	`"double quotes"`
row limit	`SELECT TOP n`	`FETCH FIRST n ROWS`
dates	`datetime, datetime2, date, time`	`DATE, TIME, TIMESTAMP`
long text	`nvarchar(max)`	`CLOB`
binary	`varbinary(max)`	`BLOB`

Command line

Side	Command
SQL Server	`bcp`
DB2	`EXPORT TO out.csv OF DEL`
DB2 (load)	`db2 IMPORT FROM file OF DEL`
SQL Server (load)	`bcp, or BULK INSERT`

Convert your data online, free

Free in-browser converters for CSV, Excel, JSON, XML and SQL: Withdata Online Data Conversion. Large files, batch conversion or scheduling? See the offline desktop apps, or browse all data conversion tools.