Compare data in 2 tables held in 2 different databases

271 Views Asked by At

I have an oracle db and a postgresql db. Both have a set of tables which have exactly the same definition. I want to compare the data in both these tables on an on-going basis. Are there any AWS services or open source tools available to do this comparison?

1

There are 1 best solutions below

0
On

From PostgreSQL this is a relatively easy task with Oracle FDW which will permit you to map the Oracle Table into PostgreSQL and query it directly from SQL as if it was on the cluster you're connected to.