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. Commented Feb 10, 2016 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. Commented Dec 12, 2017 at 19:30

1 Answer 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 and acknowledge you have read our privacy policy.

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