Can i install SSDT without any Visual Studio installed?

Question

_{Thursday, May 28, 2015 4:04 AM}

Hi,

Just wanted to find if there is a way i can install SSDT without a Visual studio Install in the machine?

I intend to use sqlpackages.exe which is from SSDT for publishing a dacpac, and do not intend to install any Visual Studio for this purpose.

Please let me know if this would work.

Thanks,

Pradebban Raja

All replies (3)

_{Thursday, May 28, 2015 7:09 AM ✅Answered | 2 votes}

Hello,

Yes, you can install & use SSDT (BI) without already having Visual Studio installed. If no VS is installed, then the free "Visual Studio - Integrated Shell" will be installed. You can get it here: Download SQL Server Data Tools

Olaf Helper

[ Blog] [ Xing] [ MVP]

---

_{Friday, May 29, 2015 3:30 AM ✅Answered | 3 votes}

Hi, for SqlPackage.exe you are best off installing DacFramework.msi, SqlDom.msi, and SqlSysClrTypes.msi from the SQL Server 2014 Feature Pack page. Then go to %Program Files (x86)%\Microsoft SQL Server\120\Dac\bin and run SqlPackage.exe from there. No install of Visual Studio necessary.

Regards,

Kevin

---

_{Tuesday, December 29, 2015 9:25 PM}

SSDT does not install properly without Visual Studio.  I tried the 2015 and 2013 flavor of the downloads and both prompt that visual studio must be installed first.

Instead, I am using the regular SQL installation (thankfully I have a dev license so I can do this).  My target is to use DTExec