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 Marius Nestor, last updated on December 8th, 2014
In a hurry? Add it to your Download Basket!
- 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.
Application descriptionOra2Pg is an open source, cross-platform and free software project written in the Perl programming language and design...