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 -

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

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