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
>
>
>
>
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 |