上文：SQL Server 2008中Service Broker基礎(chǔ)應(yīng)用（上）、SQL Server 2008中Service Broker基礎(chǔ)應(yīng)用（下）

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

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

　　一、啟用傳輸安全

　　二、啟用對(duì)話安全

　　三、創(chuàng)建路由

　　四、創(chuàng)建遠(yuǎn)程服務(wù)綁定

　　下圖顯示的是兩個(gè) SQL Server 實(shí)例間的 Service Broker 網(wǎng)絡(luò)通信的高級(jí)視圖。

　　準(zhǔn)備工作：

/************************************************************/
------遠(yuǎn)程Service Broker
------ 3w@live.cn
-----源服務(wù)器實(shí)例,在本例中為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 

-----目標(biāo)服務(wù)器實(shí)例,在本例中為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知識(shí)庫(kù)：SQL Server 2008中遠(yuǎn)程Service Broker實(shí)現(xiàn)，轉(zhuǎn)載需保留來(lái)源！
        
鄭重聲明：本文版權(quán)歸原作者所有，轉(zhuǎn)載文章僅為傳播更多信息之目的，如作者信息標(biāo)記有誤，請(qǐng)第一時(shí)間聯(lián)系我們修改或刪除，多謝。