Is there any way to sync on premise oracle table data to a table in Aurora postgres RDS?

user_10159710 0
Viewed 414

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

enter image description here

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 ?

database-migration amazon-rds amazon-web-services postgresql oracle
1 Answers

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/

user_20626910
Related