Have Geek Brain

Monologue Conversations in SQL Service Broker 2008

I have a scenario where I need to process (in SQL Server) messages that are delivered as .xml files to a folder in real time.

I started researching SQL Service Broker for my queuing needs. Basically, I want Service Broker to pick up my .xml files and queue them as they arrive in the folder. But SQL Service Broker does not support Monologue conversations, at least not in the current release. It only supports dialogue between the initiator and the target service.

I can use MSMQ, but then I have two things to maintain - .Net code to handle files in MSMQ and SQL Server T-SQL stored processes. What options do I still have?

Thanks.

+2


a source to share


2 answers


You want to use FileSystemWatcher to keep track of the directory. Your implementation can simply react to new files and use the file queue event (which Service Broker can implement if it makes your life better).

As other posters have pointed out, you do have things back: Service Broker responds to messages; someone needs to post a message to respond. This is not a shared host process. Depending on the feature set and scaling / scaling requirements, you might want to take a look at BizTalk as it is a very common pattern implemented with it and it has TONS infrastructure to support all the orthogonal "business component costs" to make the thing be reliable and actually work.



Once you finish writing or debugging all the necessary codes yourself, you will often find that you spent more than $ on the cost of licenses. Again, it's all about the requirements.

+1


a source


Absent. The whole idea you have is broken - since you have to pick up files from the directory, using a service broker just doesn't make sense to start. You need a listening process, so you can handle the listening process as well.



0


a source






More articles:


All Articles