Home

Dependencies:

DacFx Framework:
Docs
https://docs.microsoft.com/en-us/sql/tools/sqlpackage-download?view=sql-server-ver15
Direct Download:
https://go.microsoft.com/fwlink/?linkid=2113703
Changelog
https://docs.microsoft.com/en-us/sql/tools/release-notes-sqlpackage?view=sql-server-ver15

SMO:
MS has screwed this up by making it a NuGet package that sometimes works
But generally the latest from SQL 2019 or SSMS works fine

Active Directory
If want to resolve Login Group Members, you will need the RSAT (AD) Powershell Module.
Note RSAT only works in Windows Powershell 5.1
There is NO Active Directory module for Powershell 6/7
When it comes out, Powershell 6/7 will become useful

RSAT for Windows 7:
https://www.microsoft.com/en-us/download/details.aspx?id=7887

RSAT for Windows 8.0
https://www.microsoft.com/en-us/download/details.aspx?id=28972

RSAT for Windows 8.1
https://www.microsoft.com/en-us/download/details.aspx?id=39296

RSAT for Windows 10
Windows 10 RSAT is more complicated:
There is a separate download for each Windows 10 Build
After the October 2018 Build, RSAT is a "Feature On Demand" install
You will need to reinstall RSAT after a major Windows 10 Build upgrade!