Visual Studio 2012 + Business Intelligence Templates
Asked Answered
M

4

14

I got SQL Server 2012 installed on my machine and I have SSDT to create BI projects.

Today i installed Visual Studio 2012; but i cannot create any of BI projects in Visual Studio 2012. Is there a way I can open BI (SSIS/SSAS/SSRS) projects in VS 2012 or should i have to always go back to SSDT to open them.

Mezzosoprano answered 28/8, 2012 at 8:3 Comment(1)
Looks like Microsoft released a patch for VS 2012 that lets you work on SSRS 2012 reports. microsoft.com/en-us/download/details.aspx?id=36843Bealle
A
7

Check out this blog post. Basically, there are two versions of SSDT (even though Microsoft doesn't ever explicitly state this), and depending on how you installed SSDT, you get one or the other version. As a further note, SSDT will only work with BIDS in SQL Server 2012, not 2008R2.

Annetteannex answered 28/8, 2012 at 17:46 Comment(1)
An editor noted that, "As of April 2013 you will need to install the following components on top of a fresh Visual Studio 2012.2 (Update 2) installation: SSDT for Visual Studio 2012, SSDT-BI for Visual Studio 2012, Data-Tier Application Framework (March 2013)".Snowshed
C
15

SSRS development functionality became available for Visual Studio 2012 in March 2013. And Microsoft started to distinguish between SSDT and SSDT-BI (which contains the BI tools). They are complementary installations, and both must be installed for Visual Studio to be happy working with SSRS reports.

The components needed for SSRS development are as follows:

Carillonneur answered 23/4, 2013 at 13:15 Comment(1)
A note about SSDT-BI - It seems that you must choose the same language as WIndows (and not your prefered language or the language of your Visual Studio installation). Otherwise the installation fails with an error: "The SQL Server license agreement cannot be located fort he selected edition"Obelia
A
7

Check out this blog post. Basically, there are two versions of SSDT (even though Microsoft doesn't ever explicitly state this), and depending on how you installed SSDT, you get one or the other version. As a further note, SSDT will only work with BIDS in SQL Server 2012, not 2008R2.

Annetteannex answered 28/8, 2012 at 17:46 Comment(1)
An editor noted that, "As of April 2013 you will need to install the following components on top of a fresh Visual Studio 2012.2 (Update 2) installation: SSDT for Visual Studio 2012, SSDT-BI for Visual Studio 2012, Data-Tier Application Framework (March 2013)".Snowshed
M
3

In addition to this, only SQL Server Data Tools 2010/VS2010 has access to the entire BI suite. This is not yet available for VS2012/SQL Server Data Tools 2012, which only has access to the SQL Database project. Fortunately (or maybe not), both can be installed to the same system without systemic conflict. As to your mental conflict, your mileage may vary.

Mariannmarianna answered 15/1, 2013 at 20:42 Comment(1)
It looks like this answer is obsolete as of Tim Lewis's answer from April '13.Telecommunication
B
1

It is available now as an additional download at http://www.microsoft.com/en-us/download/details.aspx?id=36843

Billyebilobate answered 15/3, 2013 at 8:35 Comment(0)

© 2022 - 2024 — McMap. All rights reserved.