One of my favorite recent SQL Project additions is the new preplan script feature.
It lets you execute SQL before the DACPAC deployment plan is created, enabling deployment scenarios that were previously impossible.
Details and examples:
🔗 buff.ly/lBG2OzI
#SQLServer #DacFx #SqlPackage #DevOps
buff.ly
The SQL Project preplan script - the missing step in DACPAC publishing
If you have done any amount of DACPAC-based deployment, you have almost certainly hit this wall: you need to make a change that the automatic schema comparison cannot safely do on its own - adding a…