Visual Studio 2010 Doesn’t Support SQL Server 2008 Business Intelligence Templates
Yes. That’s true. The Visual Studio 2010 doesn’t support the SQL Server 2008 or SQL Server 2008 R2 Business Intelligence templates. If we go to the Visual Studio 2010 new project’s window, what we get is shown below.
So, what’s the solution? If we wish to work on the SQL Server 2008/2008 R2 Business Intelligence projects, we need to have the Visual Studio 2008 or Visual Studio 2008 Shell. The Visual Studio Shell is installed when we install Business Intelligence Development Studio during SQL Server shared components intallation.
The Microsoft has removed the SQL Server 2008/2008 R2 BI support from the Visual Studio 2010. The Visual Studio 2010 has been designed for the SQL Server 2012, which is available in the market now. In addition, the Business Intelligence Development Studio has also been renamed as the SQL Server Data Tools in the SQL Server 2012.