且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

使用Sync Framework for Sql Server 2008 Standard Edition服务器到服务器同步

更新时间:2022-11-12 20:32:39

Sync Fx支持点对点同步。查找协作或点对点提供程序SqlSyncProvider。


以快速比较Sync Fx与SQL复制,请查看:
http://blogs.msdn.com/b/ sqlservercompact /存档/ 2009/11/09 /合并复制-VS同步服务换compact.aspx


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?

P.S.

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.

 

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