Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1tcLei-00H1na-Fw for pgsql-admin@arkaria.postgresql.org; Mon, 27 Jan 2025 09:43:45 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1tcLeh-00AzsK-87 for pgsql-admin@arkaria.postgresql.org; Mon, 27 Jan 2025 09:43:43 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1tcLeg-00AzrD-7U for pgsql-admin@lists.postgresql.org; Mon, 27 Jan 2025 09:43:42 +0000 Received: from sonic306-19.consmr.mail.sg3.yahoo.com ([106.10.241.139]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1tcLeb-001lGp-2Y for pgsql-admin@lists.postgresql.org; Mon, 27 Jan 2025 09:43:41 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.co.in; s=s2048; t=1737971012; bh=c1EsaDQJKAf0KctHKc/u4xTCH9JxZ9JCKBpDImC1dZE=; h=Date:From:Reply-To:To:Cc:In-Reply-To:References:Subject:From:Subject:Reply-To; b=eay8piCcZYe5VHGyqb0MgRIBsB2IzxlnZBE4UhLxU2bDtxhXPy0m07ZBBkZjinT1DsQllhce3Dc8t69pOim8oeLiKfBQJXzuDL7LQs7Ht3oXU767eigiKvLOcMyIp86CKq6lbSQTGuzSgP3kMbzWUZLk7Cfn8nkSjVpzcR9QfaC/beEC4IQ0oWkTrHjtdVkESPK+lg9Eod2cxvrwvYL98hOm3yUu2bvtn+pZbyy/5yQPAwbjfJ8HqePPSE4DZ6g8SubmxFFsP4yVDsxuVHeCk81N18TUVUoM1PYIzt3q7wECr0YDHzTNrn897O+xcZz0M5+0papVp2zd3g1aJk3Y+A== X-SONIC-DKIM-SIGN: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s2048; t=1737971012; bh=1WXkJtjVMAU666uvzsJhZUcJCbgt/ZwsYu6n3MrQCAP=; h=X-Sonic-MF:Date:From:To:Subject:From:Subject; b=WhzFVJs8HA460u2ZTubFdgQRxryoal7Bsf+K09H9WTJ9uPJSPzGxQRojmImO3Cnv/HXvMgTybVqlwwaF0CTXTtD3NQxbrcco9q/zZN0EXT8CS1NKA793ktYLCCKcA3fg+zDNHUU0l0kN8yqd2Oeynr/DCi/qsU7v/w8bB48aLq6svWY5k+9zUCszJFZvIFZeUYOqSie1RazFxugPUny5h9tD68wsI8wRsOdwmC+H7fCx33VpUiseNdAtVjv6sGDb4cAQVNy+k/3yGQzytYM9yUpvHVDb4D9s+IrzFyAdWACiSGgoDUSrRTycvvk7gRhIG3l87WIfXK02sp7n2XpkLQ== X-YMail-OSG: jCS6o4QVM1nVf5Xl_B9GteFoet9RYrmPrrgj5SNecRvl1wchJXFZcP2C92QfBa6 6sYsO0LqZTRPo3If_lB19l8uUdWPC14AFgFb5MOKK1RtUUnQ0fRqfnMYq_Uv0JtRoeJ3DEMtvDIk IRtcckDJLdUS.NPeZoMM4TYdDJuybr2Dpyy50pSXn9xJ.Ut45wPyYn.W75aOaDzMnuoNenRCmwOW Q9ZM5imC.e7jdaVErdpodYzRktkBSGzqkKpkqEo9XXbQrqOg5xX_dddwSwpnSAZFb6kR5jTbAZ7C mJ6NbCPnljcSpjv_ODwpYavCKnA60jC9bbumSqSj_kz61GZm11UmV8Sdui7U2wcPCSrCR_yTWJb2 0ZIgkuCoiHnORUjMW6FwbUU7jwb_CVJfjM2tOLSrGS1b2t0.y2F2Jy2DxR0g0xxR4syQ.ZYGO3.x grHh_RVynBadRfgCkgh1DjUdfkrIZ0nJjNPrA.hvxdWxzshFA9ySAmTp5Infsviw1ZIoge.fJKGS 9h8A9.6dTTBnRPsYbync9MFcbvYSPSq38HtLw9ID.Xv69IYlCTnLPHaRZl8Zwa5v9g6ze4VB4jAE CEW7KOZowKs_4XuzTng3moGXF9_JsxKQ5UEwX3jscOzSMb6W1ZySPlf3vKWIL4B7EMt.HedI7xeU 8ii_QSVQater7f.1r4_rXZ8Er7mnkjLPDyfjFQW.byMO9rvqUUj9sv8W0lMH2VqQC0WCVVOJA77v TDb5mgnXgqI.aN274USRtfjaQc6YRXebUD8OiW0bnz92y45CTpCSwHzEU7CrqYZ.B4ogT2qSFpCz zy6KqTNVt0OdZaJNC6VnSvj5qOLBX8CQteySNDue7IPfkiLq34WqFttF2HIelQLBCRMLvygyNXol j6zfbv9nM9F.vLRE3vt00VvhpKPWi6lvrnbocISg8p8CPnLIocdmqhGnzoF_kRY6hv55vduVICtE sBNTNgWT8lHSDU53DvzkXVNQlYHJA.BVge9C9vQXdL7sWBGjKnHHkcC7897VGAhOP1tgjJT6ycaV EwSCJ1fCGKc8I9uk9vkJwIoscxi45xRvesMTZw9cWJJ8cDiVX_pvFD_Qc4yBrDcH6wSkW.o.W8.L pKFUfi64Boz7atMozTgy9sSV3m7_Ky0c3MeHweKIPHj24Sc1bofD4rApi.e_UVgjrjBlPtUcYOGz uINXZvqezfEXCPh00mI2HqNfTxD1ovVbsEpEZmrcqoalN5AsnYd.o18IgwgIcn9uWSv0s.7MerV. kwHz5zKWjPiAgKh_mUzW9khABWNVlsMvJ1X.I1ZiRY9jrI1t6hgZ6HyemSOWuA3eM.JJ40KN2xbs vhUeaARQEnSgI7BmfzZFDhAIb1o1qQl9M6lVYDxML57UGEqvKx6CYItiHvwtz.F4RKRnFVj9so0l dNGHQfJ_.VFPdfU09N5t6sx3GvyldbrtOC75xiD.ruRAKMY3NNZmHCNfjjOLzlNIrsFoCqkQx_Zt 91tS51THXiQTBGNDcMyC4TxhfM3_lG.x_1zJUMq72UpBBVZr3GRejzmK1ePO85ObeWWjA3zVM17r IUSEwzzjBCmgBElWVabjUIO4FodNE6LXGI2Z8W7EbZb5_3EwCHjwd440aD829Uz6zQ._c.ZTYBog 7ba8tUxD_TH.EN_aVqTKOPkvEdtf59q3TR1FOkxCbsHYrAhrZUtrip2n2EXSivWMllli5cU2Bg4r UgFDF1TK7kRCVrC7MJUTyWzJtDW_NXwOBS0jM1zmHNgds.etlq14Bd6XWetEP9OrzZrXpeu4F1kf V0VVIS7Gwhyf2OWMR0_3thTab8uTXwho9FFiOT5.2VVkPLkciRhgzLKDZ2vEOfmcS8E1Jy.5z57. 4QpGSm9d2r2YRHsMw18lSGP3.LWpPYrWrRgypMTjrGW4ymla_2vGet1Fjzouz67vi2dN02KKfM2Z 4CcZxjSlWMT9eJ5yQL4GQEsjhW4GGhoTF2zdlecofkkHf9szvf7gtkLvY4afRsHRX2luLmDUd2Cv 4A3t2QUUZh9pGpubaT8LZaQXxIwEMkJh.OkZ1prCIujCgUWRKhdV45UK.5ERqYZdnqscoT.0KiGM H0CqYIc6QeiTdVRfZamFjazLchZPCr_t_XK2dZ1HgHt98zFjQb6w8PkmV0potvQ0toh2bPghHt4t WpV1tAkB0QjNBdsjXzYb52XOWzvPe.LUYlxjarEn92PARZ1w9ZMjhJcdCps.HHbWZWx8RSKB.Hip cwRoVjmVpG7L0eJIWBvcgSCY80tjj0jnlJnFDJFXph7wGy.XuimV7azMzUmbJ_PuintFnJDvWz.o I0s6SEq__VQ4ocEfuk2E- X-Sonic-MF: X-Sonic-ID: 6eaecfd5-f018-4487-b06d-3dc320a32bf5 Received: from sonic.gate.mail.ne1.yahoo.com by sonic306.consmr.mail.sg3.yahoo.com with HTTP; Mon, 27 Jan 2025 09:43:32 +0000 Date: Mon, 27 Jan 2025 09:43:30 +0000 (UTC) From: manish yadav Reply-To: manish yadav To: Rajesh Kumar Cc: Julien Rouhaud , Pgsql-admin , Avinash Vallarapu Message-ID: <1398339741.2938733.1737971010295@mail.yahoo.com> In-Reply-To: References: Subject: Re: Oracle to postgres migration MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable X-Mailer: WebService/1.1.23187 YMailNorrin Content-Length: 1729 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk You may try EDB Migration portal (https://migration.enterprisedb.com/) =C2= =A0for migration assessment which is freely available. =C2=A0EDB MTK to be = used for data migration which is under subscription plan. Thanks and Regards, Manish Yadav On Monday 27 January, 2025 at 03:04:00 PM IST, Avinash Vallarapu wrote:=20 Hi, On Mon, Jan 27, 2025 at 3:01=E2=80=AFPM Rajesh Kumar wrote: > Size is 300gb, have lob objects. I prefer ora2pg. Does EDB MTK costs? >=20 > Mostly I need to know what are all the things I need to ask oracle people= to start withj You can also use the Ora2Pg AI Chatbot, so that you can get responses if yo= u are stuck while using Ora2Pg. https://ora2pgsupport.hexacluster.ai/ =C2=A0 >=C2=A0=C2=A0 > On Mon, 27 Jan 2025, 14:52 Julien Rouhaud, wrote: >> Hi, >>=20 >> On Mon, Jan 27, 2025 at 02:42:22PM +0530, Rajesh Kumar wrote: >>> Hi team, >>> >>> I am trying to migrate from oracle to postgres. >>> >>> I have been asked to provide an estimation for effort days. Anybody has= any >>> document related to estimation? And steps. >>> >>> Where do I start with? Anybody has any documentation related to ora2pg >>> migration ? >>=20 >> ora2pg is probably the best tool for your task.=C2=A0 And yes it does pr= ovide >> estimates for the migration efforts, see >> https://ora2pg.darold.net/documentation.html#Migration-cost-assessment. >>=20 >> In general the ora2pg documentation is really good, you should find the = answer >> to all your questions there. >>=20 >>=20 >=20 --=20 Regards, Avinash Vallarapu CEO HexaCluster (www.hexacluster.ai) Try our new Database Migration Service: www.hexarocket.com