Conference Schedule - PGConf.EU 2022

Migration validation made easy with Ora2Pg

Date: 2022-10-27
Time: 09:30–10:20
Room: Zurich
Level: Intermediate

Ora2Pg has been the first Open Source migration project for performing Migration Assessments, Schema and Data Migrations from Oracle to PostgreSQL. Today, there exists a good number of solutions to perform Oracle to PostgreSQL migrations. However, the major risk is involved when there exists no robust validation technique. One of the major reasons for a failed migration is the validation.

Validation not only includes objects like tables, constraints, indexes, triggers, sequences, views, etc. but also the data. In this talk, i am going to discuss about how the validation can be performed and some of the newly committed features of Ora2Pg that is going to support such a validation.


Gilles Darold