ora2pg
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.
| Tags | Database |
|---|---|
| Licenses | GPLv3 |
| Operating Systems | POSIX Linux Unix Windows |
| Implementation | Perl |
Recent releases
- 08 Nov 2011 22:15
Release Notes: This release adds support to XMLType data export and plsql to plpgsql replacement for the Oracle functions substr() and decode(). PL/SQL conversion can now be called during index extraction. There are also some major bugfixes in foreign key export and raise_application_error() rewrite.
- 13 Oct 2011 15:19
Release Notes: This release mainly fixes some remaining case sensitivity issues during Oracle database exportation.
- 07 Sep 2011 22:36
Release Notes: This release adds multi-threading and speed improvements on LOB export. There are also some major bugfixes and enhancements.
- 11 Jul 2011 02:54
Release Notes: An issue that breaks view export and was introduced in 8.5 has been fixed. There are more PL/SQL to PL/PGSQL conversion capabilities and two more configuration directives.
- 01 Jul 2011 20:50
Release Notes: This release allows you to process PL/SQL Oracle code from a file instead of a database to apply Ora2Pg code conversion, and adds three new configuration directives to enable support for a standard conforming string and create separate output files for constraints and indices.
darold
28 Dec 2001 11:05
Heartbeat
- Popularity Score
- 275.91
- Vitality Score
- 38.74
- Subscriptions
- 60
