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


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.

  • 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?

1 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:

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