Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1gPzDy-0003Kn-Lo for pgsql-admin@arkaria.postgresql.org; Fri, 23 Nov 2018 00:21:34 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1gPzDx-0002IT-79 for pgsql-admin@arkaria.postgresql.org; Fri, 23 Nov 2018 00:21:33 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1gPzDw-0002IL-U7 for pgsql-admin@lists.postgresql.org; Fri, 23 Nov 2018 00:21:33 +0000 Received: from cat-porwal-prod-mail1.catalyst.net.nz ([2404:130:4080::4]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1gPzDr-0005Ib-K7 for pgsql-admin@postgresql.org; Fri, 23 Nov 2018 00:21:31 +0000 Received: from [IPv6:2404:130:0:1000:222:4dff:fe88:a586] (unknown [IPv6:2404:130:0:1000:222:4dff:fe88:a586]) (Authenticated sender: mark.kirkwood@catalyst.net.nz) by cat-porwal-prod-mail1.catalyst.net.nz (Postfix) with ESMTPSA id 0585680B35; Fri, 23 Nov 2018 13:21:18 +1300 (NZDT) Subject: Re: Oracle to Postgres-Licensed GUI tool To: Pepe TD Vo , Paul Carlucci , "soumik.bhattacharjee@kpn.com" Cc: "pgsql-admin@postgresql.org" References: <2A91BEF8171A5349931391E0C721CC5305D66850@CPEMS-KPN301.KPNCNL.LOCAL> <2A91BEF8171A5349931391E0C721CC5305D66869@CPEMS-KPN301.KPNCNL.LOCAL> <033611ab-cab9-34d5-96ec-5c3f27794c10@catalyst.net.nz> <968758116.4879466.1542931991150@mail.yahoo.com> From: Mark Kirkwood Openpgp: preference=signencrypt Autocrypt: addr=mark.kirkwood@catalyst.net.nz; prefer-encrypt=mutual; keydata= xsDiBEifoLIRBADnzz1YAQxN+ajn3XhoyTWmp4hHTE05y1Ai0Hf4Et6HYohOw14eFzpzgEpd nbtxbs/FDprNC1d2dJ+J67qLzwKW6k95xekMWVtBQJ+tm7W9GPQ/wSSeOiya2tUO7TnjiS4H V0U0A2v6iiNDhUBpEiLQ3/09cXdJ3QuDQPP12gRFSwCgj+y/4HHUQeuQI6KYTZ6ynHYQrK8D /jYSakbQohDv/z9Z+PC4tgKugbkSumQC3q8G99z4idl1jEIAexJi89lAjrrVq1/WqdUqh0in ptsmh5Hk6eM24hqV36dYsvcYoDm3phAPIvEVYXwU9TPeqmxy46obUYpqymWl/EtZN9lIDqwU fS1SC9naB7Z1b03aAuvEXJwAdWg6BACp6SIWWvFc6ESdzkQ/5FtvHvq1grDa95y9Dzw9MBj+ YvWSxBYJo38oqidBGhUsvAAAl5Xw82bbYIQGuw0UgYjg9z8sUapZiNp+Le+gP6DDc7Jyw51b eVKTDRjc/GH6hLINlEyWlW3jwUVEKLwZNpOcGTTgfwvPITpM8+1sqQ6egM0tTWFyayBLaXJr d29vZCA8bWFyay5raXJrd29vZEBjYXRhbHlzdC5uZXQubno+wmAEExECACAFAkifoLICGwMG CwkIBwMCBBUCCAMEFgIDAQIeAQIXgAAKCRCn/vj7UjxSJvn3AKCKsXwnda7/3zTYe01FRRnk GltvIQCcD+5qpmZ4AzvfcsFqZ1rw/reu9YXOwU0ESJ+guRAIANEGLgCM28cWn1rg28ZpY4bC xUY/DMoQMyG+3oJW5vDYOi9BYdIsH+a3mRk/ElG4r9vlWrSQQwAuDayVH30RuBJU2xHKOx2d u22W54SU7Y+fOZS8IUfffgqnKGPkPucM5eLHIiQ33kiNUl7Ho0kDli3rfe5Jyz2tZGP3FB5s 0u0v23wu7RltzgsFkxhI5kiPBBI0CVdr4w3s1gJM7id7TL8je8IOw/R+VadMn8Us9V9Hr4Yc iXhEwtkT3A9RA6ZZee3E3N09ZKjh3dxID2PMRxKPEUAuOELmVzpA77z0Sz6sZXtJgNLLvIjB iYvpZscbAGf5fjB8eBn1Kmmzow+tFy8AAwUH/ArPiMQquxtsmFUqMef5k80j66+/mDEbt9xV rz1MvXZ5NH4KVMUmgXlRN4yIOVyh/mMjiJ+DEBK/Tp4mcgQqhst2D0p/lvd3/QxtVGWts73y IAhRhWvq4jCC6Oy7IDrjRbnO0GEpumiMiT2kko1MCpXwBuJlKUxjlmlwEsKv2fbIsuGlES1u /QrLAk1ePfh5VDyKM5z+WT3GMDolrabehI8q5f0ZWPmN63Me6IM6Oqf5kYuRH0gwAauO3/bF 6NjNsQvM6lm0MbcOzSBNdH/Aru6QPbhscArMUx2opn7gkYg8wCN+Bd1Se1dQTtAcDrEBmR5i aoCbEZYkCqVAJF/C5j7CSQQYEQIACQUCSJ+guQIbDAAKCRCn/vj7UjxSJn5/AJ4hzPttJ18v gOljiFMBvwIk2HIMTQCfYMk+dS/ixjmPGZ55dk9MNuaLSYQ= Message-ID: <5fa2c673-00ff-7b61-4c38-1d1a14f265a9@catalyst.net.nz> Date: Fri, 23 Nov 2018 13:21:24 +1300 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:60.0) Gecko/20100101 Thunderbird/60.2.1 MIME-Version: 1.0 In-Reply-To: <968758116.4879466.1542931991150@mail.yahoo.com> Content-Type: multipart/alternative; boundary="------------95C4EB7A5242F19CE5B06CD5" Content-Language: en-GB List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk This is a multi-part message in MIME format. --------------95C4EB7A5242F19CE5B06CD5 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 8bit 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 > 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 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 > > *Sent:* Tuesday, November 20, 2018 7:16 PM > *To:* Bhattacharjee, Soumik > > *Cc:* 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 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 > > > > --------------95C4EB7A5242F19CE5B06CD5 Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: 8bit
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 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>
Sent: Tuesday, November 20, 2018 7:16 PM
To: Bhattacharjee, Soumik <soumik.bhattacharjee@kpn.com>
Cc: 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 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




--------------95C4EB7A5242F19CE5B06CD5--