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 1tcLDg-00GyzV-QV for pgsql-admin@arkaria.postgresql.org; Mon, 27 Jan 2025 09:15:49 +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 1tcLDf-00AXrB-IO for pgsql-admin@arkaria.postgresql.org; Mon, 27 Jan 2025 09:15:47 +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 1tcLDf-00AXr2-7T for pgsql-admin@lists.postgresql.org; Mon, 27 Jan 2025 09:15:47 +0000 Received: from mail-vs1-xe29.google.com ([2607:f8b0:4864:20::e29]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1tcLDc-001l17-04 for pgsql-admin@lists.postgresql.org; Mon, 27 Jan 2025 09:15:46 +0000 Received: by mail-vs1-xe29.google.com with SMTP id ada2fe7eead31-4b68cb2abacso810349137.3 for ; Mon, 27 Jan 2025 01:15:44 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1737969342; x=1738574142; 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=jN0u7U10jxbZqcNZqkI0vyiaw0hDsUuuG+DA+8NuyPE=; b=Zdy3gvDhJl5KSRn7+vv+Htj4QbxQLblj6N29WKqJ7B5QfhPSESRYNMO5Xdqh9kEfTw gI2PqXcI7N3IJ/gr5vur2QMrFMu2B9tViLY3KTJoW9YUBAfuKonIuIhToCdhi7rO2Vf8 TZLYdwR+wa+Xmaps9y3vdGIo8+Z5OoF36bC2N10GbyPaC8dRntmpRXHv90I1ADwanrai P3lkbPp7C1DwVkOYznXCoI2N7qtFwBpJQdl/9sW4Gxjrz7c/IHQrX40tDAmiscCiFuSH UyrzRjfj/fuinJGbFxtEBWR6VPXYO9UqNSM1AIWXoMIm7yFETUZ4m8ag0gWinuFeRngr UAsQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1737969342; x=1738574142; 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=jN0u7U10jxbZqcNZqkI0vyiaw0hDsUuuG+DA+8NuyPE=; b=pz8siqrLc+TFtEwBJRFf8I/FkFk85DHwjJ8F0hEH5I+k64znSyV/2kRfx6uI3lgr65 8NCxHQthB8QtumtibpOWqjE+Mgum5OtuQCeA4f281t3v0/8h98veKU6IKzgxHyoX24+c IjRkDUDCcpi/lprrqVxAJJ5Uo5KgXDvCxvlNiur6T7JVQH0saAej9D+xI++XfjtRWUGR mzcMNJHg/k0nptlUpc8DpsqvI4+qKs9+WSeJ0ZW9Na0BA4jglW6NRd9gXDTpIjBCZJ1t vldjIzcV0CqEDcu+w9KC18Vs00RkwqQ8gwbRzZ4sUk968DgFm/lwoVaHzH6dbcB6cnjJ icqw== X-Gm-Message-State: AOJu0YzFy8mecm7CYq7eCc29GW7v7AcO81/bRc1lQrdl5Y3xmN/aT+3e aEHFA1GRGIjKUqRfHwgYO3d5sbnlTo1b4jsLxijeg3Y1fBhG3jCbZNoIIxmS1vEChh4BdD3U3v1 HegrWRf9wdHL0jnVBljcwdpFglHU= X-Gm-Gg: ASbGncsUdtY3KAejdi+8Ju1rWQtI5McopZh9Ll/e9eO6oCWh+XChgg/EzL1yd6ptj9X 5mySo1VyYujKmEe4OHVgrUEFiSuqB83mphKpPtO04l3MBiqrrwy7FVl9RcekQkA== X-Google-Smtp-Source: AGHT+IGfhmr+aqa5aj025acoH8pVtyiiHSf49lJKjR1q6RgFdLEW/Z85mFYbiqB62ahb5YL61iMFI/I1SrONiuh1eoc= X-Received: by 2002:a05:6102:50a5:b0:4a3:ab95:9637 with SMTP id ada2fe7eead31-4b690bf62ecmr33055671137.12.1737969342137; Mon, 27 Jan 2025 01:15:42 -0800 (PST) MIME-Version: 1.0 References: In-Reply-To: From: Kashif Zeeshan Date: Mon, 27 Jan 2025 14:15:31 +0500 X-Gm-Features: AWEUYZlPMzGYJ6wZxWtZIxMA8hR6hVuq2cbiCnfJf7YPJcqVuFgJ26OWuJijDRU Message-ID: Subject: Re: Oracle to postgres migration To: Rajesh Kumar Cc: Pgsql-admin Content-Type: multipart/alternative; boundary="00000000000044cd09062cac851d" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --00000000000044cd09062cac851d Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable Hi Rajesh You can use EDB's Migration ToolKit (MTK) and following is the link to the documentation. https://www.enterprisedb.com/docs/migration_toolkit/latest/ On Mon, Jan 27, 2025 at 2:12=E2=80=AFPM 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. > The time depends on the size of the data needed to migrate. Thanks Kashif Zeeshan > > Where do I start with? Anybody has any documentation related to ora2pg > migration ? > > A little help is appreciated > --00000000000044cd09062cac851d Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Hi Rajesh

You can use = EDB's Migration ToolKit (MTK) and following=C2=A0is the link to the doc= umentation.



On Mon, Jan 27, 2025 at 2:12=E2=80=AFPM Rajesh Kumar <rajeshkumar.dba09@gmail.com> wrote:
Hi team,

I am trying to migra= te from oracle to postgres.=C2=A0

I have been asked to provide an estimation for effort days. Anybo= dy has any document related to estimation? And steps.

The time depends on the size of the data needed to m= igrate.

Thanks
Kashif Zeeshan
= =C2=A0

Where do I start with? A= nybody has any documentation related to ora2pg migration ?

A little help is appreciated=C2=A0
=
--00000000000044cd09062cac851d--