we are currently designing CI/CD Pipelines and the build server we have available at the moment is a Ubuntu machine.
I investigated a lot and it seems that this combination is just a bad idea and I really need a windows build server. Basically the CI pipeline is just a task to pull the sources from git and another task to build either the Visual Studio Solution or the Database Project (*.sqlproj).
In theory I should be able to do it with .Net Core but I need the "Microsoft/VisualStudio/v11.0/SSDT/Microsoft.Data.Tools.Schema.SqlTasks.targets". I could not find any way to get this installed on Ubuntu.
I tried also using Azure Data Studio instead of Visual Studio 2019. This allow me to develop in any platform but I am still not able to build the project in a linux agent without any user interface.
I also followed this post https://erikej.github.io/efcore/2020/05/11/ssdt-dacpac-netcore.html
This worked but is a kind of workaround using .Net Core 2.x which already reached EOL and I want to avoid it.
Is there any recommended solution that makes sense or I just request as a hard requirement a Windows based agent (build server)?
Any help will be appreciated.