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,887 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.
975 questions
0 comments No comments
{count} votes

2 answers

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

    0 comments No comments