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.
SQL Server Service Broker – Compatibility Across Versions
service-brokersql server
Related Question
- Sql-server – Will certain Database Compatibility cause performance degradation
- Sql-server – SQL Server Availability Group Design Question/RFC
- Sql-server – What are Objective Reasons to Prefer SQL Server 2016 over Earlier Versions
- Sql-server – migrating DBs from SQL server 2005 to SQL server 2012
- SQL Server – SSIS While Upgrading SQL Server
- SQL Server – Upgrade Compatibility Level from 2005 to 2012
- Sql-server – Can independent applications cause roll back to each other’s transactions
Best Answer
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