0

I've looked through the similar questions, but they are a little further down the line, more into details already.

While I'm still researching the concept of mirroring and what can and can not be achieved.

So I wanted to ask an opinion\suggestion\direction:

  • We have a web app which is backed by an SQL DB (2014)
  • We also have remote (far..) office which uses that web app
  • The remote office uses our local HQ web server so the network delay is getting on their nerves

Ideally we would like to replicated the whole app environment (web server + db) to their region and have a "live sync" between these two environments.

Within the app itself - there is no provisioned functionality for this.

So I am looking into default SQL toolset or other 3-rd party solutions maybe which could help us set a mirror of the main DB in the remote region with live synchronization (if possible). We can survive a data replication delay (user in region 1 creates something while it gets to the region 2 within next 5 minutes).

It's fairly common situation and I want to understand if this can be achieved by SQL tools themselves or with some other 3rd party solution which will manage the replication\syncing?

closed as too broad by Marco, mustaccio, Philᵀᴹ, Shanky, Max Vernon Mar 21 '17 at 21:00

Please edit the question to limit it to a specific problem with enough detail to identify an adequate answer. Avoid asking multiple distinct questions at once. See the How to Ask page for help clarifying this question. If this question can be reworded to fit the rules in the help center, please edit the question.

1

Mirroring won't do this...its one way. You need to investigate either Transactional or Merge Replication for the two-way communication, if you want to stay in the SQL Server capabilities. merge helps if you have bad bandwidth or network drops. Both Tx and Merge have their own unique requirements that are well documented on Technet :)

Not the answer you're looking for? Browse other questions tagged or ask your own question.