Category: Oracle to PostgreSQL

Posted on

The Complete Oracle-to-PostgreSQL Data Type Mapping Guide

serene snowy mountain landscape with pines

TL;DR: Most Oracle-to-PostgreSQL data type mappings are straightforward.
The dangerous ones are not.
Oracle DATE includes a time component that PostgreSQL DATE silently discards.
Oracle NUMBER maps to NUMERIC by default, which is correct but slow for integer workloads.
Empty strings in Oracle are NULL; in PostgreSQL they are not.
This guide gives you the full mapping table and covers the five traps that cause silent data corruption during migration.

Continue reading “The Complete Oracle-to-PostgreSQL Data Type Mapping Guide”
Posted on

5 Oracle to PostgreSQL Migration Projects That Failed (And Why)

blue and multicolored abstract paitning

TL;DR: Most Oracle to PostgreSQL migrations that fail don’t fail because PostgreSQL wasn’t ready.
They fail because the project wasn’t ready.
The five patterns below repeat across organisations and sectors because teams make the same assumptions: that the tools handle more than they do, that PL/SQL volume is smaller than it is, and that a rollback plan can be improvised at 2am.

Continue reading “5 Oracle to PostgreSQL Migration Projects That Failed (And Why)”