Migrating an On-Premises Oracle Database to PostgreSQL on Google Cloud
Troubleshooting a complex database migration involving schema conversion, compatibility issues, and Google Cloud Database Migration Service.
Worked on the migration of an on-premises Oracle database to PostgreSQL on Google Cloud using Database Migration Service. The migration involved more than 680 tables and required careful investigation of PostgreSQL conversion issues during the migration process.
[ The Challenge ]
The project required moving an existing Oracle database running on an on-premises server to PostgreSQL on Google Cloud. While the migration path appeared straightforward at a high level, differences between Oracle and PostgreSQL introduced conversion and compatibility issues during the migration.
[ Architectural Decisions ]
- Used Google Cloud Database Migration Service as the migration platform.
- Used PostgreSQL as the target database while accounting for differences in database schemas and data types.
- Investigated migration failures by separating database conversion issues from potential issues within the Google Cloud migration service.
[ Key Outcomes & Lessons Learned ]
- ✓ Successfully investigated and isolated complex migration issues instead of treating the migration as a simple lift-and-shift operation.
- ✓ Worked with Google Cloud Support to investigate a suspected Database Migration Service backend issue.
- ✓ Gained practical experience handling the real-world differences between Oracle and PostgreSQL during cloud migration.