pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedOracle to Postgres-Licensed GUI tool
14+ messages / 8 participants
[nested] [flat]
* Oracle to Postgres-Licensed GUI tool
@ 2018-11-20 18:10 soumik.bhattacharjee@kpn.com
2018-11-20 18:15 ` Re: Oracle to Postgres-Licensed GUI tool Paul Carlucci <paul.carlucci@gmail.com>
2018-11-20 19:17 ` Re: Oracle to Postgres-Licensed GUI tool Thomas Kellerer <spam_eater@gmx.net>
2018-11-20 19:42 ` Re: Oracle to Postgres-Licensed GUI tool abbas alizadeh <ramkly@yahoo.com>
2018-11-21 09:04 ` Re: Oracle to Postgres-Licensed GUI tool Shreeyansh Dba <shreeyansh2014@gmail.com>
0 siblings, 4 replies; 14+ messages in thread
From: soumik.bhattacharjee@kpn.com @ 2018-11-20 18:10 UTC (permalink / raw)
To: pgsql-admin
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
^ permalink raw reply [nested|flat] 14+ messages in thread
* Re: Oracle to Postgres-Licensed GUI tool
2018-11-20 18:10 Oracle to Postgres-Licensed GUI tool soumik.bhattacharjee@kpn.com
@ 2018-11-20 18:15 ` Paul Carlucci <paul.carlucci@gmail.com>
2018-11-20 18:18 ` RE: Oracle to Postgres-Licensed GUI tool soumik.bhattacharjee@kpn.com
3 siblings, 1 reply; 14+ messages in thread
From: Paul Carlucci @ 2018-11-20 18:15 UTC (permalink / raw)
To: soumik.bhattacharjee@kpn.com; +Cc: pgsql-admin
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
>
^ permalink raw reply [nested|flat] 14+ messages in thread
* RE: Oracle to Postgres-Licensed GUI tool
2018-11-20 18:10 Oracle to Postgres-Licensed GUI tool soumik.bhattacharjee@kpn.com
2018-11-20 18:15 ` Re: Oracle to Postgres-Licensed GUI tool Paul Carlucci <paul.carlucci@gmail.com>
@ 2018-11-20 18:18 ` soumik.bhattacharjee@kpn.com
2018-11-20 18:21 ` Re: Oracle to Postgres-Licensed GUI tool Paul Carlucci <paul.carlucci@gmail.com>
0 siblings, 1 reply; 14+ messages in thread
From: soumik.bhattacharjee@kpn.com @ 2018-11-20 18:18 UTC (permalink / raw)
To: paul.carlucci@gmail.com; +Cc: pgsql-admin
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<mailto: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
^ permalink raw reply [nested|flat] 14+ messages in thread
* Re: Oracle to Postgres-Licensed GUI tool
2018-11-20 18:10 Oracle to Postgres-Licensed GUI tool soumik.bhattacharjee@kpn.com
2018-11-20 18:15 ` Re: Oracle to Postgres-Licensed GUI tool Paul Carlucci <paul.carlucci@gmail.com>
2018-11-20 18:18 ` RE: Oracle to Postgres-Licensed GUI tool soumik.bhattacharjee@kpn.com
@ 2018-11-20 18:21 ` Paul Carlucci <paul.carlucci@gmail.com>
2018-11-20 18:33 ` RE: Oracle to Postgres-Licensed GUI tool soumik.bhattacharjee@kpn.com
2018-11-22 22:15 ` Re: Oracle to Postgres-Licensed GUI tool Mark Kirkwood <mark.kirkwood@catalyst.net.nz>
0 siblings, 2 replies; 14+ messages in thread
From: Paul Carlucci @ 2018-11-20 18:21 UTC (permalink / raw)
To: soumik.bhattacharjee@kpn.com; +Cc: pgsql-admin
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
>
>
^ permalink raw reply [nested|flat] 14+ messages in thread
* RE: Oracle to Postgres-Licensed GUI tool
2018-11-20 18:10 Oracle to Postgres-Licensed GUI tool soumik.bhattacharjee@kpn.com
2018-11-20 18:15 ` Re: Oracle to Postgres-Licensed GUI tool Paul Carlucci <paul.carlucci@gmail.com>
2018-11-20 18:18 ` RE: Oracle to Postgres-Licensed GUI tool soumik.bhattacharjee@kpn.com
2018-11-20 18:21 ` Re: Oracle to Postgres-Licensed GUI tool Paul Carlucci <paul.carlucci@gmail.com>
@ 2018-11-20 18:33 ` soumik.bhattacharjee@kpn.com
1 sibling, 0 replies; 14+ messages in thread
From: soumik.bhattacharjee@kpn.com @ 2018-11-20 18:33 UTC (permalink / raw)
To: paul.carlucci@gmail.com; +Cc: pgsql-admin
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<mailto: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<mailto:paul.carlucci@gmail.com>>
Sent: Tuesday, November 20, 2018 7:16 PM
To: Bhattacharjee, Soumik <soumik.bhattacharjee@kpn.com<mailto:soumik.bhattacharjee@kpn.com>>
Cc: pgsql-admin@postgresql.org<mailto: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<mailto: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
^ permalink raw reply [nested|flat] 14+ messages in thread
* Re: Oracle to Postgres-Licensed GUI tool
2018-11-20 18:10 Oracle to Postgres-Licensed GUI tool soumik.bhattacharjee@kpn.com
2018-11-20 18:15 ` Re: Oracle to Postgres-Licensed GUI tool Paul Carlucci <paul.carlucci@gmail.com>
2018-11-20 18:18 ` RE: Oracle to Postgres-Licensed GUI tool soumik.bhattacharjee@kpn.com
2018-11-20 18:21 ` Re: Oracle to Postgres-Licensed GUI tool Paul Carlucci <paul.carlucci@gmail.com>
@ 2018-11-22 22:15 ` Mark Kirkwood <mark.kirkwood@catalyst.net.nz>
2018-11-23 00:13 ` Re: Oracle to Postgres-Licensed GUI tool Pepe TD Vo <pepevo@yahoo.com>
1 sibling, 1 reply; 14+ messages in thread
From: Mark Kirkwood @ 2018-11-22 22:15 UTC (permalink / raw)
To: Paul Carlucci <paul.carlucci@gmail.com>; soumik.bhattacharjee@kpn.com; +Cc: 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
> <mailto: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
> <mailto:paul.carlucci@gmail.com>>
> *Sent:* Tuesday, November 20, 2018 7:16 PM
> *To:* Bhattacharjee, Soumik <soumik.bhattacharjee@kpn.com
> <mailto:soumik.bhattacharjee@kpn.com>>
> *Cc:* pgsql-admin@postgresql.org <mailto: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
> <mailto: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
>
^ permalink raw reply [nested|flat] 14+ messages in thread
* Re: Oracle to Postgres-Licensed GUI tool
2018-11-20 18:10 Oracle to Postgres-Licensed GUI tool soumik.bhattacharjee@kpn.com
2018-11-20 18:15 ` Re: Oracle to Postgres-Licensed GUI tool Paul Carlucci <paul.carlucci@gmail.com>
2018-11-20 18:18 ` RE: Oracle to Postgres-Licensed GUI tool soumik.bhattacharjee@kpn.com
2018-11-20 18:21 ` Re: Oracle to Postgres-Licensed GUI tool Paul Carlucci <paul.carlucci@gmail.com>
2018-11-22 22:15 ` Re: Oracle to Postgres-Licensed GUI tool Mark Kirkwood <mark.kirkwood@catalyst.net.nz>
@ 2018-11-23 00:13 ` Pepe TD Vo <pepevo@yahoo.com>
2018-11-23 00:21 ` Re: Oracle to Postgres-Licensed GUI tool Mark Kirkwood <mark.kirkwood@catalyst.net.nz>
0 siblings, 1 reply; 14+ messages in thread
From: Pepe TD Vo @ 2018-11-23 00:13 UTC (permalink / raw)
To: Mark Kirkwood <mark.kirkwood@catalyst.net.nz>; Paul Carlucci <paul.carlucci@gmail.com>; soumik.bhattacharjee@kpn.com <soumik.bhattacharjee@kpn.com>; +Cc: pgsql-admin
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
^ permalink raw reply [nested|flat] 14+ messages in thread
* Re: Oracle to Postgres-Licensed GUI tool
2018-11-20 18:10 Oracle to Postgres-Licensed GUI tool soumik.bhattacharjee@kpn.com
2018-11-20 18:15 ` Re: Oracle to Postgres-Licensed GUI tool Paul Carlucci <paul.carlucci@gmail.com>
2018-11-20 18:18 ` RE: Oracle to Postgres-Licensed GUI tool soumik.bhattacharjee@kpn.com
2018-11-20 18:21 ` Re: Oracle to Postgres-Licensed GUI tool Paul Carlucci <paul.carlucci@gmail.com>
2018-11-22 22:15 ` Re: Oracle to Postgres-Licensed GUI tool Mark Kirkwood <mark.kirkwood@catalyst.net.nz>
2018-11-23 00:13 ` Re: Oracle to Postgres-Licensed GUI tool Pepe TD Vo <pepevo@yahoo.com>
@ 2018-11-23 00:21 ` Mark Kirkwood <mark.kirkwood@catalyst.net.nz>
0 siblings, 0 replies; 14+ messages in thread
From: Mark Kirkwood @ 2018-11-23 00:21 UTC (permalink / raw)
To: Pepe TD Vo <pepevo@yahoo.com>; Paul Carlucci <paul.carlucci@gmail.com>; soumik.bhattacharjee@kpn.com <soumik.bhattacharjee@kpn.com>; +Cc: 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).
See https://aws.amazon.com/dms/faqs/
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
> <mailto: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
> <mailto:paul.carlucci@gmail.com>>
> *Sent:* Tuesday, November 20, 2018 7:16 PM
> *To:* Bhattacharjee, Soumik <soumik.bhattacharjee@kpn.com
> <mailto:soumik.bhattacharjee@kpn.com>>
> *Cc:* pgsql-admin@postgresql.org <mailto: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
> <mailto: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
>
>
>
>
^ permalink raw reply [nested|flat] 14+ messages in thread
* Re: Oracle to Postgres-Licensed GUI tool
2018-11-20 18:10 Oracle to Postgres-Licensed GUI tool soumik.bhattacharjee@kpn.com
@ 2018-11-20 19:17 ` Thomas Kellerer <spam_eater@gmx.net>
2018-11-20 21:06 ` RE: Oracle to Postgres-Licensed GUI tool Erwin Fritz <efritz@gljpc.com>
3 siblings, 1 reply; 14+ messages in thread
From: Thomas Kellerer @ 2018-11-20 19:17 UTC (permalink / raw)
To: pgsql-admin@lists.postgresql.org
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
^ permalink raw reply [nested|flat] 14+ messages in thread
* RE: Oracle to Postgres-Licensed GUI tool
2018-11-20 18:10 Oracle to Postgres-Licensed GUI tool soumik.bhattacharjee@kpn.com
2018-11-20 19:17 ` Re: Oracle to Postgres-Licensed GUI tool Thomas Kellerer <spam_eater@gmx.net>
@ 2018-11-20 21:06 ` Erwin Fritz <efritz@gljpc.com>
0 siblings, 0 replies; 14+ messages in thread
From: Erwin Fritz @ 2018-11-20 21:06 UTC (permalink / raw)
To: pgsql-admin@lists.postgresql.org <pgsql-admin@lists.postgresql.org>
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 <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
>
Attachments:
Erwin Fritz.vcf (text/x-vcard, 359B) download
BEGIN:VCARD
VERSION:2.1
N:Fritz;Erwin;;;
ORG:GLJ Petroleum Consultants
TITLE:IS Operations Manager
EMAIL;PREF;internet:efritz@gljpc.com
TEL;VOICE;WORK:+1 (403) 266-9570
TEL;FAX;WORK:+1 (403) 262-1855
ADR;WORK;PREF;ENCODING=QUOTED-PRINTABLE:;;Suite 4100, 400 Third Ave SW;Calgary;Alberta;T2P 4H2;Canada
FN:Erwin Fritz
REV:20181120T210611Z
END:VCARD
* Re: Oracle to Postgres-Licensed GUI tool
2018-11-20 18:10 Oracle to Postgres-Licensed GUI tool soumik.bhattacharjee@kpn.com
@ 2018-11-20 19:42 ` abbas alizadeh <ramkly@yahoo.com>
2018-11-20 20:14 ` Re: Oracle to Postgres-Licensed GUI tool Pepe TD Vo <pepevo@yahoo.com>
2018-11-21 09:10 ` RE: Oracle to Postgres-Licensed GUI tool soumik.bhattacharjee@kpn.com
3 siblings, 2 replies; 14+ messages in thread
From: abbas alizadeh @ 2018-11-20 19:42 UTC (permalink / raw)
To: soumik.bhattacharjee@kpn.com; +Cc: pgsql-admin
Hi,
You can check this tools:
https://www.ispirer.com/products/oracle-to-postgresql-migration
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
^ permalink raw reply [nested|flat] 14+ messages in thread
* Re: Oracle to Postgres-Licensed GUI tool
2018-11-20 18:10 Oracle to Postgres-Licensed GUI tool soumik.bhattacharjee@kpn.com
2018-11-20 19:42 ` Re: Oracle to Postgres-Licensed GUI tool abbas alizadeh <ramkly@yahoo.com>
@ 2018-11-20 20:14 ` Pepe TD Vo <pepevo@yahoo.com>
1 sibling, 0 replies; 14+ messages in thread
From: Pepe TD Vo @ 2018-11-20 20:14 UTC (permalink / raw)
To: abbas alizadeh <ramkly@yahoo.com>; soumik.bhattacharjee@kpn.com <soumik.bhattacharjee@kpn.com>; +Cc: pgsql-admin
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:https://www.ispirer.com/products/oracle-to-postgresql-migration
Best RegardsAbbas
On Nov 20, 2018, at 9:40 PM, <soumik.bhattacharjee@kpn.com> <soumik.bhattacharjee@kpn.com> wrote:
#yiv6968699051 #yiv6968699051 -- _filtered #yiv6968699051 {font-family:Calibri;panose-1:2 15 5 2 2 2 4 3 2 4;}#yiv6968699051 #yiv6968699051 p.yiv6968699051MsoNormal, #yiv6968699051 li.yiv6968699051MsoNormal, #yiv6968699051 div.yiv6968699051MsoNormal {margin:0in;margin-bottom:.0001pt;font-size:11.0pt;font-family:sans-serif;}#yiv6968699051 a:link, #yiv6968699051 span.yiv6968699051MsoHyperlink {color:#0563C1;text-decoration:underline;}#yiv6968699051 a:visited, #yiv6968699051 span.yiv6968699051MsoHyperlinkFollowed {color:#954F72;text-decoration:underline;}#yiv6968699051 span.yiv6968699051EmailStyle17 {font-family:sans-serif;color:windowtext;}#yiv6968699051 .yiv6968699051MsoChpDefault {font-family:sans-serif;} _filtered #yiv6968699051 {margin:70.85pt 70.85pt 70.85pt 70.85pt;}#yiv6968699051 div.yiv6968699051WordSection1 {}#yiv6968699051 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
^ permalink raw reply [nested|flat] 14+ messages in thread
* RE: Oracle to Postgres-Licensed GUI tool
2018-11-20 18:10 Oracle to Postgres-Licensed GUI tool soumik.bhattacharjee@kpn.com
2018-11-20 19:42 ` Re: Oracle to Postgres-Licensed GUI tool abbas alizadeh <ramkly@yahoo.com>
@ 2018-11-21 09:10 ` soumik.bhattacharjee@kpn.com
1 sibling, 0 replies; 14+ messages in thread
From: soumik.bhattacharjee@kpn.com @ 2018-11-21 09:10 UTC (permalink / raw)
To: ramkly@yahoo.com; +Cc: pgsql-admin
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:
https://www.ispirer.com/products/oracle-to-postgresql-migration
Best Regards
Abbas
On Nov 20, 2018, at 9:40 PM, <soumik.bhattacharjee@kpn.com<mailto:soumik.bhattacharjee@kpn.com>> <soumik.bhattacharjee@kpn.com<mailto: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
^ permalink raw reply [nested|flat] 14+ messages in thread
* Re: Oracle to Postgres-Licensed GUI tool
2018-11-20 18:10 Oracle to Postgres-Licensed GUI tool soumik.bhattacharjee@kpn.com
@ 2018-11-21 09:04 ` Shreeyansh Dba <shreeyansh2014@gmail.com>
3 siblings, 0 replies; 14+ messages in thread
From: Shreeyansh Dba @ 2018-11-21 09:04 UTC (permalink / raw)
To: soumik.bhattacharjee@kpn.com; +Cc: pgsql-admin
Hi Soumik,
You can use below tools which are free and opensource.
ora2pg: is easy and extremely powerful.
http://ora2pg.darold.net/
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
<http://www.shreeyansh.com;
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
>
^ permalink raw reply [nested|flat] 14+ messages in thread
end of thread, other threads:[~2018-11-23 00:21 UTC | newest]
Thread overview: 14+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2018-11-20 18:10 Oracle to Postgres-Licensed GUI tool soumik.bhattacharjee@kpn.com
2018-11-20 18:15 ` Paul Carlucci <paul.carlucci@gmail.com>
2018-11-20 18:18 ` soumik.bhattacharjee@kpn.com
2018-11-20 18:21 ` Paul Carlucci <paul.carlucci@gmail.com>
2018-11-20 18:33 ` soumik.bhattacharjee@kpn.com
2018-11-22 22:15 ` Mark Kirkwood <mark.kirkwood@catalyst.net.nz>
2018-11-23 00:13 ` Pepe TD Vo <pepevo@yahoo.com>
2018-11-23 00:21 ` Mark Kirkwood <mark.kirkwood@catalyst.net.nz>
2018-11-20 19:17 ` Thomas Kellerer <spam_eater@gmx.net>
2018-11-20 21:06 ` Erwin Fritz <efritz@gljpc.com>
2018-11-20 19:42 ` abbas alizadeh <ramkly@yahoo.com>
2018-11-20 20:14 ` Pepe TD Vo <pepevo@yahoo.com>
2018-11-21 09:10 ` soumik.bhattacharjee@kpn.com
2018-11-21 09:04 ` Shreeyansh Dba <shreeyansh2014@gmail.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox