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 1gPz61-0002wZ-HA for pgsql-admin@arkaria.postgresql.org; Fri, 23 Nov 2018 00:13:22 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1gPz60-0000R5-Ai for pgsql-admin@arkaria.postgresql.org; Fri, 23 Nov 2018 00:13:20 +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 1gPz60-0000Qy-1S for pgsql-admin@lists.postgresql.org; Fri, 23 Nov 2018 00:13:20 +0000 Received: from sonic303-4.consmr.mail.bf2.yahoo.com ([74.6.131.43]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1gPz5v-0004yf-Ue for pgsql-admin@postgresql.org; Fri, 23 Nov 2018 00:13:19 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s2048; t=1542931994; bh=m4omRMnYliRbo/Odb0dVdNHFrDm4YNOqGDFLcPY5Ve4=; h=Date:From:Reply-To:To:Cc:In-Reply-To:References:Subject:From:Subject; b=cfWfXpw0S2xbLqQdObPF8PfPZFHBMsUQsN1Zmi3Z+Mde3KXCidl6HeHdbVWD2v8mxUQeWWJ+nWt0adq5NHRsMEiLrC6HQrOHFlcD9yrp0w1ZILpzckPTaA4+Z53D4CmllghkjA4mYzotMRfkBpo64OaUjXul1DYBpNMWQTRC4cxRqFIcEsQgLxMzlTQX+iMDdL7Y0t6Q2atvGXx0nCiF/ErFoqVwox3275IWLfmZu6w43lF38wDuINDf6tHbL7rrx/qrSCuzOogxVdz84r8oVuuJ5PiAq4HW3DMd58H7PK4/epvyrkABu/kJQa2OpVthKWPS2dm2j/zC72lwqaeqzA== X-YMail-OSG: T_ueilcVM1nd1Vd_.3M8aezh48WvF6Ds9IMWwHOJP7aKb91JDOAcEmfVyM2ONRg 2RlbONnKRmxLKpp8ad5ZcHjfUDKDs.Vf.63_aFLXDsxk_1OEzU84Y0Y1aY97n2OcZH.h7qzir4fy bt.EnxGmx.ANZRfMT8tXxAW56a2Inb1CCPvKq271zlRpJSIFHf4K7YRAgfoWezrKv2uOzfhOJCUi BIQHckOALyl0QD5AdrjvRBob7rVHldRrFvsmCCK3e0dmVana2Luk1Gsh5X9U31g3WxDE4xpmEb95 1p4SeHYyOjLp7nriRhpCr3uuZ1h3ic6O8M6XcQIa0xpeLvoeTC7xdqErlItagOlvAsfW0U2jRGAz KGlvz3bAEwQNKomIV04C11r6A67LIzXC3DYOeGjTcpZrV4jdOOv1oqNLStw4JJfXS3Bu9QKX6.lE h4ebnAoh3QVAwtBUGfAa5zPhMSTXbmSKQAP9BI7mAYb8UMt2UlBpr3lx5hqXxA4p3507WR1gI7_o cdkPzcmnsJ18Mq8GHj4CFCojBQUZdh6P4ZxwI4nX0ZUdjDvJ3FEqJVmCIfl6G96jYSTcFil_ghhZ F9eWdp1Rfth3_fYhys9JBt2ZfDV0PeH1q.Phf95TE1YaXcjDl1hwMYwqUAsQEY92R7bBMFvdGq54 cxicd2eTI600VYsKhQg0DWpQ_WTTC3tBwBfIZw03zOSS1g342t.OoqS2x.la2Dec2HbO1Id23rV2 2oR1vCatAtfdlKlVKBRdEkphRYwNXmOeknQ9E9UYaO5mEC679OdsBOeGYgnQWVSHJK3v414Z6hdt vnxj9uxyOBC2x5eoBjGZkQJNYgFSCJpUkmz0ySlPy2BmCXrxEDXodSXlyOx_Mgiq1TjiSTno5Zb1 pde7hZ536g5l11PAbRJBSE4UNTk9F794uPSi34wFcnYI4L6fSJDeew8lyF3eYYaz0diT2HWqq.1L 2zBRXdgibfSgzLWcKSfq6Hk4Wn.Uq.Rvt18WGDEfhV0SHBTqz83evfXPLdo69zbE6RqWCwZXtsAP q_LmSTqmpjiI90k0- Received: from sonic.gate.mail.ne1.yahoo.com by sonic303.consmr.mail.bf2.yahoo.com with HTTP; Fri, 23 Nov 2018 00:13:14 +0000 Date: Fri, 23 Nov 2018 00:13:11 +0000 (UTC) From: Pepe TD Vo Reply-To: Pepe TD Vo To: Mark Kirkwood , Paul Carlucci , "soumik.bhattacharjee@kpn.com" Cc: "pgsql-admin@postgresql.org" Message-ID: <968758116.4879466.1542931991150@mail.yahoo.com> In-Reply-To: <033611ab-cab9-34d5-96ec-5c3f27794c10@catalyst.net.nz> References: <2A91BEF8171A5349931391E0C721CC5305D66850@CPEMS-KPN301.KPNCNL.LOCAL> <2A91BEF8171A5349931391E0C721CC5305D66869@CPEMS-KPN301.KPNCNL.LOCAL> <033611ab-cab9-34d5-96ec-5c3f27794c10@catalyst.net.nz> Subject: Re: Oracle to Postgres-Licensed GUI tool MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_4879465_1468574263.1542931991147" X-Mailer: WebService/1.1.12729 YahooMailNeo Mozilla/5.0 (Windows NT 6.1; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/70.0.3538.102 Safari/537.36 Content-Length: 11393 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk ------=_Part_4879465_1468574263.1542931991147 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable I think you need to pay for a full license for using DMS=C2=A0Bach-Nga No one in this world is pure and perfect.=C2=A0 If you avoid people for the= ir mistakes you will be alone. So judge less, love and forgive more.To call= him a dog hardly seems to do him justice though in as much as he had four = legs, a tail, and barked, I admit he was, to all outward appearances. But t= o those who knew him well, he was a perfect gentleman (Hermione Gingold) **Live simply **Love generously **Care deeply **Speak kindly.*** Genuinely = rich *** Faithful talent *** Sharing success=20 On Thursday, November 22, 2018 5:15 PM, Mark Kirkwood wrote: =20 You can use AWS DMS (Data Migration Services) to actually more the data a= fter 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. =20 regards Mark =20 On 21/11/18 7:21 AM, Paul Carlucci wrote: =20 =20 Moving data is a completely different tool, whereasnSCT only converts and m= igrates the DDL.=20 On Tue, Nov 20, 2018, 1:18 PM =20 Sent: Tuesday, November 20, 2018 7:16 PM To: Bhattacharjee, Soumik Cc: pgsql-admin@postgresql.org Subject: Re: Oracle to Postgres-Licensed GUI tool =C2=A0 Try the AWS Sche= ma Conversion Tool, it's free and doesn't require either endpoint to be an = RDS instance. =C2=A0 On Tue, Nov 20, 2018, 1:10 PM
I think you need = to pay for a full license for using DMS
 
<= span class=3D"yiv3811552299sg">
Bach-Nga

No one in this world i= s pure and perfect.  If you avoid people for their mistakes you will b= e alone. So judge less, love and forgive more.
To = call him a dog hardly seems to do him justice though in as much as he had f= our legs, a tail, and barked, I admit he was, to all outward appearances. B= ut to those who knew him well, he was a perfect gentleman (Hermione Gingold= )

**Live simply **Lov= e generously **Care deeply **Speak kindly.
*** Genuinely r= ich *** Faithful talent *** Sharing success


On Thursday, November 22, 2018 5= :15 PM, Mark Kirkwood <mark.kirkwood@catalyst.net.nz> wrote:


You can use AWS DMS (Data M= igration 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 Carlu= cci wrote:
Moving data is a completely different = tool, whereasnSCT only converts and migrates the DDL.

On Tue, Nov 20, 2018, 1:18 PM <soumik.bhattacharj= ee@kpn.com wrote:
Okay, I was of the idea that it always needs to be RDS and there=E2=80=99s 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 Co= nversion Tool, it's free and doesn't require either endpoint to be an RDS instance.
 
On Tue, Nov 20, 201= 8, 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.<= /div>
 
+including Packages, Procedures etc..
 
+ Any idea of License costs if available.
 
 
Thanks
=20



------=_Part_4879465_1468574263.1542931991147--