Hello!

Not so long ago, I wrote about how dbatools now has functions that can be used to deploy dacpacs. What I didn’t actually include was a script to do same, so without further ado, below is a script that makes use of Publish-DbaDacpac –

View the code on Gist.

There is also a -Verbose option. But even without it a successful deployment will spit out quite a bit of information –

View the code on Gist.

And of course, if you run Get-Help Publish-DbaDacpac, you get the built in help –

View the code on Gist.