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

Channel:
United States Confreaks
Subscribers:
42,400
Published on ● Video Link: https://www.youtube.com/watch?v=4AyqYPjErbk


Duration: 53:48
120 views
0

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.



Other Videos By Confreaks


2022-10-12PGConf NYC 2021 - Speaking and Community Involvement for the Introvert by Pat Wright
2022-10-12PGConf NYC 2021 - Get Your Insecure PostgreSQL Passwords to SCRAM! by Jonathan S. Katz
2022-10-12PGConf NYC 2021 - NORM: No ORM Framework by Henrietta Dombrovskaya
2022-10-12PGConf NYC 2021 - Navigate Postgres Cloud Paths: Kubernetes, IaaS, or DbaaS by Marc Linster
2022-10-12PGConf NYC 2021 - How we made PG Fitter, Happier, More Productive by Andrew Atkinson
2022-10-12PGConf NYC 2021 - War Stories: Fighting the PostreSQL Support Trenches by Hans Jurgen
2022-10-12PGConf NYC 2021 - Flexible Indexing with Postgres by Bruce Momjian
2022-10-12PGConf NYC 2021 - How PostgreSQL aggregates work and how to create and use custom... by David Kohn
2022-10-12PGConf NYC 2021 - A Deep Dive into PostgreSQL Indexing by Ibrar Ahmed
2022-10-12PGConf NYC 2021 - PostgreSQL sharding, state of the art by Julien Tachoires
2022-10-12PGConf NYC 2021 - Migration validation made easy with Ora2Pg by Gilles Darold
2022-10-12PGConf NYC 2021 - Evolution Of PostgreSQL Replication and High Availability... by Stacy Scoggins
2022-10-12PGConf NYC 2021 - Pglog: a flexible log analyser by Laetitia Avrot
2022-10-12PGConf NYC 2021 - When it all GOes right by Pavlo Golub
2022-10-12PGConf NYC 2021 - Data Security using Roles, Privileges and Row Level Security by Abbas Butt
2022-10-12PGConf NYC 2021 - Postgres and Json - How to get the best of them? by Charly Batista
2022-10-04EmberConf 2021 - Fun Fast Tools for Serious Work by Ed Faulkner
2022-10-04EmberConf 2021 - Fast-Track Ember with Fastboot + Embroider by Suchita Doshi and Thomas Wang
2022-10-04EmberConf 2021 - Modernizing a Massive Monolith by Aubrey Knudson
2022-10-04EmberConf 2021 - Ending the Plague of Memory Leaks by Steve Szczecina
2022-10-04EmberConf 2021 - Please wait… Oh, It Didn't Work! by Tobias Bieniek


Tags:
PostgreSQL
PGConf
Postgres