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: [ read full changelog ]· When FILE_PER_FUNCTION is activated and export type is PACKAGE, Ora2Pg will now save all functions/procedures of a package body into a directory named as the package name and into different files. This will allow to load each function separatly or load them all with the OUTPUT SQL script generated by Ora2Pg.· Fix Oracle package body parsing failure when a procedure is declared inside an other.· Add new configuration options FILE_PER_CONSTRAINT and FILE_PER_INDEX to generate three files during the schema extraction. One for the \'CREATE TABLE\' statements, one for the constraints (primary keys, foreign keys, etc.) and the last one for indices. Thanks to Daniel Scott for the feature request.· Allow to process PL/SQL Oracle code from file instead of a database to apply Ora2Pg code conversion. Thank to Mindy Markowitz for the feature request. See -i or --input_file command line option to ora2pg perl script or INPUT_FILE new configuration option.· Add new configuration directive STANDARD_CONFORMING_STRINGS that is used only during DATA export type to build INSERT statements. This should avoid \'WARNING: nonstandard use of \\ in a string literal\'. Please check that this behavior is backward compatible with your PostgreSQL usage as this is the default now