同步框架入门
我在开始使用同步框架时遇到一些问题。在研究过程中，看起来同步框架比复制或定制解决方案更适合我们的需求。
基本上，我们需要将一些数据集从我们的中央办公室与公司的每个商店保持同步，以克服糟糕的 DSL 服务和糟糕的布线所带来的缺陷。
不管怎样，我已经阅读了有关 SQL Server 与 Sync Framework 同步的 MSDN 文章，并查看了他们提供的一些示例项目，但我仍然不知道从哪里开始。
我真的很想看到我们编写的应用程序必须经历的流程概要，以向中央办公室注册、拉取初始数据集，然后保持同步。
总之，我正在寻找如何将客户端 SQL Server Express 实例与 SQL Server Enterprise 实例进行双向同步的概述。
I'm having some trouble getting started with the Sync Framework. In doing research, it looks like the Sync Framework is a better fit for what we need than replication or a custom-rolled solution.
Basically, we need to keep some datasets synced from our central office with every store in the company to overcome shortfalls with crappy DSL service and bad wiring.
Anyway, I've read through the MSDN articles on SQL Server syncing with the Sync Framework, and looked at some of the example projects they provide, and I'm still at a loss as to where to start.
I really would like to see just an outline of the process that an app we write would have to go through to register with the central office, pull down the initial dataset, and then stay synchronized.
In summary, I'm looking for an outline of how to two-way sync a client SQL Server Express instance with a SQL Server Enterprise instance.
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（2）
如果您正在寻找有关同步服务功能的介绍，那么您最好观看 Microsoft Daniel Moths 的 18 分钟介绍视频，网址为 http://channel9.msdn.com/posts/DanielMoth/ADONET-Sync-Services-v10/
您最大的问题是确保在设计您的数据库，您可以将数据分区为可以轻松同步到不同位置的部分。例如，与销售人员的联系，并且没有重叠的联系......
If you are looking for an introduction to what the sync services are capable of, you can do worse than watch Microsofts Daniel Moths 18min intro video at http://channel9.msdn.com/posts/DanielMoth/ADONET-Sync-Services-v10/
Your biggest problem is making sure, when designing your databbase, that you can partition the data into sections that can be syncronised to different locations easily. E.g. contacts to sales people and not having overlapping contacts...
您浏览过 MSDN 示例吗？例如，同步远程有一个分步示例，涵盖了几乎所有内容使用代理提供程序进行副本。
顺便说一句，对于将 SQL Server Express 数据同步到中央 EE，通过蹩脚的 DSL，您将使用 Service Broker 实际上。我知道有一些部署通过 DSL 线路在 1600 个 POS Express 实例和中央 EE 服务器之间同步数据。
Have you gone over the MSDN samples? For example there is a step by step sample that covers pretty much everything at Synchronizing a Remote Replica By Using a Proxy Provider.
Btw, for SQL Server Express data sync to central EE, over crappy DSL, you'll have much better mileage (better throughput, higher availability, much bigger scalability) using Service Broker actually. I know of deployments that sync data over DSL lines between 1600 POS Express instances and the central EE server.