OSDN -- Develop and Download Open Source Software

RSS
Download List

Project Description

Ora2Pg is a Perl module to export an Oracle
database schema to a PostgreSQL compatible schema.
It connects your Oracle database, extracts its
structure, and generates an SQL script that you
can load into your PostgreSQL database. It dumps
the database schema (tables, views, sequences,
indexes, grants) with primary, unique, and foreign
keys into PostgreSQL syntax without editing the
SQL code generated. It also dump Oracle data into
PostgreSQL DB as online process or into a file.
You can choose what columns can be exported for
each table.

System Requirements

System requirement is not defined
Information regarding Project Releases and Project Resources. Note that the information here is a quote from Freecode.com page, and the downloads themselves may not be hosted on OSDN.

2010-09-11 10:33
6.4

This release fixes erroneous table renaming during replacement of column name and a missing of case sensitivity in the PG schema search path. The configuration directives SHOWTABLEID, MIN, and MAX have been definitively removed.

2010-07-31 14:02
6.3

This release fixes an Oracle 8i compatibility error during schema extraction and export of sequences that did not handle maxvalue well. It fixes an error using the IMPORT option on a read_conf method call.

2010-06-15 21:46
6.2

This release fixes a possible loss of consistency during data export. The Oracle transaction isolation level is now serializable. Old releases were using read only transaction.

2010-05-08 00:51
6.1

This release can export Oracle user-defined types and adds a new PG_SCHEMA configuration directive to force PostgreSQL schema search paths.

2010-02-28 20:46
6.0

A complete repackaging was done. There is a new Web site. Support for Oracle table partitioning export was added.

Project Resources

Project Page Download: Changelog Home Page Download: bzip2