Moving from Oracle to PostgreSQL

So far, we have seen how the most important advanced SQL features can be ported or used in PostgreSQL. Given this introduction, it is time to take a look at migrating Oracle database systems in particular.

These days, migrating from Oracle to PostgreSQL has become really popular due to Oracle’s new license and business policy. What is stunning to see is that back in the old days, costs were pretty much the main driver – these days, more and more people are moving away from Oracle for technical reasons. In particular, those moving to a Kubernetes-based stack favor PostgreSQL over Oracle as it is more flexible and a lot easier to handle.

Using the oracle_fdw extension to move data

One of my preferred methods to move users from Oracle to PostgreSQL is Laurenz Albe’s oracle_fdw extension (https://github.com/laurenz/oracle_fdw). It is a foreign data wrapper (FDW) that allows you to represent a table in Oracle as a table in PostgreSQL...