Oracle to Amazon Aurora PostgreSQL migration:
The heterogeneous database migration encompassed two aspects: To convert the source scheme to target DB and to migrate the data to target DB.
We automated remediation of PostgreSQL compatibility issues using a regex-based remediation tool and built a framework for schema recon and post-migration data validations. CI/CD pipeline deployment accelerated migration efforts while monitoring Oracle performance metrics against Aurora PostgreSQL metrics.
Later, we extracted user data from the source database to a CSV file to be loaded into a temp table in PostgreSQL. Our team also created a SQL statement to retrieve data from the temp table in CREATE USER statements and ran it to set up users in PostgreSQL.