Download slides

PostgreSQL is our go-to relational database for all new applications and also target for migrations. As we are also involved in migration processes, we have chosen to share our processes, the joys (and tears) of our experiences, what worked well and not so well. To make our lives easier we’ve decided to work and contribute on tooling associated with migrations, most notably ora2pg and our own code2pg.

             We would be discussing on 4 key phases of migrations

Finalization of migration/Due diligence:Analyzing the app Architecture , Appropriate server resources ,Does really DB size matters, up to what extent, Specific features used.

Journey : Challenges with hierarchical queries, Handling explicit commit/rollback ,how to handle DBMS packages, Handling Global variables, Handling Autonomous transaction, String_aggregate with condition, How is LOB to be handled, Where does data types impact the applications, and what should application team know. Dynamic partitions (constraints,creating partition),Oracle_fdw,NON-ANSI JOIN to ANSI JOIN and so on.

Post migration:Challenges of Post migration checks 1) Data quality check,2)Testing.

Strategy for go-live: Planning ,Rollback,Parallel run etc.