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