How to install SQL 2017 Management Objects (NuGet)

[Googoohead]

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]

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]

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]

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