Product catalog database migration using tool ora2pg
29. 3. 2022
For our telecommunication customer we have developed and performed the migration of their legacy product catalogue database structure into new catalogue structure for their new application. Product catalogue was based on Broadleaf product and was stored in Oracle Database. The requirement was not to migrate the structure and data only, but also to transfer the migrated database content into cloud PostgreSQL database.
For this purpose we have chosen ora2pg tool. Ora2pg is an open source tool used to migrate an Oracle database to a PostgreSQL database. This tool scans and extracts the database schema and data and then generates PostgreSQL-compatible SQL scripts that you can use to populate the database. We have migrated all database using ora2pg from development to production. We have used particular migration concept where imported scheme and data are not directly imported to final scheme, but into intermediate stage without all the constraints. Afterwards import constraints are activated and after that are data loaded into final scheme. This concept ease successive troubleshooting and debugging.
Migration process can be easily automated using automation tools.
Usage of ora2pg is also documented on google cloud tutorial pages: https://cloud.google.com/community/tutorials/migrate-oracle-postgres-using-ora2pg. As well as Microsoft Azure: https://docs.microsoft.com/en-us/azure/postgresql/howto-migrate-from-oracle. It is preferred and standardized tool for Oracle database migration into PostgreSQL stored in Google Cloud or Microsoft Azure.
The biggest cloud provider AWS is also familiar with this topic: https://aws.amazon.com/blogs/database/migrating-blob-and-clob-tables-from-oracle-to-postgresql-using-ora2pg-and-aws-dms/
https://aws.amazon.com/blogs/database/migrating-user-defined-types-from-oracle-to-postgresql/.
In this area our services includes and consultancy, migration concept and design proposal as well as execution of migration.
Back to News