Using SSDT on a build server

Mark DeMichele 0 Reputation points
2024-04-24T19:26:26.72+00:00

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.

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,757 questions
Visual Studio Setup
Visual Studio Setup
Visual Studio: A family of Microsoft suites of integrated development tools for building applications for Windows, the web and mobile devices.Setup: The procedures involved in preparing a software program or application to operate within a computer or mobile device.
970 questions
0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Tianyu Sun-MSFT 27,356 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).

    User's image

    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.

  2. 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?

    0 comments