Ora2Pg 14.1

This Open Source project helps you export a Oracle database schema to a PostgreSQL one

  Add it to your Download Basket!

 Add it to your Watch List!


Rate it!

What's new in Ora2Pg 14.1:

  • Remove ALLOW_CODE_BREAK, it is no more useful.
  • Change output of SHOW_ENCODING to reflect change to default encoding.
  • Comment ALLOW_PARTITION in default configuration file.
  • Add QUERY and KETTLE export type in configuration file comments.
Read full changelog
send us
an update
Perl Artistic License 
4.5/5 2
ROOT \ Database \ Database APIs
2 Ora2Pg Screenshots:
Ora2Pg - Command-line options of the ora2pg program, as viewed from the Linux TerminalOra2Pg - The usage message of the ora2pg program, as viewed from the Linux Terminal
Ora2Pg is an open source, multiplatform and freely distributed command-line program implemented in Perl and designed from the ground up to be used for easily exporting an Oracle database schema to a PostgreSQL compatible schema.

Features at a glance

Key features include support for exporting full database schema, support for exporting grants and privileges for users and groups, support for exporting a table selection, as well as support for exporting Oracle schema to a PostgreSQL 7.3+ schema.

The project is also capable of connecting to any Oracle database, supports extracting of its internal structure and generates an SQL script that you can load into your PostgreSQL database.

Additionally, the software is capable of exporting range and list Oracle partitions, export predefined triggers, functions, procedures, packages, as well as package bodies. Various command-line options are available to users, which can be viewed at a glance by running the ‘ora2pg --help’ command in a terminal emulator.

Getting started with Ora2Pg

To install and use the Ora2Pg software on your GNU/Linux computer, you must download the latest version of the program from Softpedia or via its official website (see link at the end of the article), save the archive somewhere on your PC and unpack it using an archive manager utility.

Then, open a Terminal application, navigate to the location of the extracted archive files (e.g. cd /home/softpedia/ora2pg-14.1), run the ‘perl Makefile.PL’ command to configure the project, followed by the ‘make’ command to compile it.

Install Ora2Pg system wide by executing the ‘make install’ command as root or the ‘sudo make install’ command as a privileged user. Use it by running the ‘ora2pg’ command in a terminal emulator.

Ora2Pg is supported on any operating system where Perl is available, including GNU/Linux, Microsoft Windows and Mac OS X.

Ora2Pg was reviewed by , last updated on December 8th, 2014

#Oracle to PostgreSQL #export database #database schema #Oracle #PostgreSQL #database #schema

Add your review!