Oracle to Postgres-Licensed GUI tool

Поиск
Список
Период
Сортировка
Искать

Oracle to Postgres-Licensed GUI tool

От:
<soumik.bhattacharjee@kpn.com>
Дата:

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

Re: Oracle to Postgres-Licensed GUI tool

От:
Paul Carlucci <paul.carlucci@gmail.com>
Дата:
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

RE: Oracle to Postgres-Licensed GUI tool

От:
<soumik.bhattacharjee@kpn.com>
Дата:

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

Re: Oracle to Postgres-Licensed GUI tool

От:
Paul Carlucci <paul.carlucci@gmail.com>
Дата:
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

RE: Oracle to Postgres-Licensed GUI tool

От:
<soumik.bhattacharjee@kpn.com>
Дата:

Yeah, I need an end to end to move oracle schemas to Postgres.

 

Thanks..

 

From: Paul Carlucci <paul.carlucci@gmail.com>
Sent: Tuesday, November 20, 2018 7:21 PM
To: Bhattacharjee, Soumik <soumik.bhattacharjee@kpn.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: Oracle to Postgres-Licensed GUI tool

 

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

Re: Oracle to Postgres-Licensed GUI tool

От:
Thomas Kellerer <spam_eater@gmx.net>
Дата:
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


Re: Oracle to Postgres-Licensed GUI tool

От:
abbas alizadeh <ramkly@yahoo.com>
Дата:
Hi,
You can check this tools:

Best Regards
Abbas


On Nov 20, 2018, at 9:40 PM, <soumik.bhattacharjee@kpn.com> <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

Re: Oracle to Postgres-Licensed GUI tool

От:
Pepe TD Vo <pepevo@yahoo.com>
Дата:
FYI, RDS and there’s a limit of data that can be migrated but not triggers and procedures.
https://www.ispirer.com/products/oracle-to-postgresql-migration, MnMKT tool which should be installed on Window machine not in Linux
 
Bach-Nga

No one in this world is pure and perfect.  If you avoid people for their mistakes you will be alone. So judge less, love and forgive more.
To call him a dog hardly seems to do him justice though in as much as he had four legs, a tail, and barked, I admit he was, to all outward appearances. But to those who knew him well, he was a perfect gentleman (Hermione Gingold)

**Live simply **Love generously **Care deeply **Speak kindly.
*** Genuinely rich *** Faithful talent *** Sharing success


On Tuesday, November 20, 2018 2:47 PM, abbas alizadeh <ramkly@yahoo.com> wrote:


Hi,
You can check this tools:

Best Regards
Abbas


On Nov 20, 2018, at 9:40 PM, <soumik.bhattacharjee@kpn.com> <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


RE: Oracle to Postgres-Licensed GUI tool

От:
Erwin Fritz <efritz@gljpc.com>
Дата:
Вложения:
I'll second the recommendation. I used ora2pg for our migration. It's the 80% solution -- some of the data types weren't properly translated, but it's easy to go back, fix the appropriate script, and rerun that step. It saved us days of work 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 privileged and confidential. If you have received this message in error, please notify the sender immediately and delete all copies.
-----------------------------

-----Original Message-----
> From: Thomas Kellerer 
> 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
>

Re: Oracle to Postgres-Licensed GUI tool

От:
Shreeyansh Dba <shreeyansh2014@gmail.com>
Дата:
Hi Soumik,

You can use below tools which are free and opensource.
ora2pg: is easy and extremely powerful.


ora_migrator:- Sequences and normal tables with their constraints and indexes will be migrated, all objects containing PL/SQL code (triggers, functions, procedures and packages) will have to be migrated by hand.

https://github.com/cybertec-postgresql/ora_migrator




On Tue, Nov 20, 2018 at 11:40 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

RE: Oracle to Postgres-Licensed GUI tool

От:
<soumik.bhattacharjee@kpn.com>
Дата:

Thanks Abbas, did you have any experience with this tool in your projects?

 

 

 

From: abbas alizadeh <ramkly@yahoo.com>
Sent: Tuesday, November 20, 2018 8:43 PM
To: Bhattacharjee, Soumik <soumik.bhattacharjee@kpn.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: Oracle to Postgres-Licensed GUI tool

 

Hi,

You can check this tools:

 

Best Regards

Abbas


On Nov 20, 2018, at 9:40 PM, <soumik.bhattacharjee@kpn.com> <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

Re: Oracle to Postgres-Licensed GUI tool

От:
Mark Kirkwood <mark.kirkwood@catalyst.net.nz>
Дата:
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


Re: Oracle to Postgres-Licensed GUI tool

От:
Pepe TD Vo <pepevo@yahoo.com>
Дата:
I think you need to pay for a full license for using DMS
 
Bach-Nga

No one in this world is pure and perfect.  If you avoid people for their mistakes you will be alone. So judge less, love and forgive more.
To call him a dog hardly seems to do him justice though in as much as he had four legs, a tail, and barked, I admit he was, to all outward appearances. But to those who knew him well, he was a perfect gentleman (Hermione Gingold)

**Live simply **Love generously **Care deeply **Speak kindly.
*** Genuinely rich *** Faithful talent *** Sharing success


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



Re: Oracle to Postgres-Licensed GUI tool

От:
Mark Kirkwood <mark.kirkwood@catalyst.net.nz>
Дата:
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




FAQ