Skip to content
George Walkey edited this page Feb 22, 2020 · 39 revisions

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

If you are resolving Login Group Names you will need the RSAT (AD) Powershell Module.
Note these are for 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
https://www.microsoft.com/en-us/download/details.aspx?id=45520

Clone this wiki locally