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 1uwIql-009JI4-9H for pgsql-admin@arkaria.postgresql.org; Wed, 10 Sep 2025 11:18:56 +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 1uwIqj-000qKl-TB for pgsql-admin@arkaria.postgresql.org; Wed, 10 Sep 2025 11:18:54 +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 1uwIqj-000qKd-Fd for pgsql-admin@lists.postgresql.org; Wed, 10 Sep 2025 11:18:53 +0000 Received: from mail-yb1-xb2c.google.com ([2607:f8b0:4864:20::b2c]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1uwIqi-001eXO-0W for pgsql-admin@lists.postgresql.org; Wed, 10 Sep 2025 11:18:53 +0000 Received: by mail-yb1-xb2c.google.com with SMTP id 3f1490d57ef6-e94d678e116so6736101276.2 for ; Wed, 10 Sep 2025 04:18:51 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1757503131; x=1758107931; 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=H4eRH4xs/G0WO6z/QTZyneEoAj8fW8bzsAT/mfWAveI=; b=lqwbNjS2KkmmmY27PTFW62FGfxqjuaqS4eLzzYbHpXLoc9Rv/G8r8oeqRaPEdCzvMX wK6dWfiprBzY5WCoEiHiZpOgReGUa12ntlPX/CdqTCPeYlYUIuPJYN1+yaz9M7kVIZ5O WM7knn1VbLFFeDcs+QtM0YApf4HQbGmKj+PizsdZdp4RJU55jsD59s4UOtQTBmJrvFeZ m1Zk4h4aqFThgVoc2deuMVN7hYwRAWPCQ1nGOVKc9vXVkvVq2nSq0XxLpBzVpzaBHm0h 1BdV0XZWnX2RPckjpfPbH5kAfCWFxTMZEtM4UDhyr1N/nNHBiwI/WhpNa6xEIAEU6h6r c9zg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1757503131; x=1758107931; 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=H4eRH4xs/G0WO6z/QTZyneEoAj8fW8bzsAT/mfWAveI=; b=kAS95xLc8N4DXFJXQYuY1ADxX6rzhFnWDbAtEPo3LtJ3vRKusa0c73RmtSXgdy7SgD VY8WXN7YEs2tWzPKQLxSVSR/5CThkAcVA068nrw0kE0jciKu81YyZdOjv2Yr8Qj3JTyc EHt64IjZW90FrQttV/t6m/Tl/NMJeypfJeZgDH0bKJ0l6qqgFoEEgHOuW116x3Uu9U78 HruB/31mGa9A9/kT5mUgRzI5pvd/AthXyYEATEol5Q+LtAEnrsLO8YoGjZ9Z3tOaPza0 0prEH0yoZydVJ8eBabEB3T2PBlSJ89yoCrFisnItSf6zLwMAvcH87oIsR+kZb9YyPdF0 /bow== X-Gm-Message-State: AOJu0YwHKyhkHZAmgXB0r/Io5sJGkkcsLGgjWg1IuDTUoCCG7KIZUNJZ nVGFbdfdEcMiEv0/6wt64nl5s/P6M4mLw/9QPkTXD5r+Sv63lK7W3vwcQxnOz9TGzASQoBtnZO0 79h4NcSX/ljDMnhAWOsQIkgxO1ptvnd8= X-Gm-Gg: ASbGncucaJUrsq9KcDZX6jCh0Lza69R610kDrXb6pJWCZcsgZtw6ICraAd/ASSaOqeh MwVUT8VRIZzlAAydKXKD3Ta/vwIIbve4NCS7sfn7m24jVgeViLMpSC48r8eN/LpRik6QZdoaYIr G8Nsv3l5onwIVatngk7FW/oa1UG5JBjEOBjetXxmgy05OZc+4vm0Qks+Ou3v3GuoxumcGef+5rV dHuHfra1JOtZDASjc5o3+M8LFJr0zOjl8i794QTxRbyuZ+Jtr7F7d5WHupVNTbdZKcbyV4DnXPA +Bq5mHs1 X-Google-Smtp-Source: AGHT+IFzwdD+pPjOUwhflzhV+cWf139v6Ovsl3+4Fbv+HJJBscw2L9wYRuiwzy0WxFgY7YaHbdm4YyQC2kwPKPkpLV4= X-Received: by 2002:a05:6902:2089:b0:e97:fef:d528 with SMTP id 3f1490d57ef6-e9f662ec939mr14011228276.23.1757503131011; Wed, 10 Sep 2025 04:18:51 -0700 (PDT) MIME-Version: 1.0 References: In-Reply-To: From: Sachin Pawar Date: Wed, 10 Sep 2025 07:18:39 -0400 X-Gm-Features: Ac12FXxDvKzAz4UCpXQA5clDSL2Q3uGTy23N7xIsKqMgr2lrCHifaXPHdfLFAxM Message-ID: Subject: Re: Post oracle to postgres migration verification To: Raj Cc: Pgsql-admin Content-Type: multipart/alternative; boundary="000000000000d0d0dd063e7095a4" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --000000000000d0d0dd063e7095a4 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable I haven't used ora2pg yet for data validation so cannot say. Rgds, Sachin Pawar On Wed, Sep 10, 2025, 6:46=E2=80=AFAM Raj wro= te: > So you think ora2pg isn't enough to validate? > > On Wed, 10 Sept 2025, 15:58 Sachin Pawar, wrote: > >> Hi Raj, >> I use DVT for such purposes. >> https://github.com/GoogleCloudPlatform/professional-services-data-valida= tor >> Please feel free to reach out to me in case of any query. Also do open a= n >> issue if you run into any issues or something is unclear. >> >> Rgds, >> Sachin Pawar >> >> >> On Wed, Sep 10, 2025 at 4:53=E2=80=AFAM Raj wrote: >> >>> Hi all, >>> >>> What's the best way to compare schema and data integrity post oracle to >>> postgres migration >>> >>> Python or shell script that connects both dbs and compare list of all >>> objects and tell differences? >>> >> --000000000000d0d0dd063e7095a4 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
I haven't used ora2pg yet for data validation so= cannot say.=C2=A0


Rgds,
Sachi= n Pawar

On Wed, Sep 10, 2025, 6:46= =E2=80=AFAM Raj <rajeshku= mar.dba09@gmail.com> wrote:
=
=C2=A0So you think ora2pg isn't enough to validate?
On= Wed, 10 Sept 2025, 15:58 Sachin Pawar, <getsach@gmail.com> wrote:=
Hi=C2=A0Raj,=
Please feel free to reach out= to me in=C2=A0case of any query. Also do open an issue if you run into any= issues or something is unclear.=C2=A0

Rgds,
=
Sachin Pawar


On We= d, Sep 10, 2025 at 4:53=E2=80=AFAM Raj <rajeshkumar.= dba09@gmail.com> wrote:
Hi all,

What's the best way to compare schema and data integrity pos= t oracle to postgres migration=C2=A0

Python or shell script that connects both dbs and compare list= of all objects and tell differences?
--000000000000d0d0dd063e7095a4--