What is?
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.
How it works?
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.
Deploy database on same server
Requirements:
publish a dacpac on database
This task will install all requirements automatically
- .Net Core 2.100+
- .Net Core Tool - Dacpac.Tool
Generate .dacpac from .sqlproj
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