In an effort to make using the MSDeployAllTheThings Nuget packages as easy to use as possible, I have updated the SQLDeploy framework to default to using DacPacs and provide parameterization files. These are the two most useful features of the framework in my opinion and were not highlighted appropriately.
Now packaging your SQL Server database for deployment is even easier with 4 simple steps:
- Create a project for deployment
- Add the MSDeployAllTheThings.SqlDeploy Nuget package (version 2.3 or higher)
- Update the [ProjectName].spp.targets file with your Database Project name
- Build the project with the /p:DeployOnBuild=true flag
Obviously, this assume you are already using Database Projects in Visual Studio. If you aren’t using these to define your database schema you should be.
You can find more details on the MSDeployAllTheThings.Nuget wiki page:
https://github.com/rschiefer/MSDeployAllTheThings.Nuget/wiki/SQLDeploy
The updated Nuget package can be found at:
https://www.nuget.org/packages/MSDeployAllTheThings.SqlDeploy/
These frameworks were first created in 2010 so they do have some cruft that needs to be cleaned up. Please try this out and let me know how it works for you. I plan to work on AppDeploy and WebDeployPlus as well in the coming weeks.