Publishing DACPACs With Powershell

Richie Lee has a new set of functions for dbatools:

There are 3 modules included. I’m going to write a bigger piece about these functions elsewhere, but for now here is a link to the documentation –

Export-DbaDacpac

New-DbaPublishProfile

Publish-DbaDacpac

Read on for more information and a link to the source code if you’re interested in learning more.

Related Posts

Running The SQL Server Features Discovery Report

Dave Mason shows us how to run the SQL Server features discovery report via command prompt and PowerShell: I don’t need to validate SQL Server installations on a regular basis. When the need arises, my preference is to run the SQL Server features discovery report. Further, I prefer to run it from the command line. After […]

Read More

Synchronizing User Logins Across SQL Server Instances

Hamish Watson shows how easy it is to synchronize SQL authenticated logins using dbatools: When building new servers the most important thing after restoring and securing the database is syncing up the users. This is especially important for Availability Groups as SQL Authenticated users required the SIDS to be the same. In the past I […]

Read More

Categories

December 2017
MTWTFSS
« Nov Jan »
 123
45678910
11121314151617
18192021222324
25262728293031