0

I am currently trying to find a work around to build and publish locally a .sqlproj project. Apparently this is meant to be done using SSDT tools provided by Visual Studio, which is not available on Linux.

My question is, what are my options? What can I do to build and publish this project type?

Stephanos B.
  • 340
  • 3
  • 15

1 Answers1

0

You don't need to have Visual Studio if the only your intention is to publish the project. You need just MsBuild and probably SSDT components. This is discussion about MsBuild on Linux.

Another way is to use docker, for example this one.

Dmitrij Kultasev
  • 5,447
  • 5
  • 44
  • 88
  • Using simply MSBuild doesn't really work with publishing .sqlproj files, unless there is a specific way to do it which I am not aware of – Stephanos B. Oct 05 '20 at 14:43
  • MsBuild.exe $SqlProjPath /p:Configuration=Release /t:Build,Publish /p:SqlPublishProfilePath=$PublishProfilePath – Dmitrij Kultasev Oct 05 '20 at 15:02