want database synchronization of few tables from AWS Prod to AWS UAT DataBase

Question

I have AWS DB of Production and AWS DB of UAT environment. I want whenever needed I can get Production data of few tables to my UAT Database by clicking button from GUI. So GUI means we will design one GUI and we put one button there and whenever user need just click that button and using some DMS API's (not sure) selected tables data from Production get synchronized in UAT database.

Tasio EXPERT
2 years ago
A few questions: Do you want to copy an entire table to the target database just once or have replication on an ongoing basis? Does the target database have the same schema as the source?

Answer

AWS DMS service provides Command-Line Interface(CLI), API, and SDK for python, you may choose based on your requirement.

Here links for documentation for your reference:
* CLI : https://awscli.amazonaws.com/v2/documentation/api/latest/reference/dms/index.html
* Python SDK: https://aws.amazon.com/sdk-for-python/
* API: https://docs.aws.amazon.com/dms/latest/APIReference/Welcome.html

want database synchronization of few tables from AWS Prod to AWS UAT DataBase

Relevant content