Message Passing between Databases Based on Service Broker
Zhou Wei · Computer Knowledge and Technology · 2010
A management of a company would like to know the exact year of any point of the annual sales to help them plan for the future strategy.Collection of annual sales data is stored in the TotalSalesDB database.Sales transaction details are stored in the SalesDB database.In or-der to maintain sales data updated whenever the need to ensure that any orders are processed and SalesDB database is updated when the de-livery date,the total amount of money orders,should be added to the database TotalSalesDB total annual sales.In order to solve these problems,service agent is needed to achieve in the database.This article explains in detail how to accomplish these tasks through the service agent.