Ora2Pg 14.1

This Open Source project helps you export a Oracle database schema to a PostgreSQL one
Ora2Pg - Command-line options of the ora2pg program, as viewed from the Linux Terminal
  2 Screenshots
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.

Reviewed by , last updated on December 8th, 2014


price:
FREE!
homepage:
ora2pg.darold.net
license type:
Perl Artistic License 
developed by:
Gilles DAROLD
category:
ROOT \ Database \ Database APIs
Ora2Pg
Download Button

In a hurry? Add it to your Download Basket!

softpedia rating

4.5/5

user rating 2

4.5/5
 

0/5

Rate it!
What's New in This Release:
  • 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
2 Screenshots
Ora2Pg - The usage message of the ora2pg program, as viewed from the Linux Terminal
 

Application description

Ora2Pg is an open source, cross-platform and free software project written in the Perl programming language and design...

Add your review!

SUBMIT