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 1tcLV1-00H0mP-PN for pgsql-admin@arkaria.postgresql.org; Mon, 27 Jan 2025 09:33:44 +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 1tcLV0-00AshE-SO for pgsql-admin@arkaria.postgresql.org; Mon, 27 Jan 2025 09:33:42 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1tcLV0-00Ash5-HQ for pgsql-admin@lists.postgresql.org; Mon, 27 Jan 2025 09:33:42 +0000 Received: from mail-qv1-xf33.google.com ([2607:f8b0:4864:20::f33]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1tcLUy-001jnO-0k for pgsql-admin@lists.postgresql.org; Mon, 27 Jan 2025 09:33:41 +0000 Received: by mail-qv1-xf33.google.com with SMTP id 6a1803df08f44-6dd5c544813so44701476d6.1 for ; Mon, 27 Jan 2025 01:33:40 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1737970420; x=1738575220; darn=lists.postgresql.org; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:from:to:cc:subject:date:message-id:reply-to; bh=rfT2ijo5Q4vt0AAOx8lASsugHp3a9OZtNFg7cznpG6E=; b=dwldsOiV0e77OQlGtsB5fsoJUAd8IFCAMvgro+RJKIr+eLwYS/Gz7lguFxS5c11OEr Eae+uAlJgPwFVRh4o8QILjpGRoV2ykTAllQP9ztCdLQIjDeVF7ak7GCdOe8LZVcAW+io FT85TZoG+Za1VDgb0HQ9vpR6uOtUE/x8xddNb85940R6P4zOVq5uArKtScfEMqhr7q8K ZNWJV3N5hGLPd1vLZHUlOrWCAKJGp3T9hRURDY202b/ytflfhodeRRryF3+cz/c8nomS UQqzPpnBua2d2p1VQL9ExQSLSQAJdfuEi16JFrg7HKkNXoeh5QdU1snw5rLLlLmCZyVf szaw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1737970420; x=1738575220; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:x-gm-message-state:from:to:cc:subject:date:message-id :reply-to; bh=rfT2ijo5Q4vt0AAOx8lASsugHp3a9OZtNFg7cznpG6E=; b=YWqe2NhVqjnv6XyhY/15tdNB96uGRlqluOzA+RMFUKgaKjeNhfZpNogCOdoREjmcmt znCXtJ8XamDTxh357mgvQU8chYZcMgNN+Z0i8BWk5cGYMqxnETadlchnYagTnpsNca3A 5vZOPaN+ThLIo6Jx1YvpN9YZhGGIhF/wRq41vQL2O4Z17wYj8biilyei7nhOLTkinnwR 9P9/n3op9cmG/wVGnTjxs87Iq/rQOI6arAuPjy3dOgCttPXa+4zcpCD6LFZMiSu1dMTw 7/Gt8/gQ4DVIOtsThwSrHLmW1FdWwOuGFa4HS6k0IZACF+L4Pe6KR11LaSeEiK+9b1D9 km8Q== X-Forwarded-Encrypted: i=1; AJvYcCXrG4ec7Zwy46/lIr61RoU4ms/twJbCVGc8RLpWcVPEfAKeF2oU/LJhWEoL+xZtfCTsc0mq8v7e5iPHZQ==@lists.postgresql.org X-Gm-Message-State: AOJu0YzebyPZekdttICVMSKISopHg3/1ndl9Aym/Ye5dbe8U0v+wCpt4 k1ZChW+HeVQ5bcs18bAm2oK8JA9Mquh1+RmL7NZO7zZcFIJMiFn4LcR8jBCUhkuEUHJ58cvnxzx Nwz1nT4L35YSeHw3AEkiTNrJ6tyw= X-Gm-Gg: ASbGncspHvVL+RNGR/06xW5vBiuHrADKlrihKByHN2VNXETrcYOuN7EeFdPLBXiqZsG NlcDadpVDfSqiVWQnAcTeBST5UMnxzhJSJ+S4K/FgrReRhbM967Aw+X9PYUoeIw== X-Google-Smtp-Source: AGHT+IF69u50OZZiBt4gQayR7fO88C1+/FdWuIgjbt6xkz/fQOYpNkClQ+Ryu3OxfMHvNPtt/kdGA/N7A+2ue0R3vgQ= X-Received: by 2002:ad4:5c63:0:b0:6d8:7ed4:3367 with SMTP id 6a1803df08f44-6e1b218f0b9mr722959146d6.19.1737970419744; Mon, 27 Jan 2025 01:33:39 -0800 (PST) MIME-Version: 1.0 References: In-Reply-To: From: Avinash Vallarapu Date: Mon, 27 Jan 2025 15:03:28 +0530 X-Gm-Features: AWEUYZn2qi1T6oPsUvlNV2uk3cSlVFf07v9nMMEWQXUT1HmHVbmgj8TpTcQESdg Message-ID: Subject: Re: Oracle to postgres migration To: Rajesh Kumar Cc: Julien Rouhaud , Pgsql-admin Content-Type: multipart/alternative; boundary="0000000000007fc3e9062cacc5f9" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --0000000000007fc3e9062cacc5f9 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable 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? > > 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 you are stuck while using Ora2Pg. https://ora2pgsupport.hexacluster.ai/ > > On Mon, 27 Jan 2025, 14:52 Julien Rouhaud, wrote: > >> Hi, >> >> 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 ha= s >> any >> > document related to estimation? And steps. >> > >> > Where do I start with? Anybody has any documentation related to ora2pg >> > migration ? >> >> ora2pg is probably the best tool for your task. And yes it does provide >> estimates for the migration efforts, see >> https://ora2pg.darold.net/documentation.html#Migration-cost-assessment. >> >> In general the ora2pg documentation is really good, you should find the >> answer >> to all your questions there. >> > --=20 Regards, Avinash Vallarapu CEO HexaCluster (www.hexacluster.ai) Try our new Database Migration Service: www.hexarocket.com --0000000000007fc3e9062cacc5f9 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Hi,

On Mon, Jan 27, 2025 at 3:01= =E2=80=AFPM Rajesh Kumar <rajeshkumar.dba09@gmail.com> wrote:

Size is 300gb, have lob objects.= I prefer ora2pg. Does EDB MTK costs?

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 you are stuck while using Ora2Pg= .



=C2=A0

On Mon= , 27 Jan 2025, 14:52 Julien Rouhaud, <rjuju123@gmail.com> wrote:
Hi,

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 ha= s any
> document related to estimation? And steps.
>
> Where do I start with? Anybody has any documentation related to ora2pg=
> migration ?

ora2pg is probably the best tool for your task.=C2=A0 And yes it does provi= de
estimates for the migration efforts, see
https://ora2pg.daro= ld.net/documentation.html#Migration-cost-assessment.

In general the ora2pg documentation is really good, you should find the ans= wer
to all your questions there.


--
Regards,
Avinash Vallarapu
CEO=
HexaCluster (www.hexaclust= er.ai)
Try our new Database Migration Service: www.hexarocket.com
--0000000000007fc3e9062cacc5f9--