Oracle Migration Approach (Open source vs Vendor Specific)

From: Sandeep Saxena <sandeep(dot)lko(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Oracle Migration Approach (Open source vs Vendor Specific)
Date: 2019-05-08 15:39:15
Message-ID: CAA3fARH+UseezGRUbSRSQk7kNca1wderEGyOBm2FzukDHBGgUw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi All,

In our company we are looking to migrate oracle db to postgres , now since
we dont have any expertise in Postgres in our organization so we are
planning to go
with AWS aurora or EDB postgres so that we have helping hand in
migration(in dev and dba) while we get mature in postgres ... do you guys
think after 1-2 years if required it will be easy to move from EDB or
Aurora to Open source Postgres assuming we dont use AWS services OR would
you suggest to move to Community version from the start by taking
support/consultancy from other companies like 2nd quadrant and etc?

All our developers are experienced in pl/sql so I assume it will be easier
to learn PL/pgsql ,isnt that right? so far only things i dont like about
PL/pgsql that validation of program units doesnt happen until you run it
... though i did find extension plpgsql_check to achieve that to some
extent.

Regards,
Sandeep

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ravi Krishna 2019-05-08 15:55:15 Re: Oracle Migration Approach (Open source vs Vendor Specific)
Previous Message Adrian Klaver 2019-05-08 13:49:52 Re: Postgres Database Hacked