Release date: 2023-09-22
This is the first public release of ora2pgpro™. It is shipped as a package compatible with Postgres Pro Enterprise™.
Major features are as follows:
- Export full database schema (tables, views, sequences, indexes), with unique, primary, foreign key, and check constraints.
- Export grants/privileges for users and groups.
- Export range/list partitions and subpartitions.
- Export a table selection (by specifying the table names).
- Export Oracle schema to a Postgres Pro schema.
- Export predefined functions, triggers, procedures, packages, and package bodies.
- Export full data or following a
WHEREclause. - Full support of Oracle BLOB objects as Postgres Pro bytea.
- Export Oracle views as Postgres Pro tables.
- Export Oracle user-defined types.
- Provide some basic automatic conversion of PL/SQL code to PL/pgSQL.
- Works on any platform.
- Export Oracle tables as foreign data wrapper tables.
- Export materialized views.
- Show a report of an Oracle database content.
- Migration cost assessment of an Oracle database.
- Migration difficulty level assessment of an Oracle database.
- Migration cost assessment of PL/SQL code from a file.
- Migration cost assessment of Oracle SQL queries stored in a file.
- Export Oracle locator and spatial geometries into PostGIS.
- Export
DBLINKas Oracle FDW. - Export
SYNONYMs as views. - Export
DIRECTORYas external table or directory forexternal_fileextension. - Dispatch a list of SQL orders over multiple Postgres Pro connections.
- Perform a diff between Oracle and Postgres Pro database for test purposes.