From: | Mark Kirkwood <mark(dot)kirkwood(at)catalyst(dot)net(dot)nz> |
---|---|
To: | Paul Carlucci <paul(dot)carlucci(at)gmail(dot)com>, soumik(dot)bhattacharjee(at)kpn(dot)com |
Cc: | pgsql-admin(at)postgresql(dot)org |
Subject: | Re: Oracle to Postgres-Licensed GUI tool |
Date: | 2018-11-22 22:15:13 |
Message-ID: | 033611ab-cab9-34d5-96ec-5c3f27794c10@catalyst.net.nz |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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(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 | Pepe TD Vo | 2018-11-23 00:13:11 | Re: Oracle to Postgres-Licensed GUI tool |
Previous Message | Rui DeSousa | 2018-11-22 18:48:04 | Re: backend proccess memory accumulates |