3

Can SQL Server Data Tools (SSDT) deploy sql server broker objects? (So contacts, message types, services, queues and so on.)

1

It would appear so. I have not tried these, but the following is the list of items that can be added to an SSDT SQL Server Database Project:

  1. Broker Priority
  2. Contract
  3. Endpoint (ServiceBroker over TCP)
  4. Endpoint (SOAP over HTTP)
  5. Event Notification
  6. Message Type
  7. Queue
  8. Remote Service Binding
  9. Route
  10. Service
  • Any reason why DacPac deployment skip route changes? Any advance settings needed for SSDT/Data-Tier project? – Hi10 Aug 20 '16 at 12:18

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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