Use MSBuild.Sdk.SqlProj to work with dacpacs cross-platform
In this dotnetFlix, Jonathan Mezach introduces and demonstrates MSBuild.Sdk.SqlProj. This is a MSBuild SDK that is capable of producing a SQL Server Data-Tier Application package (.dacpac) from a set of SQL scripts that can be subsequently deployed using either SqlPackage.exe or dotnet publish. It provides much of the same functionality as the SQL Server Data Tools .sqlproj project format, but is built on top of the new SDK-style projects that were first introduced in Visual Studio 2017.
It is an open-source tool that was created by Jonathan and now has over 8000 downloads and multiple contributors. You can find the repository for the tool here:
https://github.com/rr-wfm/MSBuild.Sdk...
00:00:09 - Introduction
00:00:26 - Introduction of the MSBuild.Sdk.SqlProj project
00:01:03 - Demo: create a dacpac using the existing SQL Project in Visual Studio
00:04:34 - Demo: issues when using the SQL project cross-platform (without Visual Studio)
00:06:41 - Demo: use MSBuild.Sdk.SqlProj to build a dacpac
00:10:26 - Demo: use the project in VS Code on a Mac
00:11:57 - Demo: reference another dacpac
00:15:35 - Demo: publish the dacpac to a database
00:21:22 - Wrap-up
This video was made possible by Info Support (https://www.infosupport.com) and DotNed, the Dutch .NET Usergroup (https://www.dotned.nl).
--