OraDump-to-PostgreSQL is a program to export data from Oracle dump files into PostgreSQL database. The program does direct reading from the dump, so Oracle installation is not required. Command line support allows to script, automate and schedule the conversion process.

Features All versions of Oracle dump files are supported (both EXP and EXPDP) All versions of Linux/Unix and Windows PostgreSQL are supported Encrypted dump files are supported Converts parallel export Oracle dump files Option to merge Oracle data into an existing PostgreSQL database Option to synchronize PostgreSQL database with Oracle data  Option to convert individual tables Option to export into PostgreSQL script file Converts indexes with all necessary attributes Stores conversion settings into profile Command line support Easy-to-use wizard-style interface Full install/uninstall support The product can be customized according to customer requirements Unlimited 24/7 support service 1-year subscription for updates Limitations Does not support compressed dump files Does not convert views, stored procedures and triggers Does not convert columns having user-defined types Demo version converts only 50 records per table and does not convert foreign keys

Requirements

• Supported OS: Windows XP(SP2 or SP3)/Vista/7/8/10, Server 2003/2008/2012/2016, Linux with WINE
• Necessary privileges to write into the destination database

Synchronization

OraDump-to-PostgreSQL implements synchronization as combination of insert Oracle records that are missing in PostgreSQL table and update existing PostgreSQL records with Oracle data. For synchronization purpose source and destination tables must have identical structures and primary key or unique index defined.

PostgreSQL script file

Oracle to PostgreSQL converter allows users to migrate Oracle database into PostgreSQL format even when there is no direct connection to the destination server. Following this approach, the program exports Oracle data into a local PostgreSQL script file instead of transferring it to database server directly. The output file contains SQL statements defining all tables and inserting the data. This article explains how to import script files into PostgreSQL database.

How to process parallel export Oracle dump files

To speed up exporting data into dump Oracle allows export operation to be executed by multiple threads that are working at the same time. Each thread generates output in its own file, so the result of the parallel export job is a set of files. OraDump-to-PostgreSQL can extract data from the first file of that set only. To read the entire data it is necessary to merge all file of parallel export into one with ormerge.exe tool that can be found in the installation folder. It is a console utility that accepts the following arguments:

ordmerge.exe <dumpfile#1> <dumpfile#2> ... <dumpfile#N> <resulting file>

Then OraDump-to-PostgreSQL should be run against the resulting file.

Try before you buy

Still not sure the program fits your needs? Try free demo version with limited features. It will allow you to convert only 50 records for each database table. Test the quality of the demo and come back to place an order if satisfied with the results.