Re: Migrating From CentOS-6 Oracle 11g R2 To CentOS-7 PostgreSQL ??

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