CODEWITHSUNDEEP
visual-studio-2012sql-server-data-tools
Sreedhar
Sreedhar

Reputation: 30045

Visual Studio 2012 + Business Intelligence Templates

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.

Upvotes: 14

Views: 24894

Answers (4)

Tim Lewis
Tim Lewis

Reputation: 3445

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:

Upvotes: 15

Geert Verhoeven
Geert Verhoeven

Reputation: 11

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

Upvotes: 1

Bishop
Bishop

Reputation: 1136

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.

Upvotes: 3

Andrew Clear
Andrew Clear

Reputation: 8020

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.

Upvotes: 7

Related Questions