Erik Ejlskov Jensen shows how to deploy a Visual Studio database project from .NET Core:
In this post, I will describe how you can build a SQL Server Database project in order to create a .dacpac file, using .NET Core only –
dotnet build
.For a while now, it has been possible to publish a .dacpac (meaning apply it to an new or existing database) using the cross-platform version of sqlpackage.
But building a database project (.sqlproj) was only possible on Windows, as the .sqlproj project type is based on the classic .NET Framework .csproj project type.
However, thanks to a smart open source effort, you can now also build a .dacpac file, even on a Mac or Linux build agent.
Read on to learn more.