I've migrated a On premise Oracle to Aurora Postgres on AWS RDS. my migration process is described in the below image.

I'm looking for an option to sync data from on prem oracle to aurora postgres (Something like, if one row inserted/updated in particular table, that data should come and update/insert in aurora postgres table).
Is it possible ?
Yes you'll want to use the DMS (Database Migration Service) which can do continuous data replication from source to target DB's
https://aws.amazon.com/dms/
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With