Обсуждение: Oracle to Postgres-Licensed GUI tool

soumik.bhattacharjee@kpn.com schrieb am 20.11.2018 um 19:10:
> 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.

ora2pg is free and extremely powerful

http://ora2pg.darold.net/

It's non-GUI however - which I would prefer for a migration tool anyway as that is easier to automate

I'll second the recommendation. I used ora2pg for our migration. It's the 80% solution -- some of the data types
weren'tproperly translated, but it's easy to go back, fix the appropriate script, and rerun that step. It saved us days
ofwork for several terabytes of Oracle data.
 

>

-----------------------------
This message is intended only for the recipient(s) to which it is addressed and may contain information that is
privilegedand confidential. If you have received this message in error, please notify the sender immediately and delete
allcopies.
 
-----------------------------

-----Original Message-----
> From: Thomas Kellerer <spam_eater@gmx.net>
> Sent: Tuesday, November 20, 2018 12:18
> To: pgsql-admin@lists.postgresql.org
> Subject: Re: Oracle to Postgres-Licensed GUI tool
>
> soumik.bhattacharjee@kpn.com schrieb am 20.11.2018 um 19:10:
> > 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.
>
> ora2pg is free and extremely powerful
>
> http://ora2pg.darold.net/
>
> It's non-GUI however - which I would prefer for a migration tool anyway as
> that is easier to automate
>

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

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