I have multiple PostgreSQL databases running in RDS. Now, I need to move data from these multiple databases to one master database, within the same RDS instance. What options could you suggest that I should look into? I am planning to consider the following:
- Using Lambda to read data from the multiple databases and write the data back to the master database.
- I can use Data Pipelines to move the data around the places.
Anything else that I should consider for the use case?