Packaging and Deploying SQL Databases
This documentation is for FAKE version 5.0 or later. The old documentation can be found here
FAKE can be used to create a SQL DACPAC and also deploy it to a SQL Server using the MSDeploy executable. This is installed by default with Visual Studio and with the SQL Server Data Tools (SSDT) package.
DACPACs automatically diff from the source to the destination and generate the SQL script dynamically.
You can read up more on DACPac and MSDeploy arguments here.
Ensure that you have already built your database project (you can do this with standard MSBuild). Then, use the
deployDb command to deploy the
dbProject.dacpac to the
1: 2: 3: 4: 5: 6: 7: 8:
You can optionally specify the type of command to use (again, refer to the documentation above for more detail): -
- Deploy - full deploy to destination
- Script - SQL script
- Report - XML report of diff
In addition, you can also elect to deploy to Dacpac files rather than SQL databases - simply pass in the pass to the dacpac that you wish to generate.