Build .sqlproj on Linux

Question

Hello everyone, I have been using on Azure DevOps the task VSBuild to build, in a .yml pipeline, a Visual Studio Solution containing a SQL Database Project (.sqlproj). An example of the task is:

• task: VSBuild@1
  displayName: "build deployment project"
  inputs:
  solution: ${{ parameters.solution }}
  platform: 'Any CPU'
  configuration: 'Release'

I am now facing the issue to build the same solution on a Linux machine, but I am not able to find a way to perform the same operation.
The desired output is to create a .DacPac file to deploy it on an Azure SQL Database.
Any thoughts?

Thank you all!

Andrea

Answer 1

Hi @Angandin Thank you for posting your question on Microsoft Q&A and for using Azure services.

In my understanding you are not able to build .sqlproj in a linux machine.
Could you please try the code below?

To build DacPac file on a Linux agent is done via MSBuild.Sdk.SqlProj Go to your database project directory in parallel to .sqlproj file create a directory like DB.Build under it create DB.Build.csproj copy.pase the content as below

<Project Sdk="MSBuild.Sdk.SqlProj/1.1.0"> <!-- This will pull in the required tools and dependencies to build a .dacpac with .NET Core -->
<PropertyGroup>
<TargetFramework>netstandard2.0</TargetFramework>
</PropertyGroup>
<ItemGroup>
<Content Include="..\src\DB\masterdata***.sql" /> <!-- link in the new .csproj to the .sql scripts in your existing database project -->
</ItemGroup>
</Project>