Tag: step by step

Posted on

Oracle to PostgreSQL Migration Guide: OLTP and Data Warehouse Examples

NASA Space Telescopes See Weather Patterns in Brown Dwarf

TL;DR: The manual work in an Oracle to PostgreSQL migration depends entirely on how the schema was built — not on its size.
This guide maps three common Oracle schema patterns to the specific migration example that covers each one: legacy OLTP, modern OLTP, and data warehouse.
If you are unsure which applies to your database, the diagnostic section below gives you four questions to find out.

Continue reading “Oracle to PostgreSQL Migration Guide: OLTP and Data Warehouse Examples”
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”