Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

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?

share|improve this question

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.

share|improve this answer
    
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 '13 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. –  Sebastian Meine Mar 29 '13 at 13:39

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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