I haven't used ora2pg yet for data validation so cannot say.
Rgds,
Sachin Pawar
On Wed, Sep 10, 2025, 6:46 AM Raj <rajeshkumar.dba09@xxxxxxxxx> wrote:
So you think ora2pg isn't enough to validate?On Wed, 10 Sept 2025, 15:58 Sachin Pawar, <getsach@xxxxxxxxx> wrote:Hi Raj,I use DVT for such purposes. https://github.com/GoogleCloudPlatform/professional-services-data-validatorPlease 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 PawarOn Wed, Sep 10, 2025 at 4:53 AM Raj <rajeshkumar.dba09@xxxxxxxxx> wrote:Hi all,What's the best way to compare schema and data integrity post oracle to postgres migrationPython or shell script that connects both dbs and compare list of all objects and tell differences?