4

I'm planning a project to upgrade internally-developed app from SQL Server 2005 to SQL Server 2012. I hope to use Service Broker as a bridge while in transition. Are there any issues to consider in a forward-compatibility scenario like this other than newer features like multicasting not being present? I can't find anything in BOL specifically about compatibility.

  • What do you mean "use Service Broker as a bridge"? – Aaron Bertrand Jan 15 '15 at 18:01
  • Shimming in some triggers to catch DDL and sending the changes to the new system. We're changing several layers of the app stack at the same time- OS, SQL Version and Schema. The new system is under development and is planned to receive inputs via Service Broker anyway. During development, I would like send copies of incoming operational events to the 2012 instance to simulate production load. – Jeff Sacksteder Jan 15 '15 at 20:57
  • So your triggers would be passing data to stored procedures on the new system, which happen to involve service broker on the new system. Not sure how service broker on 2005 is involved. – Aaron Bertrand Jan 15 '15 at 21:00
  • FWIW, I ran through the 2008R2 tutorial and it seems to work, though I had to grant some endpoint connect rights on the 2012 side. Bi-directional communication seems to work for simple cases, at least. I'll begin the implemetation and see what happens. I'd feel better I there was some sort of document stating the interop behaviour. BOL seems to have an attitude of "no major changes- should work...". – Jeff Sacksteder Jan 15 '15 at 21:03
  • 1
    Is Service Broker in SQL Server 2008/2012/2014 compatible with the one in SQL Server 2005?. the answer is that they are compatible, actually they cannot be told apart. – Remus Rusanu Jan 19 '15 at 15:40
3

The answer is yes, you can do cross SQL Server versions service broker as long as all instances are 2005 or newer, and only one of the instances can be SQL Server Express Edition.

Here are some helpful links: http://blogs.msdn.com/b/stuartpa/archive/2005/07/25/443229.aspx http://msdn.microsoft.com/en-us/library/bb839483(v=sql.105).aspx

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.