Обсуждение: Oracle to Postgres-Licensed GUI tool
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
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
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
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
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
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
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
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.
**Live simply **Love generously **Care deeply **Speak kindly.
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 >
Вложения
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
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
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
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
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.
**Live simply **Love generously **Care deeply **Speak kindly.
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 toolTry 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 DMSOn 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.regardsMarkOn 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 toolTry 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