在本地和远程上使用 Sync Framework 和 SQL 2008 更改跟踪
我想要的是能够使用 Microsoft Sync Framework 同步两个都使用 SQL 2008 更改跟踪功能的 SQL 2008 数据库。一个是服务器，另一个是本地 SQLExpress 实例，使用集线器和服务器。辐条模型。
有一些暗示其他人已经完成了这一点 - 即 使用 WCF 和 SQL Server 2008 通过 HTTP 同步数据库同步框架。但是，该解决方案需要“可从 MSF 的 codeplex 项目站点作为客户端同步提供程序获取 SqlExpressClientSyncProvider”。同样的 SqlExpressClientSyncProvider 在其他地方也有暗示。然而，它要么不再存在，要么隐藏得很好，无法让我尝试找到它。
我在搜索中遇到的大多数链接和建议最终都指向 MSDN 示例网站，其中有几个示例（例如这个 http://code.msdn.microsoft.com/Database-SyncSQL-Server-a9752fac)，所有这些都演示了通过自定义更改审核使用同步框架 -这给模式增加了很多可见的开销，例如逻辑删除表、触发器等。这是我想要避免的。
我很乐意提供 SqlExpressClientSyncProvider 的链接，但是，我怀疑它是为 MSF 1.0 的处理方式而构建的。如果有一种“MSF 2.1”方法可以通过 SqlProvider 类或类似的方法来执行此操作，那就太好了。
What I want is to be able to use Microsoft Sync Framework to sync two SQL 2008 databases that both use the SQL 2008 change tracking feature. One will be a server and the other will be a local SQLExpress instance, using a hub & spoke model.
There are some hints that others have accomplished this - namely Syncing SQL Server 2008 Databases over HTTP using WCF & Sync Framework. However, that solution requires "SqlExpressClientSyncProvider available from MSF's codeplex project site as Client Sync Provider". This same SqlExpressClientSyncProvider is hinted at elsewhere too. However, it either no longer exists or is hiding really well from my attempts to find it.
Most of the links and suggestions I've come across in my searching end up pointing to the MSDN samples site which has several examples (such as this one http://code.msdn.microsoft.com/Database-SyncSQL-Server-a9752fac) which all demonstrate using the sync framework via custom change auditing - which adds a lot of visible overhead to the schema such as tombstone tables, triggers, etc. This is what I want to avoid.
I'd be happy with a link to the bits for the SqlExpressClientSyncProvider, however, I suspect that it is built for the MSF 1.0 way of doing things. If there is a "MSF 2.1" way to do this via the SqlProvider classes or something along those lines, that would be great.
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
SQL Server 更改跟踪仅在较旧的脱机提供程序 (SqlCeClientSyncProvider/DbServerSyncProvider) 中受支持，该提供程序与 Visual Studio 中的本地数据库缓存项目项使用的提供程序相同。
较新的 SqlSyncProvider/SqlCeSyncProvider 使用自定义跟踪机制，需要进行大量自定义才能使其与 Sql 更改跟踪一起使用，而无需编写自己的自定义提供程序。
SqlExpressClientSyncProvider 是一个示例提供程序，已被 MS 从下载站点中取出。
这个链接仍然有一些内容： http://www.8bit.rs/blog/2009/05/debugging-sql-express-client-sync-provider/
SQL Server Change tracking is only supported in the older offline provider (SqlCeClientSyncProvider/DbServerSyncProvider) which is the same providers used by the Local Database Cache project item in Visual Studio.
the newer SqlSyncProvider/SqlCeSyncProvider uses a custom tracking mechanism and it will take a great amount of customization to get it to work with Sql Change Tracking short of writing your own custom provider.
the SqlExpressClientSyncProvider is a sample provider that has since been taken out by MS from the download site.
this link still has some bits of it though: http://www.8bit.rs/blog/2009/05/debugging-sql-express-client-sync-provider/