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 033611ab-cab9-34d5-96ec-5c3f27794c10@catalyst.net.nz
Whole thread Raw
In response to Re: Oracle to Postgres-Licensed GUI tool  (Paul Carlucci <paul.carlucci@gmail.com>)
Responses Re: Oracle to Postgres-Licensed GUI tool  (Pepe TD Vo <pepevo@yahoo.com>)
List pgsql-admin
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: Rui DeSousa
Date:
Subject: Re: backend proccess memory accumulates
Next
From: Pepe TD Vo
Date:
Subject: Re: Oracle to Postgres-Licensed GUI tool