SSDT in SQL Web on Azure VM

154 Views Asked by At

I have just set up a SQL VM using SQL Server 2014 web edition. When I start up the VM and go through the apps, I can't see anywhere SQL Server Data Tools yet when I look at the features for SQL 2014, SSDT is list under web edition, and is also listed under 2016 when that gets released. My question is where do I get installed? I'm not a pro at setting things up, usually there are just ready for me to use because of how my work is, but now I'm in my own environment I at a loss as to what to do.

Could someone please provide me with some help. I'm a complete newbie at setting up my own and don't know if it is installed and I've missed or if I have to do something. I can see SSMS etc. but not SSDT.

Thanks in advance

2

There are 2 best solutions below

1
On BEST ANSWER

SQL Server Data Tools are installed along with Visual Studio 2012, 2013 or 2015RC. You can find the how to download and install information from https://msdn.microsoft.com/library/mt204009.aspx

0
On

Go to the official SSDT blog and download the latest official (non-preview/beta) release from one of the related articles: http://blogs.msdn.com/b/ssdt/

You should be able to install a stand-alone copy of SSDT, but as Eric noted, it's also run through the VS Shell so could show up in Visual Studio if installed. You'll be able to create a new project for SQL Databases if it's installed.