Use of SQL Service Broker for integration of two information systems

摘要

The focus of the diploma thesis is set on Microsoft SQL Servis Broker (SB). Service Broker is part of the Microsoft Sql Server(from version 2005) and is used for data transfer between two data bases on local or remote networks or between itself. I will describe operation of SB, his alternative and usage of this tool in my project, where I used this tool. As an alternative of SB I used intermediate tables, made in SQL Server. This tool is similar to SB. For end I will demonstrate usage of SB in our IT solution. We used SB because of the gap between two databases mad by different IT enterprises.