SSDT for VS2017 – unattended install

download the install bootstrapper from Microsoft
https://docs.microsoft.com/en-us/sql/ssdt/download-sql-server-data-tools-ssdt

create an offline install layout (optional)

Now that is complete, you can run the install manually or unattended

You must make a decision at this point. If you develop in Visual Studio, and you need to create installer projects as well as SSRS and SSIS projects, then you must install SSDT to a separate instance of Visual Studio. This requires the use of the installer flag “INSTALLVSSQL”, this tells the installer to create a separate instance of visual studio during installation
To view the options run c:\vs2017SSDT>SSDT-Setup-ENU /?

To kick the installer off unattended, you can either use /passive or /quiet

2 thoughts on “SSDT for VS2017 – unattended install”

  1. I was able to install SSDT unattended but recently this has stopped working. Interested to know whether you have the same experience.

    I’m using roughly the same code as you. I take my cue from

    https://github.com/Microsoft/vsts-image-generation/blob/master/images/win/scripts/Installers/Vs2017/Install-SSDT.ps1

    $InstallerURI = ‘https://download.microsoft.com/download/4/6/7/467D4341-11DB-4D31-8F4C-193C6920A883/SSDT-Setup-ENU.exe’
    $InstallerName = ‘SSDT-Setup-ENU.exe’
    $logFilePath = “$env:TEMP\ssdtlog.txt”
    $ArgumentList = (‘/install’, ‘INSTALLVSSQL’, ‘/passive’, ‘/norestart’, “/log "$logFilePath“”)

    But the install eventually hangs. Repeatibility of unattended installs is the hardest thing with Microsoft toolchains.

    1. Hi Stephane

      Yes Microsoft have admitted there is currently a problem trying to install the Data tools for VS 2017. They are working to resolve the problem and release the updated installer. When it is resolved i’ll update this post to reflect any changes

Leave a Reply

Your email address will not be published. Required fields are marked *