Setting things in the right compatibility view (Visual Studio 2005 / 2008 / 2010 / 2012 / 2013 / BIDS / BI Development SSAS SSIS SSRS SSDT, SQL Server 2005 / 2008 / 2008R2 / 2012 / 2014)

 

A very common request and question is (as I have to confess that this is confusing) is which version of SQL Server (SSMS - SQL Server Management Studio, BIDS - Business Intelligence Development Studio, VS- Visual Studio) does works together with which version of SQL Sever which target version and which project type. Here is a complete list to be updated through the versions of SQL Sever and the lifecycle of Visual Studio:

	Visual Studio 2005	Visual Studio 2008	Visual Studio 2010	Visual Studio 2012	Visual Studio 2013
Framework	.NET 2.0	.NET 2.0 .NET 3.0 .NET 3.5	.NET 2.0 .NET 3.0 .NET 3.5 .NET 4.0	.NET 2.0 .NET 3.0 .NET 3.5 .NET 4.0 .NET 4.5	.NET 2.0 .NET 3.0 .NET 3.5 .NET 4.0 .NET 4.5
SSDT / SQL tooling in Visual Studio (built into VS, non-BI)	N/A	N/A	N/A	SQL 2005 - SQL 2014 inclusive	SQL 2005 - SQL 2014 inclusive
BIDS overall compat. (SSRS, SSIS, SSAS)	SQL 2005	SQL 2008/R2	SQL 2012	SQL 2012	SQL 2014
SSRS					SQL 2008R2 - SQL 2014
SSAS					SQL 2008R2 - SQL 2014
SSIS					SQL 2014

-Jens

Comments

• Anonymous
  August 01, 2014
  Thanks for the work to summarize this!

• Anonymous
  October 22, 2014
  Is there any workaround for running VS 2013 SSIS on SQL 2008 R2?