Sunday, August 22, 2010 5:27 AM
I have read through the documentation at http://msdn.microsoft.com/en-us/sync/bb887608.aspx. What I found is that Sync Framework appears to be designed to synchronize between occasionally connected applications OCAs, i.e. client-to-server and client-to-client, but not server-to-server.
What are my options if I like to synchronize two or more Sql Server 2008 Standard Editions for the purpose of scale-out and increasing availability? Please note that transactional peer-to-peer replication is not offered for Sql Server 2008 Standard Edition.
Is it advisable to build a solution using the Sync Framework two keep two or more Sql Server 2008 Standard Editions synchronized, or are there technical reasons/limitations that precludes using Sync Framework?
As a side note, I do understand that Sql Merge Replication could be used for Server-to-Server synchronization, but Sql Merge Replication is extremely difficult to configure programmatically, especially over the internet, to a point where it is unusable, besides isn't Sync Framework supposed to replace Merge Replication? Please shed some light on Sync Framework versus Sql Merge Replication and their relationship to each other. Thank you.
Sunday, August 22, 2010 4:02 PMModerator
Sync Fx supports peer-to-peer synchronization. look up the collaboration or peer-to-peer providers SqlSyncProvider.
for a quick comparison of Sync Fx vs SQL replication, check this out: http://blogs.msdn.com/b/sqlservercompact/archive/2009/11/09/merge-replication-vs-sync-services-for-compact.aspx
- Proposed As Answer by JuneTMVP, Moderator Tuesday, August 31, 2010 8:27 AM