PDA

View Full Version : How to install SQL 2017 Management Objects (NuGet)



Googoohead
02-14-2018, 12:08 PM
Hi,

The previous versions of the SQL Management Objects were an MSI file and were installed thru a prerequisite. The SQL 2017 version is now a NuGet package. Can this still be installed as a prerequisite or how can I get this installed during the installation?

I haven't worked with NuGet packages before!

Thanks!!

Cary R
02-16-2018, 03:13 PM
Use a powershell script to run it as a prerequisite. Nuget.org gives this as a one-liner to install it:

Install-Package Microsoft.SqlServer.SqlManagementObjects -Version 140.17218.0

Googoohead
02-16-2018, 04:27 PM
Where does it get the Management Objects get installed? The previous MSI would install them into the C:\Program Files (x86)\Microsoft SQL Server\130\SDK\Assemblies folder.

Do you have any samples that would help me?

Thanks!!!

tdhintz
03-06-2018, 06:31 PM
NuGet packages need to be installed manually by including the DLLs in you own MSI. You would place them in the same folder as your binary or EXE.

https://docs.microsoft.com/en-us/sql/relational-databases/server-management-objects-smo/installing-smo