Migrate SQLite to PostgreSQL

by

Posted on by

Want to migrate from SQLite to PostgreSQL ?

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

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

Download Withdata DBCopier Download DBCopier

Migrate from SQLite to PostgreSQL

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

Choose source SQLite database and logon.

Migrate SQLite to PostgreSQL - Choose SQLite and logon

Choose target PostgreSQL database and logon.

Migrate SQLite to PostgreSQL - Choose PostgreSQL and logon

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

migrate from SQLite to PostgreSQL - Task Window

then show the wizard.

1. Open source SQLite.

Switch from SQLite to PostgreSQL - Open source database

2. List target PostgreSQL tables.

Migrate from SQLite to PostgreSQL - list target tables

3. Select PostgreSQL tables to migrate.

Switch from SQLite to PostgreSQL - select tables

4. Migrate from SQLite to PostgreSQL.

Create PostgreSQL tables. Copy SQLite data to PostgreSQL. Create PostgreSQL indexes.

Switch from SQLite to PostgreSQL - migrate

FAQ

More about Withdata DBCopier – SQLite to PostgreSQL Converter

See also: