On 12/5/2017 10:59 AM, Eugene Poole wrote:
3. Would I use ora2pg do do the move? Is ora2pg still maintained? 4. Is there a better conversion package?
there are a variety of "ETL" tools out there that can extract data from one database and load it into another. I was going to suggest pgloader, but that doesn't support oracle, only mysql and ms sql server.
a full scale conversion of a complex application suite, however, can be a several year project. Our old Oracle application was very heavy on plsql. We chose to reimplement the vast majority of the business logic in appserver modules outside the database and only used plpgsql for things where performance mattered significantly.
the more heavily your apps use Oracle specific features, the more work the conversion will be.
-- john r pierce, recycling bits in santa cruz
