Virtusa migrated one instance of the Enrolment application from Oracle to AWS infrastructure as a pilot. We built a regex-based utility to reduce manual efforts in remediating Postgres compatibility issues for approximately 650 iBATIS mapper and Kettle ETL scripts; defined the deployment process for performing repetitive migrations in higher environments; built a framework for schema reconciliation; data validations and repetitive migrations; and brought performance metrics to a baseline.
AWS SCT and DMS were the primary migration tools used for database migration. Virtusa carried out the database migration in three phases.
Phase 1: Schema conversion
Phase 2: Database migration: DMS used to migrate the data from Oracle to Aurora PostgreSQL
Phase 3: Schema reconciliation and data validation post-migration