Oracle to PostgreSQL using Ora2PG

In this article, we are going to talk about using ora2pg to migrate the database from Oracle to PostgreSQL. We are going to consider PostgreSQL in Azure VM, PostgreSQL and Azure Database for PostgreSQL as target from Oracle. Source Oracle version is 11g XE.

The website https://ora2pg.darold.net/documentation.html talks about manual installation of ora2pg which is complex, there is an easy way to install in on Linux & Windows all you have to do is download the respective scripts for Linux or Windows and run it as root or administrator.

https://github.com/microsoft/DataMigrationTeam/tree/master/IP%20and%20Scripts/PostgreSQL%20Migration%20and%20Assessment%20Tools

Once the installation is done, the very first step would be to assess your Oracle and create a report