How do i Synchronize local MSSQL database with amazon cloud server(AWS)?
I need to synchronize between local database with amazon cloud server. I have a till system application which is used among many devices now i want to make one central database in AWS and synchronize it with local device database so that all my data is up to date and i have a secure copy available at AWS so that all other devices can get every other's updated database. I want the steps and settings to do on AWS side to perform the above given query. what should i do?
First, and most important, this is not going to be "a query." You're talking about setting up multiple services to ensure that multiple different databases are synchronized. Next, this issue is not one that AWS technology will hurt or help. It's down to how you're designing and maintaining your databases. You're talking about having multiple independent systems that can, I assume, add/edit/delete data. Then, the collection of edits from one of those systems gets moved into the main server. First, what happens when two independent systems edit the same row? Do you have a way to uniquely identify a given row to a given independent system? You have to go through all these decision points and figure out how you're doing to deal with them, all independently from your AWS system. In fact, the AWS aspect of this will probably be the least painful and easiest to deal with. You're focused on the wrong problem. It's the data and data management you need to focus on, not the communication mechanisms.