SQL Server Service Broker C#应用程序 [英] Sql server service broker C# application

问题描述

我目前正在研究在不使用SQL复制服务的情况下使数据库表在两个不同服务器上保持同步的方法.我看过很多文章暗示服务经纪人是必经之路.

他们是否使用Service Broker在两个数据库之间自动同步数据的任何自定义构建C#应用程序?

我尝试过的事情:

我是服务经纪人的新手，所以我还没有创建任何东西.

I''m currently investigating ways of keeping database tables in sync on two different servers without using SQL Replication services. I''ve seen many articles suggesting that service broker is the way to go.

Are their any custom build C# applications that uses service broker to automate syncing data between two databases?

What I have tried:

I''m new to service broker, so I haven''t created anything

推荐答案

请参阅此处的CodeProject文章: https://bookdl.com/978-0672337765/ [

See CodeProject article here: SQL Server Notifications on Record Change with SignalR and SQLTableDependency[^]
You might also find this Ebook useful: https://bookdl.com/978-0672337765/[^]

这篇关于SQL Server Service Broker C#应用程序的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！