PGConf NYC 2021 - Migration validation made easy with Ora2Pg by Gilles Darold

Migration validation made easy with Ora2Pg by Gilles Darold

Ora2Pg has recently completed its 20 years anniversary. It 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.

The talk includes :

Validation of Schema between Oracle and PostgreSQL
Type of objects that need to be migrated before starting the data migration.
What to disable or enable before and after performing the data migration.
Validation of row counts using Ora2Pg.
Validation of data using Ora2Pg.