Googoohead
Level 4

How to install SQL 2017 Management Objects (NuGet)

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!!
Labels (1)
0 Kudos
3 Replies
Cary_R
Level 11

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
0 Kudos
Googoohead
Level 4

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!!!
0 Kudos
tdhintz
Level 4

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-s...
0 Kudos