Re: Oracle to Postgres-Licensed GUI tool - Mailing list pgsql-admin

From Mark Kirkwood
Subject Re: Oracle to Postgres-Licensed GUI tool
Date
Msg-id 5fa2c673-00ff-7b61-4c38-1d1a14f265a9@catalyst.net.nz
Whole thread Raw
In response to Re: Oracle to Postgres-Licensed GUI tool  (Pepe TD Vo <pepevo@yahoo.com>)
List pgsql-admin
I don't think so. I have a standard AWS account and DMS is available under 'services'.

The only major restriction I see is this: either the source or target db must be running inside AWS (either EC2 or RDS).

regards
Mark

On 23/11/18 1:13 PM, Pepe TD Vo wrote:
I think you need to pay for a full license for using DMS
 

On Thursday, November 22, 2018 5:15 PM, Mark Kirkwood <mark.kirkwood@catalyst.net.nz> wrote:


You can use AWS DMS (Data Migration Services) to actually more the data after setting up the destination schema via SCT. As usual with AWS there are quirks and limitations (particularly at the Oracle end of things), but it is an option.

regards
Mark

On 21/11/18 7:21 AM, Paul Carlucci wrote:
Moving data is a completely different tool, whereasnSCT only converts and migrates the DDL.

On Tue, Nov 20, 2018, 1:18 PM <soumik.bhattacharjee@kpn.com wrote:
Okay, I was of the idea that it always needs to be RDS and there’s a limit of data that can be migrated in trial version.
 
Thanks, will checkout that.
 
 
From: Paul Carlucci <paul.carlucci@gmail.com>
Sent: Tuesday, November 20, 2018 7:16 PM
To: Bhattacharjee, Soumik <soumik.bhattacharjee@kpn.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: Oracle to Postgres-Licensed GUI tool
 
Try the AWS Schema Conversion Tool, it's free and doesn't require either endpoint to be an RDS instance.
 
On Tue, Nov 20, 2018, 1:10 PM <soumik.bhattacharjee@kpn.com wrote:
Hello There,
 
Anyone came across any Licensed GUI tool to migrate database schemas from Oracle to Postgres.
 
+including Packages, Procedures etc..
 
+ Any idea of License costs if available.
 
 
Thanks




pgsql-admin by date:

Previous
From: Pepe TD Vo
Date:
Subject: Re: Oracle to Postgres-Licensed GUI tool
Next
From: Achilleas Mantzios
Date:
Subject: Logical wal receiver (background worker) not detecting when publishernode has died