SSDT 2012 BI

BillAnton on Mon, 01 Apr 2013 14:26:50

Download SSDT-BI for Visual Studio 2012

Visual Studio 2012 was released before the BI "templates" were ready.  So for a few months after it was released, you couldn't create SSAS, SSIS, or SSRS projects in Visual Studio 2012...which was a real P.I.T.A. when you have to split development across two separate environments.  Finally, a few months ago, an update was released which adds the BI "templates" to Visual Studio 2012.

Download SSDT for Visual Studio 2010

This ^ adds the ability to create "SQL Server Database Projects" in Visual Studio 2010 which are completely different from the existing database projects (SQL Server2005 Database Project, SQL Server 2008 Database Project, etc)

Download SSDT for Visual Studio 2012

This ^ adds the ability to create "SQL Server Database Projects" in Visual Studio 2012 which are completely different from the existing database projects (SQL Server2005 Database Project, SQL Server 2008 Database Project, etc)

Kalman Toth on Mon, 01 Apr 2013 14:42:07

Hi Bill.

I have SSDT VS 2010 (installed with SS2012 ssas/ssis/ssrs designers).

What do I have to do upgrade SSDT VS 2012 (I want to keep the BI features)?  Thanks.

BillAnton on Mon, 01 Apr 2013 15:22:03

unless I'm mistaken, there's not a simple upgrade package.  Instead it's a separate installation.

Install these items in the following order:

1. Visual Studio 2012
2. SSDT for Visual Studio 2012
3. SSDT-BI Tools for Visual Studio 2012

That will give you VS 2012 with the BI features.  VS2010 will still be installed (also with BI features)...it's your choice whether to get rid of this or not.

hth

Kalman Toth on Mon, 01 Apr 2013 17:03:34

I got VS 10 as part of SS 12 Developer.

I just want an SSDT upgrade without purchasing VS 12.

BillAnton on Mon, 01 Apr 2013 17:10:32

From your responses, it sounds like you already have that...

"I have SSDT VS 2010 (installed with SS2012 ssas/ssis/ssrs designers)."

Kalman Toth on Mon, 01 Apr 2013 18:59:44

Thanks for the help.

Here is what I am doing:

1. Download SSDT for Visual Studio 2012

"If you do not have Visual Studio 2012 Professional Edition or above, SSDT will install the  Visual Studio 2012 Integrated Shell and install SSDT - December 2012 on top of it. The Integrated Shell will only contain SSDT, and does not include VS programming languages and the features that support their respective project systems. The database functionality of Express SKUs of Visual Studio 2012 will also be updated when SSDT - December 2012 is installed"

2. Download SSDT-BI for Visual Studio 2012

---

Kalman Toth Database & OLAP Architect sqlusa.com
New Book / Kindle: Pass SQL Exam 70-461 & Job Interview: Programming SQL Server 2012

BillAnton on Mon, 01 Apr 2013 20:12:31

ahhhh gotcha...that makes more sense...sorry for the confusion

John Cade on Mon, 07 Oct 2013 21:32:18

unless I'm mistaken, there's not a simple upgrade package.  Instead it's a separate installation.

Install these items in the following order:

1. Visual Studio 2012
2. SSDT for Visual Studio 2012
3. SSDT-BI Tools for Visual Studio 2012

That will give you VS 2012 with the BI features.  VS2010 will still be installed (also with BI features)...it's your choice whether to get rid of this or not.

hth

---

BI Developer and lover of data (Blog | Twitter)

This was very helpful and exactly what i was looking for.  Next question: where does the "SQL Server 2012 Business Intelligence with SP1" download fit into this?  If I installed SQL Server Dev Edition or Enterprise Edition (w/ SP1), do I also need to install this download?