1

I would like to create database replication between multiple localisation. There will be one publisher and multiple subscribers. Is it possible to define that synchronisation is synchronous only for one subscriber and for the other is asynchronous operation. Is it possible to dynamically modify which subscriber will get data synchronously? Are there any external tools allowing to do that?

  • one publisher and multiple subscribers . The SQL Server can be an instance of SQL Server running on-premises or an instance of SQL Server running in an Azure virtual machine in the cloud. Through transactional replication, It is possible. – Md Haidar Ali Khan Feb 10 '16 at 10:01
  • Have you considered going SYNC read only AG on the SYNC note, then regular async replication? I've never seen replication support sync mode, there's too much lag and delay with all the agents. – Ali Razeghi Dec 12 '17 at 19:30
1

SQL Server supports Transactional, Snapshot and Merge replication. They are inherently asynchronous.

Mirroring on the other hand does support synchronous/asynchronous commit however you can only mirror one database to one other location.

SQL Server doesn't support what you are looking for. I'm not aware of any other tools which would enable this either.

The closest thing to what you are talking about is AlwaysOn, which I believe in SQL Server 2014/2016 supports multiple asynchronous/synchronous replicas.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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