We have a huge enterprise system, with geographically seperated SQL servers.

We have some requirements related with data replication between these servers.

We have considered the Sync Framework option, but there is a requirement regarding multiple parallel data replication. Thus, Sync framework does not seem to be an option.

Also, we do not have a central database; requirements state that user shall configure the topology and related conflict resolution steps. There are three conflict resolution options; "source wins", "destionation wins" and "timestamp based".

Also, note that, database structure is a bit complicated and we have some deep hierarchies.

Lastly, the only way of communication between these servers is using port 80; using other ports is not an option.

I need to decide how to implement the replication structure, but I do not seem to have any options other than creating a replication structure manually and implementing all features.

Do you know any tools, or have any ideas how to handle replication easily without any central SQL server and with user configurable topologies?

1 Answer 1


Almost all of your requirements can be provided by merge-replication. There is some information about it in my StairWay series here: http://www.sqlservercentral.com/stairway/72401/

Those articles don't cover replication using port 80 but that is possible.

However, the topology is always a tree. You have one root and the data is distributed through there. A real "distributed agents" topology, where each note can synch with each other node is not possible with the build in tools.

  • thanks for the answer. But I think the main problem is that there is no root in the topology. Requirements state that admin user shall configure the topology. So, I think there is no tool available for configuring such a topology.
    – daryal
    Mar 29, 2013 at 7:48
  • could you add a "hidden" root? one that is there but that is not visible to the admin? A sync between two nodes A & B would then automatically have to be translated under the covers into a sync of A with the root, a sync of B with the root and another one of A with the root. Mar 29, 2013 at 13:39

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.