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

ora2pg Ranking & Summary

ora2pg Tags

Oracle to PostgreSQL export Oracle database schema convert Oracle database ora2pg Oracle PostgreSQL

ora2pg Description

Ora2Pg is a Perl module to export an Oracle database schema to a PostgreSQL compatible schema. 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: · Fix missing -U username at Pg connection. Thanks to Brendan Richards. · Fix $ENV{ORACLE_HOME} and $ENV{NLS_LANG} to not being overwritten by configuration settings if they are already defined in environment. · Fix typo in ora2pg.pl where keep_pkey_names was replaced by keep_pkeys_name and so prevent use of KEEP_PKEY_NAMES in configuration. Thanks to Olivier Mazain for the report. · Configuration file directives are now case insensitive. · Force $type parameter given to _sql_type() to be uppercase in that methode instead of during function call. Thanks to Ali Pouya for the report. · Modify ora2pg.pl to remove the obsolete call to export_data(). Use only export_schema() now. Modify ora2pg.pl to simplify it. Reading configuration is now done internally by Ora2Pg.pm as well as all other initialization process. You can always overwrite all configuration options into call to new Ora2Pg(). Now ora2pg.pl can be as simple as: · use Ora2Pg; · my $schema = new Ora2Pg('config' => "/etc/ora2pg.conf"); · $schema->export_schema(); · exit(0); · This will be less confusing. You can upgrade Ora2Pg.pm without carring about that, backward compatibility with previous version is preserved. · Review entire documentation with the great help of Ali Pouya. · Add type BOOLEAN converted to boolean. · PG_SUPPORTS_INOUT is now enabled by default in the configuration file SQL and PL/SQL to PLPGSQL converter: · Replace MINUS call to EXCEPT · Replace DBMS_OUTPUT.put, DBMS_OUTPUT.put_line, DBMS_OUTPUT.new_line by the PLPGSQL equivalent: RAISE NOTICE · Rewrite function/procedure/package convertion functions. This Oracle SQL converter for function/procedure/package is now only applied if the configuration directive PLSQL_PGSQL is enable, else these Oracle code are exported as is. Thanks to Ali Pouya for the help. · Reserved call to sql transaction only for DATA export type. Others export type now use set ON_ERROR_STOP ON. Thanks to Ali Pouya. · Fix tablespace creation into schema (missing search_path). Thanks to Olivier Mazain. · Fix the type returned by the _sql_type() method in the case of a numeric with null len and pg_numeric_type is set. Thanks to Ali Pouya. Change function body delimiter to $body$ to allow use of $$ into the body as quote replacement. Thanks to Ali Pouya. Fix returns type from function. If multiple OUT parameters: RECORD, if only one OUT parameter, return his type. If no out parameter: return VOID. Thanks to Ali Pouya. · Fix export DATA when the name of a column in the table match COMMENT, AUDIT or any other defined reserved words. These reserved words are defined in a new configuration variable ORA_RESERVED_WORDS. It accept a list of comma separated reserved words. Thanks to Andrea Agosti for the report. · Fix configuration parser that omit custom SYSUSERS definition.

ora2pg Related Software