November 22, 2009 at 2:48 pm
We have trucks out in the field with remote devices installed and they need to send messages to the central server. Before, we had technician that manually collects this data from onboard computers but now we have wi-fi almost everywhere, so we'll implement automatic transmission. It was requested that I evaluate Service Broker.
Honestly, after reading Books Online about it twice, I still don't understand what it does...
Books Online says things like:
"Service Broker is a new technology in Microsoft SQL Server 2005 that helps database developers build secure, reliable, and scalable applications. Because Service Broker is part of the Database Engine, administration of these applications is part of the routine administration of the database."
AND
"Service Broker helps developers build asynchronous, loosely coupled applications in which independent components work together to accomplish a task. These application components exchange messages that contain the information that is required to complete the task. "
What exactly does this mean in human language? :-):-P
November 25, 2009 at 9:03 am
This may be a good resource.
November 26, 2009 at 3:57 am
emily-1119612 (11/25/2009)
http://msdn.microsoft.com/en-us/library/bb522901.aspx%5B/quote%5D
Thank you for the link, but I have no idea what all that means... anybody can tell me?
November 26, 2009 at 5:31 am
In simple language, Service Broker is a technology that can transfer your message / data .
SQL Server Service Broker offers the functionality of Asynchronous messaging. SQL Server, at its own end, checks the connectivity status (to whom it will send message / data). As soon as the client is connected, the messages are sent in the binary format. At the receiving end, the messages are processed as soon as they are received. User has not to worry about the sending and the receiving mechanism, as it just one time programming using Contracts, Queues and Services. Routes can be used if the databases are on different servers.
The SQL Server Service Broker answers all the questions in the data synchronization process complication. Following are the major advantages of the SQL Server Service Broker;
Also, on receiving the message, Message Acknowledgement is sent to the sender which makes it more reliable.
I think it should be more than enough. For detailed information, you can have plenty of information availabel here on SqlServerCentral, Microsoft and other SQL Server related websites.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply