I would recommend you checking AWS Database Migration Service (DMS). It can accomplish exactly what you are looking for.
Essentially you would connect both source and destination databases using endpoints and create a migration task in a DMS instance. You can even establish to maintain the destination database automatically up to date. There is also the option to use DMS Serverless which eliminates the need for you to manage another instance.
I hope this helps.
You can create a read replica of your RDS instance for the reporting server.
- asked 2 years ago
- asked 10 months ago
- AWS OFFICIALUpdated 3 years ago
- AWS OFFICIALUpdated a year ago
- EXPERTpublished 7 months ago