Course New Update
23-Mar-2026 - Added Sequence Cutover Learnings.
07-Sept-2024 - Added Ora2pg Installation on Window.
12-Sept-2024 - Added All Tool we need as Migration Engineer on Windows Machine.


Database migration to any cloud or platform is a niche skill and needs experienced professionals to drive larger scale migration for enterprise customers that involve near real time migration with minimal downtime, efficient code conversion from  oracle dialect to postgresql compatible one, data migration planning and achieving similar performance as current stack post migration.

In Course our core agenda is to enable folks to understand complexity in migration, understand different phases in actions and will share my personal experience of migrating plethora of customers out of Oracle to PostgreSQL compatible offerings like RDS, Amazon Aurora , Cloud SQL and AlloyDB.

Course is recording from live session and designed to be shared as hands on that we will perform on a Mock Schema that include intentional code complexity.

What we will learn.

1. Oracle Anomalies that no one will talk about in the assessment phase.
2. Schema Conversion complexity and some gotchas.
3. How to efficiently plan Code Conversion for customers migrating away from Oracle.
4. Key difference between Oracle and PostgreSQL SQL and Procedural Block.
5. Code Conversion steps and sanity how to automate.
6. Data type mapping between Oracle and PostgreSQL.
7. Efficient Data Migration planning and how to handle large tables with or without partitions.
8. How to perform validation during and post migrations.
9. Post migration activities that involves production ready instance, Monitoring and

Intended Audience.

With minimum 3 years of experience with any databases in Development, DBA or as Data Engineer.

Folks who are interested in understanding overall migrations and develop a niche on how to conduct end to end migrations.

Please contact for more information
krishnamahto10591@gmail.com
Mobile :- +91 8169415723