OraDump to PostgreSQL
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.
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.
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.
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.
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.
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
single user license
|OraDump Export Kit