The Dacpac Tool is a set of scripts that are able to perform the publication of the structure of your database (MS SQL Server) based on the selected .dacpac file.
The executed script searches for a file that matches the pattern entered, connects to the database using the connection string, instantiates a class, from the SDDT package, configures the execution of the publication, and executes deploy.
This task will install all requirements automatically
- .Net Core 2.100+
- .Net Core Tool - Dacpac.Tool
For this task to run the "Agent" running server must have installed SQL Server Data Tools in the directory C:\Program Files (x86)\Microsoft SQL Server\120\DAC\bin\Microsoft.SqlServer.Dac.dll