Migrate Oracle to PostgreSQL: Roles and Privileges
Summary: In this article, you will learn the roles and privileges, and the differences between Oracle and PostgreSQL.
Migrate Oracle to PostgreSQL: PL/SQL vs PL/pgSQL
Summary: In this article, you will learn the features of procedural languages, and the differences between PL/SQL and PL/pgSQL.
Migrate Oracle to PostgreSQL: Understand the Concept of Schema
Summary: In this article, you will learn the concept of schema, and the differences between Oracle and PostgreSQL.
Migrate Oracle to PostgreSQL: NULL and empty strings
Summary: This article discusses the differences between how Oracle and PostgreSQL evaluate NULL characters and empty strings. Oracle reads empty strings as NULLs, while PostgreSQL treats them as empty. Concatenating NULL values with non-NULL characters results in that character in Oracle, but NULL in PostgreSQL.
db_migrator: Migrate other databases to PostgreSQL
Summary: db_migrator is a PostgreSQL extension that provides functions for migrating databases from other data sources to PostgreSQL.
ora_migrator: Oracle to PostgreSQL migration tools
Summary: ora_migrator is a plugin for db_migrator that uses oracle_fdw to migrate an Oracle database to PostgreSQL.
oracle_fdw: Foreign Data Wrapper for Oracle
Summary: oracle_fdw is a PostgreSQL extension that provides a Foreign Data Wrapper for easy and efficient access to Oracle databases, including pushdown of WHERE conditions and required columns as well as comprehensive EXPLAIN support.