convert oracle dump to PostgreSQL, oracle to PostgreSQL converter, migrate oracle to PostgreSQL, ora2sql, oracle2PostgreSQL, command line, automate conversion, free download, shareware
FAQ  |  Site map  |  Contact Us
About Us How to Buy Products Discounts Migration Service Support Become a Partner Articles

OraDump to PostgreSQL


Latest version 2.5 released 06/20/2016

OraDump-to-PostgreSQL is a program to migrate data from Oracle export (dmp) files into PostgreSQL database. The program does direct reading from dmp files, so Orace environment and 3rd party tools are not required. Command line support allows to script and schedule the migration.

Features

  • OraDump to PostgreSQL converter works with all versions of Oracle export (dmp) files created by EXP or EXPDP tools
  • The program works with all versions PostgreSQL running on Linux, Unix and Windows platforms
  • Encrypted dump files are supported
  • Parallel export Oracle dump files are supported
  • Option to merge Oracle data into an existing PostgreSQL database
  • Option to convert individual tables
  • Converts indexes with all necessary attributes
  • Stores conversion settings into profile
  • Command line support
  • Easy-to-use wizard-style interface
  • Full install/uninstall support
  • Unlimited 24/7 support service
  • 1-year subscription for updates

Limitations

  • Does not support compessed dump files
  • Does not convert foreign keys
  • Does not convert views
  • Does not convert stored procedures
  • Does not convert columns having user-defined types
  • Demo version converts only 50 records per table
    

Requirements

  • PostgreSQL environment (server or client components of PostgreSQL must be installed on the same machine where you run OraDump-to-PostgreSQL from)
  • Necessary privileges to write into the destination database
  • Supported OS: Windows XP(SP2 or SP3)/2003/Vista/Server 2008/7/8/10

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 OraDump to PostgreSQL converter 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 demo version and come back to purchase the full one if satisfied with the results.

Download trial version of OraDump-to-PostgreSQL

 

OraDump-to-PostgreSQL
order single product
$79 ORDER NOW
OraDump Export Kit
software pack to export data from Oracle dump file into
the most popular formats
$149 ORDER NOW