OraDump to PostgreSQL

Developer’s Description

OraDump to PostgreSQL

By Intelligent Converters
OraDump-to-PostgreSQL is a program to convert Oracle dump files into PostgreSQL database. Depending on your privileges on the target PostgreSQL server you can export Oracle data into new database or overwrite the contents of existing PostgreSQL database

OraDump-to-PostgreSQL 4.1

migrate Oracle dump files to PostgreSQLOraDump-to-PostgreSQL is a program to convert Oracle dump files into PostgreSQL database. All Oracle data types (except BFILE and MLSLABEL) and attributes are supported. The program has easy-to-use wizard style interface and works with all versions of PostgreSQL server.

OraDump-to-PostgreSQL for Windows 10 – Full description

OraDump-to-PostgreSQL is a program to convert Oracle dump files into PostgreSQL database. Key features: (1) all versions of Oracle dump files are supported; (2) all versions of Windows and Unix/Linux PostgreSQL are supported; (3) converts multi-file Oracle dump files; (4) converts indexes with all necessary attributes; (5) option to convert individual tables; (6) option to merge Oracle data into an existing PostgreSQL database; (7) stores conversion settings into profile; (8) command line support; (9) easy-to-use wizard style interface

OraDump-to-PostgreSQL is a program to convert Oracle dump files into PostgreSQL database. Key features:
(1) all versions of Oracle dump files are supported;
(2) all versions of Windows and Unix/Linux PostgreSQL are supported;
(3) converts multi-file Oracle dump files;
(4) converts indexes with all necessary attributes;
(5) option to convert individual tables;
(6) option to merge Oracle data into an existing PostgreSQL database;
(7) stores conversion settings into profile;
(8) command line support;
(9) easy-to-use wizard style interface

Overview

OraDump-to-PostgreSQL is a Shareware software in the category Business developed by Intelligent Converters.

The latest version of OraDump-to-PostgreSQL is 4.1, released on 04/02/2020. It was initially added to our database on 07/14/2017.

OraDump-to-PostgreSQL runs on the following operating systems: Windows. The download file has a size of 2.3MB.

OraDump-to-PostgreSQL has not been rated by our users yet.

With your support, you can help all other users keep their software setup up-to-date. Fill out any fields that are incorrect or not up to date. We will check and evaluate your contribution as soon as possible.

OraDump-to-PostgreSQL is a program to convert Oracle dump files into PostgreSQL database. Key features: (1) all versions of Oracle dump files are supported; (2) all versions of Windows and Unix/Linux PostgreSQL are supported; (3) converts multi-file Oracle dump files; (4) converts indexes with all necessary attributes; (5) option to convert individual tables; (6) option to merge Oracle data into an existing PostgreSQL database; (7) stores conversion settings into profile; (8) command line support; (9) easy-to-use wizard style interface

Migrate Oracle dump files to PostgreSQL databases using a wizard that guides you every step of the way, overwrite entire databases or existing tables only

OraDump to PostgreSQL

3.5/5

Review by Elena Opris on April 20, 2017

What’s new in OraDump to PostgreSQL 5.1.0.1:

  • Improved migration of spatial data for EXPDP dump files
  • SSL connection for PostgreSQL is supported
  • Verified support for Azure PostgreSQL

READ THE FULL CHANGELOG

With the help of OraDump to PostgreSQL, you can quickly convert dump files from Oracle format to PostgreSQL databases. It facilitates a wizard interface that guides you every step of the way, making it accessible to all types of users, even those less experienced with database migration software.

Easily migrate dump files from Oracle to PostgreSQL

Installing the tool shouldn’t be an issue since there are no special options involved. At startup, you’re greeted by the wizard, where you can get started by connecting to a PostgreSQL server by specifying the access mode (local, remote), authorization settings (username, password) and remote settings (host, port).

Next, you can indicate the file path to the Oracle dump you wish to convert, along with the PostgreSQL database name and log file (it can be left blank to disable logging). Furthermore, you can ask the tool to convert only table definitions, skip index conversion, make name cases sensitive, as well as to merge schema and table names.

Easily configure options and switch to console mode

The application offers support for all Oracle data types and attributes, aside from BFILE and MLSLABEL. Command lines are available for users who prefer the console to the graphical interface and who wish to build scripts and schedule tasks.

OraDump to PostgreSQL is capable of converting tables separately, together with foreign keys. It can also overwrite the entire databse or existing tables only. Also, the tool can remember your configuration settings and save them to file. This way, you can easily load profiles in future sessions and pick up where you left off without having to waste time entering the same settings. Full help documentation is available.

All aspects considered, OraDump to PostgreSQL delivers a simple and straightforward solution for migrating dump files from Oracle to PostgreSQL, thanks to its intuitive wizard and options.

Publisher Description

OraDump-to-PostgreSQL is a program to convert Oracle dump files into PostgreSQL database. Key features: (1) all versions of Oracle dump files are supported; (2) all versions of Windows and Unix/Linux PostgreSQL are supported; (3) converts multi-file Oracle dump files; (4) converts indexes with all necessary attributes; (5) option to convert individual tables; (6) option to merge Oracle data into an existing PostgreSQL database; (7) stores conversion settings into profile; (8) command line support; (9) easy-to-use wizard style interface

OraDump-to-PostgreSQL is a program to convert Oracle dump files into PostgreSQL database. All Oracle data types (except BFILE and MLSLABEL) and attributes are supported. The program has easy-to-use wizard style interface and works with all versions of PostgreSQL server.

OraDump-to-PostgreSQL 4.1 full description

OraDump-to-PostgreSQL is a program to convert Oracle dump files into PostgreSQL database. Key features: (1) all versions of Oracle dump files are supported; (2) all versions of Windows and Unix/Linux PostgreSQL are supported; (3) converts multi-file Oracle dump files; (4) converts indexes with all necessary attributes; (5) option to convert individual tables; (6) option to merge Oracle data into an existing PostgreSQL database; (7) stores conversion settings into profile; (8) command line support; (9) easy-to-use wizard style interface

OraDump to PostgreSQL

[Release Notes]  [Download]  [Buy]
Latest version 5.1 released 01/10/2022

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

  • 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.

 

Leave a Reply

Your email address will not be published. Required fields are marked *