ora2pg Publisher's description
from Gilles DAROLD
Ora2Pg is a free tool used to migrate an Oracle database to a PostgreSQL compatible schema.
Ora2Pg is a free tool used to migrate an Oracle database to a PostgreSQL compatible schema. It connects your
Oracle database, scan it automaticaly and extracts its structure or data, it then generates SQL scripts that you can
load into your PostgreSQL database.
Ora2Pg can be used from reverse engineering Oracle database to huge enterprise database migration or simply to replicate
some Oracle data into a PostgreSQL database. It is really easy to used and doesn't need any Oracle database knowledge than
providing the parameters needed to connect to the Oracle database.
What's New in This Release:В· Fix double quote into file name of package function export when case sensitivity is preserved.
В· Add support to XMLType data extraction. Thanks to Aaron Culich for the report. Before this release, xml data was exported as a Perl array reference.
В· Fix bug during foreign key export when foreign keys have different owners. Thanks to Krasi Zlatev for the patch.
В· Add support to plpgsql conversion during index extraction as many index use some Oracle function on their declaration. Thanks to Sriram Chandrasekaran fot the feature request.
В· PLSQL: Add replacement of Oracle subtr() by PostgreSQL substring(). Thanks to Sriram Chandrasekaran for the feature request.
В· PLSQL: Add replacement of Oracle decode() by PostgreSQL CASE/THEN/ELSE. Thanks to Sriram Chandrasekaran for the feature request. Note that this two replacements could break the code if there's complex subqueries inside their declaration. This is why you can enable it by setting ALLOW_CODE_BREAK to 1 (new). In later release this directive will be enable by default.
В· Add output ordering on some object name so that results between two runs can be compared. Thanks to Henk Enting for the patch.
В· Fix misshandling of all cases of RAISE_APPLICATION_ERROR rewrite into RAISE EXCEPTION concatenations. Thanks to Krasi Zlatev for the report.
System Requirements:No special requirements.
Program Release Status: Minor Update
Program Install Support: Install and Uninstall