My Oracle to PostgreSQL Migration: The 7 Tools That Made It Possible. Ora2Pg was my first ally. It's an open-source tool that converts Oracle database schemas into PostgreSQL format.
Table of contents
Still optimizing SQL queries manually?Overview of the Migration ProcessOra2PgStill optimizing SQL queries manually?AWS Database Migration Service (DMS)pgLoaderForeign Data Wrappers (FDW)pg_dump, pg_restore and additional built-in PG featuresStill optimizing SQL queries manually?Still optimizing SQL queries manually?EverSQL, for Post Migration TuningNpgsqlCommon Pitfalls in Migrating from Oracle to PostgreSQLConclusion8 Impressions