Withdata Software

Migrate DB2 to Oracle

Shiji Pan

1 year ago

Want to migrate from DB2 to Oracle ?

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

Step by Step, just a few mouse clicks.
Create Oracle tables with auto mapping data types. Create Oracle 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 DB2 to Oracle

Login to DB2 -> Login to Oracle -> Select tables to migrate -> Migrate from DB2 to Oracle

Choose source DB2 database and logon.

Choose target Oracle database and logon.

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

then show the wizard.

1. Open source DB2.

2. Set “Import Type”.

3. Select Oracle tables to migrate.

4. Migrate from DB2 to Oracle.

Create Oracle tables. Copy DB2 data to Oracle. Create Oracle 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 DB2 to Oracle?

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

Is it safe to migrate from DB2 to Oracle using DBCopier?

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

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

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

More about DB2 to Oracle 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 DB2 to Oracle

DB2 → Oracle reference

Type mapping

Value kind	in DB2	in Oracle
Int	`INTEGER`	`NUMBER(10)`
Bigint	`BIGINT`	`NUMBER(19)`
Decimal	`DECIMAL(p,s)`	`NUMBER(p,s)`
Float	`DOUBLE`	`BINARY_DOUBLE`
Text	`VARCHAR(n)`	`VARCHAR2(n)`
Boolean	`SMALLINT`	`NUMBER(1)`

Dialect differences

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

Property	in DB2	in Oracle
port	`50000`	`1521`
row limit	`FETCH FIRST n ROWS`	`FETCH FIRST n ROWS ONLY`
dates	`DATE, TIME, TIMESTAMP`	`DATE, TIMESTAMP`
long text	`CLOB`	`CLOB, NCLOB`
binary	`BLOB`	`BLOB, BFILE`

Command line

Side	Command
DB2	`EXPORT TO out.csv OF DEL`
Oracle	`exp / expdp`
Oracle (load)	`sqlldr (SQL*Loader)`
DB2 (load)	`db2 IMPORT FROM file OF DEL`

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.