Batch copy Oracle tables to PostgreSQL

by

Posted on by

Want to batch copy data from Oracle tables to PostgreSQL ?

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

Download Withdata DBCopier Download DBCopier

Batch copy data from Oracle tables to PostgreSQL tables

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

Choose source Oracle database and logon.

convert Oracle data to PostgreSQL data - Choose Oracle and logon

Choose target PostgreSQL database and logon.

convert Oracle data to PostgreSQL data - Choose PostgreSQL and logon

Click “Convert All Tables” at task dialog.

Batch import data from Oracle tables to PostgreSQL tables - Task Window

then show the wizard.

1. Select source Oracle tables.

Batch convert data from Oracle tables to PostgreSQL tables - Open Source schema

2. List target PostgreSQL tables.

Batch extract data from Oracle tables to PostgreSQL tables - select destination schema

3. Select PostgreSQL tables to import.

Batch import data from Oracle tables to PostgreSQL tables - select tables

4. Transfer data from Oracle tables to PostgreSQL.

Batch copy data from Oracle tables to PostgreSQL tables - batch import

Batch transfer data from Oracle tables to PostgreSQL in command line

Save “Oracle tables to PostgreSQL” session, then you can:

Set scheduled tasks for coping data from Oracle tables to PostgreSQL

You can schedule and automate this “Oracle to PostgreSQL” conversion task by:

  1. Save session and create .bat (Windows) or .sh (Linux/macOS) file for “Oracle to PostgreSQL” conversion.
  2. Set scheduled task for “Oracle to PostgreSQL” conversion.

FAQ

More about Withdata DBCopier – Oracle to PostgreSQL Converter

See also: