Add support for SSDT inside SDK docker images

[xavokill]

Describe the Problem

Inside a Docker build process in which some dotnet-framework-docker-sdk base image is used the MSBUILD build task fails due to missing SSDT components.

In this sample Database.sln contains a single database project (*.sqlproj)

RUN msbuild "Database.sln" /p:configuration=release

Throws this error:

The imported project Microsoft.Data.Tools.Schema.SqlTasks.targets was not found

Describe the Solution

During installation of "vs_BuildTools" add DataBuildTools workload to install SSDT components and its recommended items.

--add Microsoft.VisualStudio.Workload.DataBuildTools;includeRecommended

[MichaelSimons]

[Triage] We haven't received many requests for this. We have refrained from adding workloads for non-mainline scenarios. Adding all possible workloads bloat the images and make them less attractive for the majority of users. Our recommendation is to create your own custom images based on the .NET Fx SDK image and add the workloads you need. Here is an example that adds DataBuildTools.