Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

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

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 ?

like image 283
aan anna philip Avatar asked Jan 25 '26 16:01

aan anna philip


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/

like image 184
AWS Cloud Architect Rob Avatar answered Jan 27 '26 07:01

AWS Cloud Architect Rob



Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!