Yorvi Arias: Setup ora2pg for Oracle to Postgres Migration

https://postgr.es/p/4P8

An important part of performing a migration from Oracle to PostgreSQL is selecting the right tool for helping with the conversion between systems. When people ask me how they can get the migration process started, I like to recommend a powerful open source utility called "ora2pg".

As the name suggests, ora2pg is a tool that migrates Oracle (or MySQL) databases to PostgreSQL by generating compatible SQL files As the documentation states, ora2pg “connects your Oracle database, scans it automatically and extracts its structure or data, it then generates SQL scripts that you can load into your PostgreSQL database.”

Postgresql

via Planet PostgreSQL https://ift.tt/2g0pqKY

June 24, 2020 at 02:47PM