patternsqlMinor
SQL Server Service Broker Compatability across versions?
Viewed 0 times
compatabilitysqlversionsbrokerserviceacrossserver
Problem
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.
Solution
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:
Link
http://msdn.microsoft.com/en-us/library/bb839483(v=sql.105).aspx
Here are some helpful links:
Link
http://msdn.microsoft.com/en-us/library/bb839483(v=sql.105).aspx
Context
StackExchange Database Administrators Q#89400, answer score: 3
Revisions (0)
No revisions yet.