


Downloading a later copy of SSDT will install it into Visual Studio Express.Įxpress and shell are limited in that you cannot add add-ins (vspackages) to them but they functionally work. If you download and install Visual Studio Express you will get a copy of SSDT database tools (no BI). SSDT (DB tools) in Visual Studio Express.If you do not have visual studio installed when you download SSDT it will install the visual studio shell which is a limited version of visual studio. If you are looking at SSDT database projects, then it is a little bit complicated in that SSDT itself is free but it is hosted inside visual studio so your options are: If you are using SSDT-BI (or BIDS) just run the installer that comes with the version of SQL you are targetting and install from there, these are free and you pay a license to use the server (unless it is express ahhhhh). If you are on sql 2008 r2 then that is actually SSDT-BI predecessor "BIDS". SSDT and SSDT-BI have merged to become one in the Visual Studio 2015 version but unless you are on sql 2012+ you will need to install the version of SSDT-BI that you need for your sql. SSDT-BI is for ssis, ssas, ssrs projects.

SSDT is the database projects which lets you manage t-sql. First there is a difference between SSDT and SSDT-BI.
