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 1s2nIG-0069rl-Ak for pgsql-general@arkaria.postgresql.org; Fri, 03 May 2024 07:25:20 +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 1s2nIC-006whm-Ev for pgsql-general@arkaria.postgresql.org; Fri, 03 May 2024 07:25:17 +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 1s2nIB-006whe-TZ for pgsql-general@lists.postgresql.org; Fri, 03 May 2024 07:25:16 +0000 Received: from mail-lj1-x22c.google.com ([2a00:1450:4864:20::22c]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1s2nI6-001Ckn-5E for pgsql-general@lists.postgresql.org; Fri, 03 May 2024 07:25:15 +0000 Received: by mail-lj1-x22c.google.com with SMTP id 38308e7fff4ca-2e10b6e2bacso33790071fa.0 for ; Fri, 03 May 2024 00:25:09 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1714721107; x=1715325907; 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=GTwwRXd5N0h4WF9rXbAjFu2JmV7EGXGWXF1uwMz9LXI=; b=i+y72hYyucZypNGLloeyEMGxPZB0ywIcH8rJJ2A1GZW2q46yg6tDI4BVn4PunY+Euc hj89isPuNOEqF3Tab4hFgb9VXYGQQ7sVY265hVzW1RKN39VMHyPm9iBbn0FvSFl+e73S /a6eJ15podAU3RiIQIrl5sH2mBwrAd+Qcww+fJ7u2aoJrsd4BbnRZh9l9Sx4QDz+mOaq YmItAU6mJtYBgK5FEZSeF0nzzNvo6w1+uUjMBWltqxET0QKC2Q2zD5o1vN0fQiqvFCb3 Mu961oWx8ROwsBYzlwOyymwLIyUJgVYfhVrrLazZ/MS3oCaSBpiop+JZ+a5gFhP5lDbi nPpQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1714721107; x=1715325907; 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=GTwwRXd5N0h4WF9rXbAjFu2JmV7EGXGWXF1uwMz9LXI=; b=mhqWPchDp3mpy0wbWm5GLBHLBjV9rsUGOTwyMTiPuaX9XQfKmaHuoS5ZO1qMgxkrea ONOVdYmCkSApo5+O9snR6v7BJnuBCm8azF1j6MCtxgYoG9hRR7jaNXNKggPoTd2sr3BQ ylwGkAVKUapsfN4ECjB6hrs7QegKd58uHR6GjSrghBjDk/zppiUZ6dP5Kvw9A1MVtEiC FfO8FszEoN9PZkg5pBWkcHGlJx3NBIJl17e6XuuBcCkud07uWIeS+3jrWyKQyvasZMt5 Di9d/6gc46k7iNViu3gN+E9JQ2cxpS8T/nMHkApfCApBsp5Vii8IBogzuCJOtmoH3ozD /tcw== X-Gm-Message-State: AOJu0YxemiBEHhTRXV3gr0vimcHgmeJnR2HN+hGoTeMtgOykZtmziLLt ksU5iMb2CYjKeSWcYeMbrSja+7KCC+OvrRO1GBlYZjj0tVaMqPrJpTjGhJV91qOc7oJgeRo0uUg +GItV8QWlY1B4fwenDVvh2cucqz0= X-Google-Smtp-Source: AGHT+IEF8jno9FLDkzG6VNzsDooL4Iy83+OqO6FnPlRkQZ8BUGowK69J0DYDQUMz1ifeo/qcpJou7k/fquEj2cRdgIg= X-Received: by 2002:a2e:300b:0:b0:2e1:7840:a369 with SMTP id w11-20020a2e300b000000b002e17840a369mr1010430ljw.49.1714721107304; Fri, 03 May 2024 00:25:07 -0700 (PDT) MIME-Version: 1.0 References: In-Reply-To: From: Muhammad Ikram Date: Fri, 3 May 2024 12:24:50 +0500 Message-ID: Subject: Re: Ora2pg Delta Migration: Oracle to PostgreSQL To: Ron Johnson Cc: PostgreSQL General Content-Type: multipart/alternative; boundary="0000000000007d69030617879e93" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --0000000000007d69030617879e93 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable Hi, Not related to Ora2PG but in the past I have used the EDB Migration toolkit for such scenarios. Filterprops option can help in specifying filter (where clause). Regards, Ikram On Fri, May 3, 2024 at 8:12=E2=80=AFAM Ron Johnson wrote: > On Thu, May 2, 2024 at 8:28=E2=80=AFPM Amit Sharma = wrote: > >> Hello, >> >> Has anyone tried delta/incremental data migration for Oracle to >> PostgreSQL using Ora2pg? Or what are the best options to run delta >> migration for Oracle to PostgreSQL? >> > > What do the ora2pg docs say about whether or not that feature is > implemented? (It wasn't when I last used it in 2022.) > > --=20 Muhammad Ikram --0000000000007d69030617879e93 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Hi,

Not related to Ora2PG but in the pa= st I have used the EDB Migration toolkit for such scenarios. Filterprops op= tion can help in specifying filter (where clause).

Regards,
Ikram


On Fri, May 3, 2024 at 8:12= =E2=80=AFAM Ron Johnson <ronl= johnsonjr@gmail.com> wrote:
On Thu, May 2, 2024 at= 8:28=E2=80=AFPM Amit Sharma <amitpgsql@gmail.com> wrote:
Hello,

Has anyone tried delta/incremental data migrat= ion for Oracle to PostgreSQL using Ora2pg? Or what are the best options to = run delta migration for Oracle to PostgreSQL?
=
What do the ora2pg docs say about whether or not that featur= e is implemented?=C2=A0 (It wasn't when I last used it in 2022.)
<= div>=C2=A0


--
Muhammad Ikram

--0000000000007d69030617879e93--