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
WHERE clause.
-
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
DBLINK as Oracle FDW.
-
Export
SYNONYMs as views.
-
Export
DIRECTORY as external table or directory
for external_file extension.
-
Dispatch a list of SQL orders over multiple
Postgres Pro connections.
-
Perform a diff between Oracle
and Postgres Pro database for test purposes.