Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
nathans
Aged Yak Warrior
938 Posts |
 Posted - 2008-12-19 : 12:27:17
|
| I have a 3rd party application that listens on a socket port and transforms messages into XML. I need to get the XML result into a service broker queue that resides in a database on the same server.The application supports TCP and SOAP Senders. I am looking for the best performing solution and have read up on sql endpoints, though afaik HTTP endpoints are being deprecated in 2k8. Is it possible to leverage the SvcBroker endpoint itself, which is TCP as I understand. Is that endpoint type solely for Broker to Broker transport, or is it possible to receive messages direct from the app?The only other solution I see is to standup a web service in IIS and have that call a stored procedure that can do the insert to the queue, but not sure about the performance impact of that. Thanks for any help |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2009-01-04 : 08:36:37
|
| unfortunately you can't use a SB endpoint directly since it uses it's own optimized protocol based on TCP.the simplest way is to have a sproc that accepts the xml as a parameter and then it sends it to the queue.___________________________________________________________________________Causing trouble since 1980Blog: http://weblogs.sqlteam.com/mladenpSpeed up SSMS development: www.ssmstoolspack.com <- version 1.1 out! |
 |
|
|
|
|
|
App to Svc Broker Queue