Re: Oracle Migration Approach (Open source vs Vendor Specific) - Mailing list pgsql-general

From Adrian Klaver
Subject Re: Oracle Migration Approach (Open source vs Vendor Specific)
Date
Msg-id a88d7c1b-e6b6-0a88-fecd-0b94155acdc6@aklaver.com
Whole thread Raw
In response to Oracle Migration Approach (Open source vs Vendor Specific)  (Sandeep Saxena <sandeep.lko@gmail.com>)
Responses Re: Oracle Migration Approach (Open source vs Vendor Specific)
List pgsql-general
On 5/8/19 8:39 AM, Sandeep Saxena wrote:
> 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 

Not sure how you can use Aurora without AWS?

> would you suggest to move to Community version from the start by taking 
> support/consultancy from other companies like 2nd quadrant and etc?

I would say move directly to the community version, save yourself a 
second transition cycle. Sign up with one the Postgres support companies 
and/or use these lists.

> 
> 
> 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


-- 
Adrian Klaver
adrian.klaver@aklaver.com



pgsql-general by date:

Previous
From: Pavel Stehule
Date:
Subject: Re: Oracle Migration Approach (Open source vs Vendor Specific)
Next
From: Sandeep Saxena
Date:
Subject: Re: Oracle Migration Approach (Open source vs Vendor Specific)