MIME-Version: 1.0
References: 
 <CAJk5AtZT9bFNkXdWGk_W2gbg0bN06CDCAsJvJPpkADpe9=WzgQ@mail.gmail.com>
In-Reply-To: 
 <CAJk5AtZT9bFNkXdWGk_W2gbg0bN06CDCAsJvJPpkADpe9=WzgQ@mail.gmail.com>
From: Sachin Pawar <getsach@gmail.com>
Date: Wed, 10 Sep 2025 06:28:40 -0400
Message-ID: 
 <CAA_xQWr6s5hhgwsWYQJUKMtpSSnpFNCO_-pVQaasrC86-LYAWA@mail.gmail.com>
Subject: Re: Post oracle to postgres migration verification
To: Raj <rajeshkumar.dba09@gmail.com>
Cc: Pgsql-admin <pgsql-admin@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="00000000000000956b063e6fe3f7"
Archived-At: 
 <https://www.postgresql.org/message-id/CAA_xQWr6s5hhgwsWYQJUKMtpSSnpFNCO_-pVQaasrC86-LYAWA%40mail.gmail.com>
Precedence: bulk

--00000000000000956b063e6fe3f7
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

Hi Raj,
I use DVT for such purposes.
https://github.com/GoogleCloudPlatform/professional-services-data-validator
Please feel free to reach out to me in case of any query. Also do open an
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 <rajeshkumar.dba09@gmail.com> w=
rote:

> 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?
>

--00000000000000956b063e6fe3f7
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div>Hi=C2=A0Raj,</div><div>I use DVT for such purposes.=
=C2=A0<a href=3D"https://github.com/GoogleCloudPlatform/professional-servic=
es-data-validator">https://github.com/GoogleCloudPlatform/professional-serv=
ices-data-validator</a></div><div>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 s=
omething is unclear.=C2=A0</div><div><br></div><div>Rgds,</div><div><div di=
r=3D"ltr" class=3D"gmail_signature" data-smartmail=3D"gmail_signature"><div=
 dir=3D"ltr"><div>Sachin Pawar</div></div></div></div><br></div><br><div cl=
ass=3D"gmail_quote gmail_quote_container"><div dir=3D"ltr" class=3D"gmail_a=
ttr">On Wed, Sep 10, 2025 at 4:53=E2=80=AFAM Raj &lt;<a href=3D"mailto:raje=
shkumar.dba09@gmail.com">rajeshkumar.dba09@gmail.com</a>&gt; wrote:<br></di=
v><blockquote class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;borde=
r-left:1px solid rgb(204,204,204);padding-left:1ex"><div dir=3D"auto">Hi al=
l,<div dir=3D"auto"><br></div><div dir=3D"auto">What&#39;s the best way to =
compare schema and data integrity post oracle to postgres migration=C2=A0</=
div><div dir=3D"auto"><br></div><div dir=3D"auto">Python or shell script th=
at connects both dbs and compare list of all objects and tell differences?<=
/div></div>
</blockquote></div>

--00000000000000956b063e6fe3f7--