Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

We want to use SQL Express at our local sites but to still be able to push data back to our head office using the Service Broker. SQL Server at the head office is 2008 R2 Standard.

Looking at the feature lists of SQL Express 2008 R2 for Express it says "Client Only", what does this mean in relation to our needs?

share|improve this question
    
Did you try it? –  Aaron Bertrand Apr 20 '12 at 14:11
    
No, I haven't tried it yet; was hoping for a quick answer here. It was a Friday afternoon idea to see if we could give our local sites more control on the cheap after looking at the SQL 2012 license cost –  best Apr 20 '12 at 16:06

1 Answer 1

up vote 3 down vote accepted

The 'client only' means that two Express instances cannot communicate directly. They have to have a Standard instance in between acting as a forwarder. Express instances can both generate and consume messages.

  • Messages originating on Express instances can be received on Standard or higher instances.
  • Messages originating on Standard or higher instance can be received on Express
  • Messages originating on Expres can be received on another Express instance only if it was routed to an intermediate Standard or higher instance using a forwarding endpoint, see Service Broker Message Forwarding. A single Standard instance can act as a forwarder to any numer of Express instances, limited only by processing capacity and network bandwidth.
share|improve this answer
    
Excellent, this is what I was hoping for. Now I can spend time on a POC for management –  best Apr 20 '12 at 16:08

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.