ora2pg 4.2 review

Ora2Pg is a Perl module to export an Oracle database schema to a PostgreSQL compatible schema

License: Public Domain File size: 39K Developer: Gilles Darold

0

Ora2Pg is a Perl module to export an Oracle database schema to a PostgreSQL compatible schema. ora2pg project 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.

What's New in This Release:
This release fixes a miss taping on constraint type search that converted a unique key to a primary key.
It also fixes case sensitivity on CHECK constraint that could cause problems when check values are uppercase.