OraDump to PostgreSQL

[Release Notes]  [Download]  [Buy]
Latest version 3.5 released 06/11/2018

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

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.

Download trial version of OraDump-to-PostgreSQL

Ordering

Intelligent Converters software is distributed through downloading from our server only. For online credit card purchasing select the desired software package in the table below and click the corresponding ORDER NOW link. To learn about alternative payment options please visit Payment Options page. OraDump-to-PostgreSQL is covered by 30 day money-back guarantee

 

OraDump-to-PostgreSQL (single user license)
Click here for more information about licensing
$79 ORDER NOW
OraDump Export Kit
software pack to export data from Oracle dump file into
the most popular formats
$149 ORDER NOW