SQL Server 2014 Data Tools

Question

I've just installed Developer Edition of SQL Server 2014, a move from 2012 Edition. I can see that Data Tools are missing from initial installation. I've looked over the internet, found out that it is available as a separate package and now I'm feeling more confused about which version to use!!

There are two Data Tools files are available for SQL Server 2014 on Microsoft web site, each for Visual Studio 2012/2013. My SQL Server 2014 has only Visual Studio 2010 Shell, Visual Studio 2010 for Office Runtime (x64) and for Applications x64 Runtime 3.0!!!

I understood that Data Tools can be installed without full copy of Visual Studio, but in my situation what version should I use??? To me, it is confusing because I've SQL 2014 and according to MS website, Data Tools for SQL 2014 should be for either Visual Studio 2012 or 2013. while I've Visual Studio 2010 shell available on my computer and I don't want to install Visual Studio just to install Data Tools. I also though about installing Data Tools for Visual Studio 2010 to make it compatible with what is available on my computer, but it doesn't make sense to use latest version of SQL Server with older Data Tools.

I've lost lot of time looking for clear answer, but could not find one. Help please!!!

K

Answer 1

Hi KhurramKZ,

                   

As you are using SQL Server 2014, if you need to deploy SSIS, SSRS, SSAS projects, please download SSDT-BI for SQL Server 2014 from this link and install it. However, ff you want to develop SQL Server 2014 database projects, please download SSDT for SQL Server 2014 from this link and install it.

After installing above SSDT/ SSDT-BI for SQL Server 2014, it will install Visual Studio 2013 integrated shell. Please ensure that you open Visual Studio 2013 as described in this similar thread and develop relevant projects.

In addition, SSDT for Visual Studio 2012 and SSDT-BI for Visual Studio 2012 can also be used with SQL Server 2014. For more details, please review this article.

Thanks,
Lydia Zhang

---

Lydia Zhang
TechNet Community Support

Answer 2

Thanks Lydia, I've tried but it doesn't work and requests to install Visual Studio 2013. Attaching screenshot please.

Thanks

Answer 3

Hi KhurramKZ，

Based on my test, I can successfully install SSDT for SQL Server 2014 without installing Visual Studio? Have you tried to install SSDT-BI for SQL Server 2014 and SSDT for Visual Studio 2012, then check the result?

Thanks,
Lydia Zhang

---

Lydia Zhang
TechNet Community Support

Answer 4

Thank Lydia, both are installed now but with a warning message. Attaching, would be thankful if I could be advised on any further step required please?

K

Answer 5

Hi KhurramKZ,

SSDT for Visual Studio 2012 will install some Visual Studio components. Please ensure that your system meets the Visual Studio 2012 System Requirement.

And you might need to install latest update for Visual Studio 2012 to eliminate the above warning.

Thanks,
Lydia Zhang

---

Lydia Zhang
TechNet Community Support

Answer 6

Yes I have similar problem with Data Tools and Visual Studio and SQL Management Studio and I thought I installed everything should be ok.  NOOOOOO.  Your case is missing something, my case is installed too many why is that :(  Can Microsoft makes installation process easier? Why have so many problems, how can we suggest company to upgrade to latest version if so many problems? sigh.  I have trouble of "Deploy package from 2013 Data Tools to SQL server database 2012" is my title if you ever have this problem you can see if anyone answer me :(   I lost many days and still couldn't figure it out.  Hope someone will answer you because I may reformat computer if I have to and reinstall everything again.  Hope you get an answer and I will be able to use it!

Karen :)