So at work we're currently trying to see if we can move away from Oracle and onto PostgreSQL.
I expect this to be a long process.
This blog post is here to document some of the issues we ran into and also remember references I found.
Migrating schema and data
There are several tools that can migrate the schema and the data from Oracle to Postgres.
There are some differences in what both database support. See reference [1].
Make changes to SQL Scripts
References
- [1] Hackermoon - How to Migrate from Oracle to PostgreSQL
- https://hackernoon.com/how-to-migrate-from-oracle-to-postgresql
- Postgres Wiki - Oracle to Postgres Conversion
- https://wiki.postgresql.org/wiki/Oracle_to_Postgres_Conversion
- PostgreSQL Manuals
- https://www.postgresql.org/docs/
- Ora2Pg - Moves Oracle and MySQL database to PostgreSQL
- https://ora2pg.darold.net/
- Life in USA - install ora2pg on mac osx
- https://vcfvct.wordpress.com/2016/10/18/install-ora2pg-on-mac-osx/
