Sync data from Oracle to PostgreSQL

by

Want to sync data from Oracle to PostgreSQL ?

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

Download Withdata DBCopier Download DBCopier

Synchronize data from Oracle to PostgreSQL

Login to Oracle and target PostgreSQL -> Select source Oracle tables -> Set target PostgreSQL tables -> Sync Oracle data to PostgreSQL

Choose source Oracle database and logon.

sync Oracle to PostgreSQL - Choose Oracle and logon

Choose target PostgreSQL database and logon.

sync Oracle to PostgreSQL - Choose PostgreSQL and logon

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

sync from Oracle to PostgreSQL - Task Window

then show the wizard.

1. Select source Oracle tables to sync.

sync from Oracle to PostgreSQL - Open source database

2. List target PostgreSQL tables.

Set “Import Type” to “Replace”, it will do a full synchronization.

sync data from Oracle to PostgreSQL - full synchronization

Or set “Import Type” to “Upsert”, it will do a upsert synchronization.

sync data from Oracle to PostgreSQL - upsert synchronization

3. Select PostgreSQL tables to sync.

sync from Oracle to PostgreSQL - select tables

4. Sync Oracle data to PostgreSQL.

sync from Oracle to PostgreSQL - sync


More about Oracle to PostgreSQL converter

See also: