Ora2Pg icon

Ora2Pg For Linux

4.5/5 2
Perl Artistic License    

This Open Source project helps you export a Oracle database schema to a PostgreSQL one. #Oracle to PostgreSQL  #Export database  #Database schema  #Oracle  #PostgreSQL  #Database  

Softpedia Review

changelog

Free Download

Review by:
4.5/5

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.

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.

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.

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.

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 the full changelog
User Comments
This enables Disqus, Inc. to process some of your data. Disqus privacy policy

Ora2Pg 14.1

add to watchlist add to download basket send us an update REPORT
  runs on:
Linux
  2 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
  main category:
Database
  developer:
  visit homepage