上文：SQL Server 2008中Service Broker基礎應用（上）、SQL Server 2008中Service Broker基礎應用（下）

　　演示了在同一個SQL Server實例的不同數(shù)據(jù)庫之間實現(xiàn)Service Broker，其實，更常見的是在不同的SQL Server實例之間進行通信，本文將通過實例演示如何進行Service Broker遠程通信。

　　以下是實現(xiàn)遠程Service Broker的基本步驟：

　　一、啟用傳輸安全

　　二、啟用對話安全

　　三、創(chuàng)建路由

　　四、創(chuàng)建遠程服務綁定

　　下圖顯示的是兩個 SQL Server 實例間的 Service Broker 網絡通信的高級視圖。

　　準備工作：

/************************************************************/
------遠程Service Broker
------ 3w@live.cn
-----源服務器實例,在本例中為ap4/agroNET09
USE master
GO
-- Enable Service Broker for the database
ALTER DATABASE BookStore SET ENABLE_BROKER
GO
ALTER DATABASE BookStore SET TRUSTWORTHY ON
GO 

USE BookStore
GO
-- Create the messages
CREATE MESSAGE TYPE [//SackConsulting/SendBookOrder]
VALIDATION = WELL_FORMED_XML
GO
CREATE MESSAGE TYPE [//SackConsulting/BookOrderReceived]
VALIDATION = WELL_FORMED_XML
GO 

-- Create the contract
CREATE CONTRACT
[//SackConsulting/BookOrderContract]
( [//SackConsulting/SendBookOrder]
SENT BY INITIATOR,
[//SackConsulting/BookOrderReceived]
SENT BY TARGET
)
GO 

-- Create the queue
CREATE QUEUE BookStoreQueue
WITH STATUS=ON
GO 

-- Create the service
CREATE SERVICE [//SackConsulting/BookOrderService]
ON QUEUE dbo.BookStoreQueue
([//SackConsulting/BookOrderContract])
GO 

-----目標服務器實例,在本例中為ap2/agroNETserver
USE master
GO
IF NOT EXISTS (SELECT name
FROM sys.databases
WHERE name = 'BookDistribution')
CREATE DATABASE BookDistribution
GO 

-- Enable Service Broker for the database
ALTER DATABASE BookDistribution SET ENABLE_BROKER
GO
ALTER DATABASE BookDistribution SET TRUSTWORTHY ON
GO 

USE BookDistribution
GO
-- Create the messages
CREATE MESSAGE TYPE [//SackConsulting/SendBookOrder]
VALIDATION = WELL_FORMED_XML
GO
CREATE MESSAGE TYPE [//SackConsulting/BookOrderReceived]
VALIDATION = WELL_FORMED_XML
GO 

-- Create the contract
CREATE CONTRACT
[//SackConsulting/BookOrderContract]
( [//SackConsulting/SendBookOrder]
SENT BY INITIATOR,
[//SackConsulting/BookOrderReceived]
SENT BY TARGET
)
GO 

-- Create the queue
CREATE QUEUE BookDistributionQueue
WITH STATUS=ON
GO 

-- Create the service
CREATE SERVICE [//SackConsulting/BookDistributionService]
ON QUEUE dbo.BookDistributionQueue
([//SackConsulting/BookOrderContract])
GO        

        

        
        
      
        
it知識庫：SQL Server 2008中遠程Service Broker實現(xiàn)，轉載需保留來源！
        
鄭重聲明：本文版權歸原作者所有，轉載文章僅為傳播更多信息之目的，如作者信息標記有誤，請第一時間聯(lián)系我們修改或刪除，多謝。