Microsoft.SqlServer.SqlManagementObjects 160.2004021.0

The SQL Server Management Objects (SMO) Framework is a set of objects designed for programmatic management of Microsoft SQL Server and Microsoft Azure SQL Database.

There is a newer version of this package available.
See the version list below for details.
Install-Package Microsoft.SqlServer.SqlManagementObjects -Version 160.2004021.0
dotnet add package Microsoft.SqlServer.SqlManagementObjects --version 160.2004021.0
<PackageReference Include="Microsoft.SqlServer.SqlManagementObjects" Version="160.2004021.0" />
For projects that support PackageReference, copy this XML node into the project file to reference the package.
paket add Microsoft.SqlServer.SqlManagementObjects --version 160.2004021.0
The NuGet Team does not provide support for this client. Please contact its maintainers for support.

Introduction

This file will log substantial changes made to SMO between public releases to nuget.org.

160.1911221.0-preview

  • Increase major version from 15 to 16
  • Remove dependency on native batch parser from NetFx components
  • Change NetStandard client driver to Microsoft.Data.SqlClient
  • Add distribution property for DW materialized views
  • Script FILLFACTOR for indexes on Azure SQL Database

160.201141.0-preview

  • Remove unneeded "using" TSQL statements from Database.CheckTables method implementations

  • Enable ColumnMasterKey properties Signature and AllowEnclaveComputations for Azure SQL DB

  • Fix Database.EncryptionEnabled and Database.DatabaseEncryptionKey behavior during Database.Alter(). Now, this code will correctly create a new key using the server certificate named MyCertificate:

        db.EncryptionEnabled = true;
        db.DatabaseEncryptionKey.EncryptorName = "MyCertificate";
        db.DatabaseEncryptionKey.EncryptionAlgorithm = DatabaseEncryptionAlgorithm.Aes256;
        db.DatabaseEncryptionKey.EncryptionType = DatabaseEncryptionType.ServerCertificate;
        db.Alter()
    
  • Fixed the "like" and "contains" URN filter functions to work with parameters containing single quotes. These operators can be used to optimally initialize collections:

    // populate the collection with databases that have Name starting with "RDA"
    var server = Server(new ServerConnection(sqlConnection));
    server.Databases.ClearAndInitialize("[like(@Name, 'RDA%')]", new string[] { });
    
  • Make Table.Location property optional for creating or scripting external tables.

  • Enable scripting of ANSI_PADDING settings for Azure SQL Database tables.

  • Remove obsolete types ServerActiveDirectory and DatabaseActiveDirectory

  • Added BLOB_STORAGE scripting support for external data sources

  • Fixed error scripting external tables for Azure SQL Database

  • Replace Microsoft.SqlServer.Management.SqlParser.dll with a dependency to its Nuget package

160.2001141.0

  • First non-preview 160 release, aligned with SQL Server Management Studio 18.5
  • Script extended properties for Azure SQL Database objects
  • Enable Jupyter Notebook output for SqlScriptPublishModel. SSMS 18.5 can output a Notebook for Azure Data Studio in Generate Scripts now.
  • Fix issue where Table.EnableAllIndexes(Recreate) did nothing
  • Fix Database.EnumObjectPermissions usage in NetStandard binaries
  • Remove FORCE ORDER hint from table enumeration that was causing major performance issues
  • Fix Transfer with PrefetchAllObjects == false for pre-Sql 2014 versions so it doesn't throw an exception

Introduction

This file will log substantial changes made to SMO between public releases to nuget.org.

160.1911221.0-preview

  • Increase major version from 15 to 16
  • Remove dependency on native batch parser from NetFx components
  • Change NetStandard client driver to Microsoft.Data.SqlClient
  • Add distribution property for DW materialized views
  • Script FILLFACTOR for indexes on Azure SQL Database

160.201141.0-preview

  • Remove unneeded "using" TSQL statements from Database.CheckTables method implementations

  • Enable ColumnMasterKey properties Signature and AllowEnclaveComputations for Azure SQL DB

  • Fix Database.EncryptionEnabled and Database.DatabaseEncryptionKey behavior during Database.Alter(). Now, this code will correctly create a new key using the server certificate named MyCertificate:

        db.EncryptionEnabled = true;
        db.DatabaseEncryptionKey.EncryptorName = "MyCertificate";
        db.DatabaseEncryptionKey.EncryptionAlgorithm = DatabaseEncryptionAlgorithm.Aes256;
        db.DatabaseEncryptionKey.EncryptionType = DatabaseEncryptionType.ServerCertificate;
        db.Alter()
    
  • Fixed the "like" and "contains" URN filter functions to work with parameters containing single quotes. These operators can be used to optimally initialize collections:

    // populate the collection with databases that have Name starting with "RDA"
    var server = Server(new ServerConnection(sqlConnection));
    server.Databases.ClearAndInitialize("[like(@Name, 'RDA%')]", new string[] { });
    
  • Make Table.Location property optional for creating or scripting external tables.

  • Enable scripting of ANSI_PADDING settings for Azure SQL Database tables.

  • Remove obsolete types ServerActiveDirectory and DatabaseActiveDirectory

  • Added BLOB_STORAGE scripting support for external data sources

  • Fixed error scripting external tables for Azure SQL Database

  • Replace Microsoft.SqlServer.Management.SqlParser.dll with a dependency to its Nuget package

160.2001141.0

  • First non-preview 160 release, aligned with SQL Server Management Studio 18.5
  • Script extended properties for Azure SQL Database objects
  • Enable Jupyter Notebook output for SqlScriptPublishModel. SSMS 18.5 can output a Notebook for Azure Data Studio in Generate Scripts now.
  • Fix issue where Table.EnableAllIndexes(Recreate) did nothing
  • Fix Database.EnumObjectPermissions usage in NetStandard binaries
  • Remove FORCE ORDER hint from table enumeration that was causing major performance issues
  • Fix Transfer with PrefetchAllObjects == false for pre-Sql 2014 versions so it doesn't throw an exception

Release Notes

See https://docs.microsoft.com/sql/ssms/sql-server-management-studio-changelog-ssms for combined release notes of SMO and SSMS.

NuGet packages (42)

Showing the top 5 NuGet packages that depend on Microsoft.SqlServer.SqlManagementObjects:

Package Downloads
dbup-sqlserver-scripting
Extends DbUp to provide SQL Server object definition scripting when running migrations from Visual Studio. When a database object changes during a migration, its definition will be saved in the project.
Naos.Deployment.Core
Created on 2020-08-06 23:22
Naos.Deployment.Console
Created on 2020-08-06 23:22
Naos.Database.MessageBus.Handler
Created on 2020-08-06 23:22
Naos.Database.Migrator.Console
Created on 2018-10-12 15:52

GitHub repositories (5)

Showing the top 5 popular GitHub repositories that depend on Microsoft.SqlServer.SqlManagementObjects:

Repository Stars
microsoft/fhir-server
A service that implements the FHIR standard
dotnet/SqlClient
Microsoft.Data.SqlClient provides database connectivity to SQL Server for .NET applications.
microsoft/sqltoolsservice
SQL Tools API service that provides SQL Server data management capabilities.
spaghettidba/WorkloadTools
A collection of tools to collect, analyze and replay SQL Server workloads, on premises and in the cloud
dradovic/MigSharp
Mig# (MigSharp) is a .NET framework for database migrations and versioning

Version History

Version Downloads Last updated
161.44091.28 87 10/20/2020
161.42121.15-msdata 1,264 8/17/2020
161.41981.14-msdata 264 8/3/2020
161.41011.9 63,534 7/22/2020
161.40241.8-msdata 903 6/29/2020
160.2004021.0 179,437 4/7/2020
160.2001141.0-preview 2,031 1/15/2020
160.1911221.0-preview 19,632 11/23/2019
150.18208.0 348,311 11/6/2019
150.18208.0-preview 135 11/6/2019
150.18178.0 71,826 9/27/2019
150.18178.0-preview 154 9/27/2019
150.18149.0-preview 2,996 8/14/2019
150.18147.0 162,432 7/30/2019
150.18147.0-preview 172 7/30/2019
150.18131.0 74,089 6/14/2019
150.18131.0-preview 242 6/13/2019
150.18118.0 150,390 4/24/2019
150.18118.0-preview 285 4/24/2019
150.18097.0-preview 24,566 3/22/2019
150.18096.0-preview 667 3/8/2019
150.18092.0-preview 300 3/4/2019
150.18085.0-preview 899 2/15/2019
150.18068.0-preview 2,214 11/16/2018
150.18040.0-preview 1,585 9/24/2018
150.18022.0-preview 656 8/22/2018
140.17283.0 389,519 8/15/2018
140.17283.0-preview 351 8/15/2018
140.17282.0-preview 439 8/7/2018
140.17279.0 108,825 7/9/2018
140.17267.0-preview 2,638 5/21/2018
140.17265.0 40,223 5/15/2018
140.17235.0 65,832 3/29/2018
140.17224.0 73,589 2/22/2018
140.17218.0 49,222 1/4/2018
140.17199.0 129,837 10/6/2017
140.17177.0 50,913 8/7/2017
Show less