From: Mark Kirkwood <mark.kirkwood@catalyst.net.nz>
To: Pepe TD Vo <pepevo@yahoo.com>
To: Paul Carlucci <paul.carlucci@gmail.com>
To: soumik.bhattacharjee@kpn.com <soumik.bhattacharjee@kpn.com>
Cc: pgsql-admin@postgresql.org <pgsql-admin@postgresql.org>
Subject: Re: Oracle to Postgres-Licensed GUI tool
Date: Fri, 23 Nov 2018 13:21:24 +1300
Message-ID: <5fa2c673-00ff-7b61-4c38-1d1a14f265a9@catalyst.net.nz> (raw)
In-Reply-To: <968758116.4879466.1542931991150@mail.yahoo.com>
References: <2A91BEF8171A5349931391E0C721CC5305D66850@CPEMS-KPN301.KPNCNL.LOCAL>
<CAKhGwmBHP4_VKMCBLmGpF2Y4mRjGVfwjQQUcDU7QVvom45H=pg@mail.gmail.com>
<2A91BEF8171A5349931391E0C721CC5305D66869@CPEMS-KPN301.KPNCNL.LOCAL>
<CAKhGwmBEvvZCgTE78vr22Pa1kie3w_anXztfrHOo88eTgvii1Q@mail.gmail.com>
<033611ab-cab9-34d5-96ec-5c3f27794c10@catalyst.net.nz>
<968758116.4879466.1542931991150@mail.yahoo.com>
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
>
>
>
>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: mark.kirkwood@catalyst.net.nz, pepevo@yahoo.com, paul.carlucci@gmail.com, soumik.bhattacharjee@kpn.com
Subject: Re: Oracle to Postgres-Licensed GUI tool
In-Reply-To: <5fa2c673-00ff-7b61-4c38-1d1a14f265a9@catalyst.net.nz>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
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