Explore the intricacies of Oracle to PostgreSQL migration validation using Ora2Pg in this informative conference talk by Gilles Darold at PGConf NYC 2021. Discover the importance of robust validation techniques in ensuring successful migrations, covering schema validation, object migration prioritization, and data integrity checks. Learn about Ora2Pg's newly committed features that support comprehensive validation processes, including row count verification and data validation. Gain insights into the steps of migration, testing procedures, and handling data type differences. Understand the prerequisites, settings, and potential challenges in procedure testing, equipping yourself with essential knowledge for seamless database migrations.
Overview
Syllabus
Intro
Celebration
Steps of a migration
Testing
Type of objects
Validation of data type
Checking the number of lines
Data migration time
Data validation
Prerequisites
Settings
Example of definition change
How about data type differences
Test of procedures
Taught by
Confreaks