Re: Oracle to Postgres-Licensed GUI tool

From: Mark Kirkwood <mark(dot)kirkwood(at)catalyst(dot)net(dot)nz>
To: Pepe TD Vo <pepevo(at)yahoo(dot)com>, Paul Carlucci <paul(dot)carlucci(at)gmail(dot)com>, "soumik(dot)bhattacharjee(at)kpn(dot)com" <soumik(dot)bhattacharjee(at)kpn(dot)com>
Cc: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Oracle to Postgres-Licensed GUI tool
Date: 2018-11-23 00:21:24
Message-ID: 5fa2c673-00ff-7b61-4c38-1d1a14f265a9@catalyst.net.nz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(dot)kirkwood(at)catalyst(dot)net(dot)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(dot)bhattacharjee(at)kpn(dot)com
> <mailto:soumik(dot)bhattacharjee(at)kpn(dot)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(dot)carlucci(at)gmail(dot)com
> <mailto:paul(dot)carlucci(at)gmail(dot)com>>
> *Sent:* Tuesday, November 20, 2018 7:16 PM
> *To:* Bhattacharjee, Soumik <soumik(dot)bhattacharjee(at)kpn(dot)com
> <mailto:soumik(dot)bhattacharjee(at)kpn(dot)com>>
> *Cc:* pgsql-admin(at)postgresql(dot)org <mailto:pgsql-admin(at)postgresql(dot)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(dot)bhattacharjee(at)kpn(dot)com
> <mailto:soumik(dot)bhattacharjee(at)kpn(dot)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
>
>
>
>

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Achilleas Mantzios 2018-11-23 05:20:51 Logical wal receiver (background worker) not detecting when publisher node has died
Previous Message Pepe TD Vo 2018-11-23 00:13:11 Re: Oracle to Postgres-Licensed GUI tool