Withdata Software

Migrate DB2 to SQLite

Shiji Pan

1 year ago

Want to migrate from DB2 to SQLite ?

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

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

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

Choose source DB2 database and logon.

Choose / create target SQLite 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 SQLite tables to migrate.

4. Migrate from DB2 to SQLite.

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

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

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

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

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

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

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

DB2 → SQLite reference

Type mapping

Value kind	in DB2	in SQLite
Bigint	`BIGINT`	`INTEGER`
Decimal	`DECIMAL(p,s)`	`NUMERIC`
Float	`DOUBLE`	`REAL`
Text	`VARCHAR(n)`	`TEXT`
Long text	`CLOB`	`TEXT`
Date	`DATE`	`TEXT`
Datetime	`TIMESTAMP`	`TEXT`
Boolean	`SMALLINT`	`INTEGER`

Dialect differences

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

Property	in DB2	in SQLite
port	`50000`	`(file-based)`
identifiers	`"double quotes"`	`"double quotes" or [brackets]`
row limit	`FETCH FIRST n ROWS`	`LIMIT n`
dates	`DATE, TIME, TIMESTAMP`	`TEXT (no date type)`
long text	`CLOB`	`TEXT`

Command line

Side	Command
DB2	`EXPORT TO out.csv OF DEL`
SQLite	`sqlite3 .dump`
SQLite (load)	`.import (sqlite3)`
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.