Re: Oracle to Postgres-Licensed GUI tool

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
>

In response to

Responses

Browse pgsql-admin by date

  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