Re: Oracle Migration Approach (Open source vs Vendor Specific)

2019-05-09 Thread Bruce Momjian
On Wed, May 8, 2019 at 04:23:06PM -0500, Ron wrote: > On 5/8/19 3:30 PM, Sandeep Saxena wrote: > [snip] > > @Ravi > > My company is trying to avoid another vendor lockin too , thats why we > > are bit skeptical on going to EDB as once we start using their Oracle > > compatability > > feature then

Re: Oracle Migration Approach (Open source vs Vendor Specific)

2019-05-08 Thread Ron
On 5/8/19 3:30 PM, Sandeep Saxena wrote: [snip] @Ravi My company is trying to avoid another vendor lockin too , thats why we are bit skeptical on going to EDB as once we start using their Oracle compatability feature then it will be very difficult to move to community addition again. What ab

Re: Oracle Migration Approach (Open source vs Vendor Specific)

2019-05-08 Thread Ravi Krishna
>@Ravi  >My company is trying to avoid another vendor lockin too , thats why we are bit >skeptical >on going to EDB as once we start using their Oracle compatability  >feature then it will be very difficult to move to community addition again. As far as I know, vendor lock in applies only if

Re: Oracle Migration Approach (Open source vs Vendor Specific)

2019-05-08 Thread Sandeep Saxena
Actually I ran our schema against AWS Schema conversion tool ,and when i looked at converted code then i saw that for some stuff it was using other services of AWS which is only in AWS , So thats what i meant by not using AWS services and just keeping usage of Postgres and its extensions. @Ravi My

Re: Oracle Migration Approach (Open source vs Vendor Specific)

2019-05-08 Thread Adrian Klaver
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

Re: Oracle Migration Approach (Open source vs Vendor Specific)

2019-05-08 Thread Pavel Stehule
st 8. 5. 2019 v 17:40 odesílatel Sandeep Saxena napsal: > 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 i

Re: Oracle Migration Approach (Open source vs Vendor Specific)

2019-05-08 Thread Ravi Krishna
> 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? EDB is mainly attractive to Oracle shops who want Oracle compatibility.

Oracle Migration Approach (Open source vs Vendor Specific)

2019-05-08 Thread Sandeep Saxena
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 yo