From:       To:      

OraDump to PostgreSQL

[Release Notes]  [Download]  [Buy]
Latest version 5.5 released 08/07/2023

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
  • SSL connection for PostgreSQL is supported 
  • 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
  • The product can be customized according to customer requirements
  • Unlimited 24/7 support service
  • 1-year subscription for updates
    

Limitations

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 converter

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 BUY NOW link. OraDump-to-PostgreSQL is covered by 30 day money-back guarantee

OraDump-to-PostgreSQL
single user license
 $79  BUY NOW
OraDump-to-PostgreSQL
corporate license
 $199  BUY NOW
OraDump Export Kit  $149  BUY NOW