Chapter 1. Description

ora2pgpro is a tool used to migrate an Oracle™ database to a Postgres Pro™ compatible schema. It connects your Oracle database, scans it automatically and extracts its structure or data, then generates SQL scripts that you can load into your Postgres Pro database. ora2pgpro can be used for anything from reverse engineering of an Oracle database to huge enterprise database migration or simply replicating some Oracle data into a Postgres Pro database. It does not require any Oracle database knowledge other than providing the parameters needed to connect to the Oracle database.

pdf