如果使用 RMO,我应该使用推送订阅还是请求订阅?

发布于 2024-07-16 22:48:03 字数 527 浏览 2 评论 0原文

我有一个 CRUD winform 应用程序,它使用合并复制来允许“断开连接”功能。 我的问题是; 如果我以编程方式使用 RMO 进行所有初始化和同步(例如 这里)是推还是拉重要吗?

会有什么不同?

我了解两者之间的差异(请参阅此处),但似乎如果我只通过 RMO 进行交互,差异就会变得有点模糊。 如果可以的话,虽然合并复制更喜欢 Pull,但我还是想用 Push 来让 Server 首当其冲,并且更容易管理。

另外,由于我们的环境,我不需要“实时”更新。 无论哪种情况,同步都会由 UI 事件触发。

有人对这个有经验么?

谢谢!

I have a CRUD winform App that uses Merge Replication to allow "disconnected" functionality. My question is; If I am doing all initializing and synchronizing programatically with RMO (like HERE) does it matter if it is a Push or Pull?

What would be a difference?

I understand the differences between the two (see HERE) but it seems that if I am only interacting through RMO the differences become a little fuzzy. If I can it seems that, even though Pull is favored for Merge Replication, I would want to use Push to make the Server bear the brunt and easier management.

Also, due to our environment, I do not need "real-time" updates. Syncing, in either case, will be fired from a UI event.

Does anyone have any experience with this?

Thanks!

如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。

扫码二维码加入Web技术交流群

发布评论

需要 登录 才能够评论, 你可以免费 注册 一个本站的账号。

评论(1

写下不归期 2024-07-23 22:48:03

我们通过 RMO 在 20 多个偶尔连接的客户端系统上使用合并复制。 据我所知,你应该选择请求订阅。 我不知道您是否可以使其与推送订阅一起使用,但我不建议尝试。 正如您所说,客户端系统将请求同步,这符合请求订阅的定义。

第二个链接中的“使用时间”部分在这种情况下的推送建议非常明确:

  • 数据通常会按需或按计划同步,而不是
    持续不断。
  • 该出版物有大量订阅者,和/或它会太多
    资源密集型来运行所有
    经销商的代理。
  • 订阅者是自主的、离线的和/或移动的。
    订阅者将决定何时
    将连接并同步更改。
  • 最常与合并复制一起使用。

We use merge replication via RMO on 20+ client systems that are occasionally connected. As far as I know, you should go with pull subscriptions. I don't know if you could make it work with push subscriptions but I don't advise trying. As you say, the client system will be requesting the sync, which fits the definition of a pull subscription.

The "Use When" section in your second link is pretty clear in its recommendation for push in this case:

  • Data will typically be synchronized on demand or on a schedule rather than
    continuously.
  • The publication has a large number of Subscribers, and/or it would be too
    resource-intensive to run all the
    agents at the Distributor.
  • Subscribers are autonomous, disconnected, and/or mobile.
    Subscribers will determine when they
    will connect and synchronize changes.
  • Most often used with merge replication.
~没有更多了~
我们使用 Cookies 和其他技术来定制您的体验包括您的登录状态等。通过阅读我们的 隐私政策 了解更多相关信息。 单击 接受 或继续使用网站,即表示您同意使用 Cookies 和您的相关数据。
原文