asked
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.
@Grant Fritchey♦♦ Thanks for your reply, as per now all thins you said in the answer is very much clear to me. Now imagine that there is only a single device with multiple databases i just want them to synchronize at perticular interval of time say 5 mins with the AMAZON CLOUD SERVER so what steps i should do for that. I am trying to search on net but not getting anything. Simmilar facility of synchronizing is available in Microsoft Azure with DATA SYNC tool but i want to use AWS.
So you have, let's keep it simple, 3 databases, dbA, dbB and dbC, all in AWS. Somewhere out there you also have those same three databases on a client machine. You want to synchronize changes between dbA to dbA and dbB to dbB, etc.? You still haven't said if these are RDS or VMs. If it's VMs, you have lots of choices. Replication will work. Log shipping and mirroring and availability groups are all available. You just have to set up a virtual network to get mirroring or availability groups working. The others are a little more labor. If it's RDS, most of those things listed, are, I think supported. You can check that out here:
http://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/CHAP_SQLServer.html#SQLServer.Concepts.General.FeatureSupport
@Grant Fritchey Thank you so much for answering. Yes you are right i have databases in my local pc now i want to use amazon cloud server and i wanted to replicate all my databases with the cloud via synchronization process at every few mins. so how is it possible that was my question. but i got most of my answer from your comment. Now can you please suggest me that what should i use for doing that? again Thank you so much for replying.
I see above that you're using express edition. I'm going to assume to AWS VMs, although you haven't said. In that case, you should look into log shipping. That will do what you need.https://
msdn.microsoft.com/en-us/library/ms187103.aspx I think you can do mirroring from Express, but I'm unsure about that. Look it up. You won't be able to use Availability groups.
18 People are following this question.
