使用Sync Framework for Sql Server 2008 Standard Edition服务器到服务器同步 [英] Using the Sync Framework for Sql Server 2008 Standard Edition Server-to-Server synchronization

问题描述

我已阅读http://msdn.microsoft.com/en-us/sync/bb887608.aspx上的文档。 
我发现Sync Framework似乎是为了在偶尔连接的应用程序OCAs之间进行同步，即客户端到服务器和客户端到客户端，而不是服务器到服务器。

如果我想同步两个或更多Sql Server 2008标准版以实现横向扩展和提高可用性，我有哪些选择？请注意，事务性对等复制是不适用于Sql Server 2008 Standard
Edition。  

建议使用Sync Framework构建解决方案两个是否保持两个或多个Sql Server 2008标准版同步，或者是否存在妨碍使用Sync Framework的技术原因/限制？

PS

作为旁注，我明白Sql Merge Replication可用于服务器到服务器同步，但Sql Merge Replication是以编程方式配置极其困难，特别是在互联网上，以至于它无法使用，
除了Sync Framework不应该取代合并复制？请详细介绍Sync Framework与Sql Merge Replication及其相互之间的关系。谢谢。

 

解决方案

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

这篇关于使用Sync Framework for Sql Server 2008 Standard Edition服务器到服务器同步的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！