Tag: PL/SQL

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)”
Posted on

Oracle to PostgreSQL Migration Best Practices: A Checklist for DBAs and Architects

white clouds and blue sky

TL;DR: Most Oracle to PostgreSQL migrations don't fail because of the tools — they fail because of skipped steps.
This checklist covers every phase from pre-migration assessment through cutover: the data type traps that cause silent data loss, the sequence and NULL differences that break applications after go-live, the testing steps that get cut when timelines slip, and the cutover decisions that determine whether you can roll back if something goes wrong.

Continue reading “Oracle to PostgreSQL Migration Best Practices: A Checklist for DBAs and Architects”