By using AWS re:Post, you agree to the Terms of Use

Replication between RDS and on premises Oracle


I am planning to build a standard three tier architecture web portal with an RDS backend. Some of the data needs to be sync'd back to my on-premise Oracle database.

I want updates from either source (the portal or the Oracle database) to sync to the other database in near real time.

I have looked at DMS, Oracle Goldengate and using a Lambda function to trigger an update.

Have you got any guidance on how to approach this problem?

1 Answer
Accepted Answer

If you have a GG license already then that would be the first choice. If not then DMS but DMS does not do two way replication so you will have to address handling replication in both directions. Other native replication options may work like looking at distributed transactions in Oracle.

Another option would be to code the app tier to update both databases.

answered 2 years ago

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions