Using SSDT on a build server

Mark DeMichele 0

I need to use SSDT on my build server. What exactly do need to install to get it working? I have a docker image that does the builds. It's based on mcr.microsoft.com/dotnet/framework/sdk:4.8-20230110-windowsservercore-ltsc2019Ideally, it would be nice to find a chocolatey package that installed what I needed. I found something for VS2017, but since I'm using VS2022, I was hoping to get an SSDT that was more like the one that runs in VS2022.

2 answers

Tianyu Sun-MSFT 31,246 Reputation points Microsoft Vendor

2024-04-25T04:49:56.5666667+00:00

Hello @Mark DeMichele,

Welcome to Microsoft Q&A forum.

Generally, SSDT is installed by using VS Installer.

From VS Installer => Modify => in Workloads tab select Data storage and processing workload and in Individual components tab select SQL Server Data Tools component => click Modify button.

The SSDT component can also be installed by using command lines.

For example, preparing a layout folder(VisualStudioSetup.exe --layout C:\VSLayout --add Microsoft.VisualStudio.Component.SQL.SSDT) => modifying VS to add SSDT component(C:\VSLayout\vs_setup.exe modify --installPath "C:\Program Files\Microsoft Visual Studio\2022\Community" --add Microsoft.VisualStudio.Component.SQL.SSDT --passive).

For Analysis Services(SSAS), Integration Services(SSIS), or Reporting Services(SSRS) projects, you need to install the appropriate extensions from within Visual Studio with Extensions > Manage Extensions or from the Marketplace.

More details, please kindly check this document: Download SQL Server Data Tools (SSDT) for Visual Studio.

Sincerely,

Tianyu

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
Please sign in to rate this answer.
Mark DeMichele 0 Reputation points

2024-04-25T10:04:52.81+00:00

I don't have visual studio installed on my docker build image. I just have build tools. Everything run using powershell.

Tianyu Sun-MSFT 31,246 Reputation points Microsoft Vendor

2024-04-26T05:41:42.1733333+00:00

Hello @Mark DeMichele ,

Do you mean you don’t have VS IDE on your docker build image, but have "Build Tools for Visual Studio 2022"?

If so, it’s the same. You can use command lines to install SSDT, the command should be like

C:\vs_BuildTools.exe --layout C:\VSBuildToolsLayout --add Microsoft.VisualStudio.Component.SQL.SSDTBuildSku

C:\VSBuildToolsLayout\vs_setup.exe modify --installPath "C:\Program Files (x86)\Microsoft Visual Studio\2022\BuildTools" --add Microsoft.VisualStudio.Component.SQL.SSDTBuildSku --quiet

In case you also want to install the "Data storage and processing build tools" workload or other workloads, here’s the related workloads/components ids for "Build Tools for Visual Studio 2022".

Tianyu Sun-MSFT 31,246 Reputation points Microsoft Vendor

2024-04-29T09:24:20.2333333+00:00

Hello @Mark DeMichele,

May I know if you have successfully installed the SSDT on your machine? Please feel free to let me know if there is anything that I can help here:)

Mark DeMichele 0 Reputation points

2024-04-30T16:00:50.63+00:00

Sorry was away on vacation. Just got back. I will try this after I catch up. It may take a few days to get to it though. I'll update this thread when I do. Thanks for this info. This looks promising.

Tianyu Sun-MSFT 31,246 Reputation points Microsoft Vendor

2024-05-03T07:40:39.09+00:00

No worries, feel free to let us know the results:)

Have a nice day.

Mark DeMichele 0 Reputation points

2024-05-03T12:26:48.4933333+00:00

I had installed the build tools using chocolately.

choco install visualstudio2022buildtools

I'm struggling to find vs_BuildTools.exe or it's equivalent.

I searched chocolately.org for Visual Studio 2022 and browsed all the packages.

This one looked promising - https://community.chocolatey.org/packages/visualstudio2022-workload-data but didn't help. I tried using a command line parameter to specify a product id , but that didn't work.

Any ideas?

Tianyu Sun-MSFT 31,246 Reputation points Microsoft Vendor

2024-05-06T09:31:28.8566667+00:00

Hi @Mark DeMichele,

The vs_BuildTools.exe file can be downloaded from here: Evergreen bootstrappers and Fixed version bootstrappers or here. You can pick a specific version of the vs_BuildTools.exe file.

Besides, the vs_BuildTools.exe file can also be downloaded from here: Downloads(scroll down => expand Tools for Visual Studio => Build Tools for Visual Studio 2022 => click Download).

Tianyu Sun-MSFT 31,246 Reputation points Microsoft Vendor

2024-05-09T13:52:56.5866667+00:00

Hello @Mark DeMichele,

Did you successfully get the vs_BuildTools.exe file? Did the above commands work?

Feel free to let us know the results.

Mark DeMichele 0 Reputation points

2024-05-09T18:59:17.95+00:00

I found an example on the microsoft site for adding this to a docker image and I followed that and it worked. I tried using chocolatey for a simpler solution, but for some reason it would not install SSDT on the image and it didn't give any error. It just completed but ultimately it was not there. This is what I wound up with.

SHELL ["cmd", "/S", "/C"] # Copy our Install script. COPY Install.cmd C:\TEMP\ # Download collect.exe in case of an install failure. ADD https://aka.ms/vscollect.exe C:\TEMP\collect.exe # Use the latest release channel. For more control, specify the location of an internal layout. ARG CHANNEL_URL=https://aka.ms/vs/17/release/channel ADD ${CHANNEL_URL} C:\TEMP\VisualStudio.chman RUN ` # Download the Build Tools bootstrapper. curl -SL --output vs_buildtools.exe https://aka.ms/vs/17/release/vs_buildtools.exe ` ` # Install Build Tools with the Microsoft.VisualStudio.Workload.AzureBuildTools workload, excluding workloads and components with known issues. && (call C:\TEMP\Install.cmd vs_buildtools.exe --quiet --wait --norestart --nocache install ` --installPath "%ProgramFiles(x86)%\Microsoft Visual Studio\2022\BuildTools" ` --channelUri C:\TEMP\VisualStudio.chman ` --installChannelUri C:\TEMP\VisualStudio.chman ` --add Microsoft.VisualStudio.Component.SQL.SSDTBuildSku ` --remove Microsoft.VisualStudio.Component.Windows10SDK.10240 ` --remove Microsoft.VisualStudio.Component.Windows10SDK.10586 ` --remove Microsoft.VisualStudio.Component.Windows10SDK.14393 ` --remove Microsoft.VisualStudio.Component.Windows81SDK) ` ` # Cleanup && del /q vs_buildtools.exe

Tianyu Sun-MSFT 31,246 Reputation points Microsoft Vendor

2024-05-13T08:56:45.4133333+00:00

Hi @Mark DeMichele,

Since no errors were prompted, can you confirm that the installation has completed?

Philippe shared some situations here: Sample to install build tools into a container don’t install

When running inside a container, I’ve noticed that even with the --wait flag, the command vs_buildtools.exe returns before the installation completes. Using tasklist, one can observe that many setup process need to complete for the installation to be done. Also, the command vs_buildtools.exe might need to be ran more than once if the installer needs to be updated before I can observe an installation.

Zarate, Martin 5 Reputation points

2024-05-31T14:44:49.1233333+00:00

I have a similar problem - we're not using Docker, but we have a build-server using Visual Studio Build Tools. I'm trying to get SSAS/SSRS/SSIS builds enabled there, but it looks like those are only supported by full Visual Studio since they require VS extensions and BuildTools does not support extension installation.

Is there any official recommendation on how to handle this besides installing full VS into our build server?

Tianyu Sun-MSFT 31,246 Reputation points Microsoft Vendor

2024-06-03T03:21:36.9833333+00:00

Hi @Zarate, Martin,

For SSIS, does this tool: Standalone SQL Server Integration Service (SSIS) DevOps Tools meet your requirements?
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.
Mark DeMichele 0 Reputation points

2024-05-22T11:28:06.2833333+00:00

I can't easily confirm as I have it working now with the script I supplied and have since moved on to other things. Sorry.
Please sign in to rate this answer.

0 comments No comments
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

Share via

Using SSDT on a build server

2 answers

Your answer