Microsoft.SqlServer.SqlManagementObjects
160.2001141.0-preview
Prefix Reserved
See the version list below for details.
Requires NuGet 2.12 or higher.
dotnet add package Microsoft.SqlServer.SqlManagementObjects --version 160.2001141.0-preview
NuGet\Install-Package Microsoft.SqlServer.SqlManagementObjects -Version 160.2001141.0-preview
<PackageReference Include="Microsoft.SqlServer.SqlManagementObjects" Version="160.2001141.0-preview" />
paket add Microsoft.SqlServer.SqlManagementObjects --version 160.2001141.0-preview
#r "nuget: Microsoft.SqlServer.SqlManagementObjects, 160.2001141.0-preview"
// Install Microsoft.SqlServer.SqlManagementObjects as a Cake Addin #addin nuget:?package=Microsoft.SqlServer.SqlManagementObjects&version=160.2001141.0-preview&prerelease // Install Microsoft.SqlServer.SqlManagementObjects as a Cake Tool #tool nuget:?package=Microsoft.SqlServer.SqlManagementObjects&version=160.2001141.0-preview&prerelease
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
Product | Versions Compatible and additional computed target framework versions. |
---|---|
.NET | net5.0 was computed. net5.0-windows was computed. net6.0 was computed. net6.0-android was computed. net6.0-ios was computed. net6.0-maccatalyst was computed. net6.0-macos was computed. net6.0-tvos was computed. net6.0-windows was computed. net7.0 was computed. net7.0-android was computed. net7.0-ios was computed. net7.0-maccatalyst was computed. net7.0-macos was computed. net7.0-tvos was computed. net7.0-windows was computed. net8.0 was computed. net8.0-android was computed. net8.0-browser was computed. net8.0-ios was computed. net8.0-maccatalyst was computed. net8.0-macos was computed. net8.0-tvos was computed. net8.0-windows was computed. |
.NET Core | netcoreapp2.0 was computed. netcoreapp2.1 was computed. netcoreapp2.2 was computed. netcoreapp3.0 was computed. netcoreapp3.1 was computed. |
.NET Standard | netstandard2.0 is compatible. netstandard2.1 was computed. |
.NET Framework | net461 was computed. net462 is compatible. net463 was computed. net47 was computed. net471 was computed. net472 was computed. net48 was computed. net481 was computed. |
MonoAndroid | monoandroid was computed. |
MonoMac | monomac was computed. |
MonoTouch | monotouch was computed. |
Tizen | tizen40 was computed. tizen60 was computed. |
Xamarin.iOS | xamarinios was computed. |
Xamarin.Mac | xamarinmac was computed. |
Xamarin.TVOS | xamarintvos was computed. |
Xamarin.WatchOS | xamarinwatchos was computed. |
-
.NETFramework 4.6.2
- Microsoft.SqlServer.Management.SqlParser (>= 150.35031.0)
-
.NETStandard 2.0
- Microsoft.Data.SqlClient (>= 1.1.0)
- Microsoft.SqlServer.Management.SqlParser (>= 150.35031.0)
NuGet packages (103)
Showing the top 5 NuGet packages that depend on Microsoft.SqlServer.SqlManagementObjects:
Package | Downloads |
---|---|
Catalyst.DataProcessing.Engine.SqlServer
Package for developing DOS engine plugins based on the SQL Server system support |
|
Naos.Deployment.Core
Created on 2023-05-05 19:43 |
|
Naos.Deployment.Console
Created on 2023-05-05 19:43 |
|
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.Database.MessageBus.Handler
Created on 2023-05-05 19:43 |
GitHub repositories (11)
Showing the top 5 popular GitHub repositories that depend on Microsoft.SqlServer.SqlManagementObjects:
Repository | Stars |
---|---|
microsoft/WhatTheHack
A collection of challenge based hack-a-thons including student guide, coach guide, lecture presentations, sample/instructional code and templates. Please visit the What The Hack website at: https://aka.ms/wth
|
|
dotnet/SqlClient
Microsoft.Data.SqlClient provides database connectivity to SQL Server for .NET applications.
|
|
MoonStorm/FastCrud
fast .NET ORM for strongly typed people
|
|
microsoft/sqltoolsservice
SQL Tools API service that provides SQL Server data management capabilities.
|
|
rr-wfm/MSBuild.Sdk.SqlProj
An MSBuild SDK that provides similar functionality to SQL Server Data Tools (.sqlproj) projects
|
Version | Downloads | Last updated |
---|---|---|
172.52.0 | 47,455 | 11/19/2024 |
171.30.0 | 2,920,738 | 3/21/2024 |
170.23.0 | 574,312 | 1/10/2024 |
170.21.0 | 169,461 | 9/29/2023 |
170.18.0 | 992,252 | 5/31/2023 |
170.13.0 | 774,235 | 2/1/2023 |
170.12.0 | 51,998 | 1/27/2023 |
170.11.0 | 250,783 | 1/5/2023 |
170.8.0 | 552,103 | 10/17/2022 |
170.7.0-preview | 35,104 | 8/18/2022 |
170.5.0-preview | 20,023 | 8/17/2022 |
161.48050.0 | 40,447 | 11/28/2023 |
161.48044.0 | 7,209 | 5/31/2023 |
161.48036.0 | 33,849 | 1/30/2023 |
161.48028.0 | 6,015 | 12/21/2022 |
161.47027.0 | 457,716 | 8/11/2022 |
161.47023.0-preview | 2,406 | 6/15/2022 |
161.47021.0 | 462,932 | 5/25/2022 |
161.47008.0 | 567,268 | 3/7/2022 |
161.46521.71 | 1,059,419 | 10/6/2021 |
161.46437.65 | 603,514 | 7/28/2021 |
161.46367.54 | 597,381 | 4/22/2021 |
161.46041.41 | 2,410,439 | 1/2/2021 |
161.44091.28 | 512,777 | 10/20/2020 |
161.42121.15-msdata | 22,616 | 8/17/2020 |
161.41981.14-msdata | 1,977 | 8/3/2020 |
161.41011.9 | 576,448 | 7/22/2020 |
161.40241.8-msdata | 18,007 | 6/29/2020 |
160.2004021.0 | 966,611 | 4/7/2020 |
160.2001141.0-preview | 4,595 | 1/15/2020 |
160.1911221.0-preview | 74,894 | 11/23/2019 |
150.18208.0 | 1,285,379 | 11/6/2019 |
150.18208.0-preview | 1,671 | 11/6/2019 |
150.18178.0 | 265,704 | 9/27/2019 |
150.18178.0-preview | 1,643 | 9/27/2019 |
150.18149.0-preview | 5,313 | 8/14/2019 |
150.18147.0 | 419,808 | 7/30/2019 |
150.18147.0-preview | 1,635 | 7/30/2019 |
150.18131.0 | 224,062 | 6/14/2019 |
150.18131.0-preview | 1,782 | 6/13/2019 |
150.18118.0 | 341,409 | 4/24/2019 |
150.18118.0-preview | 1,715 | 4/24/2019 |
150.18097.0-preview | 30,134 | 3/22/2019 |
150.18096.0-preview | 2,471 | 3/8/2019 |
150.18092.0-preview | 1,814 | 3/4/2019 |
150.18085.0-preview | 2,768 | 2/15/2019 |
150.18068.0-preview | 4,981 | 11/16/2018 |
150.18040.0-preview | 4,074 | 9/24/2018 |
150.18022.0-preview | 2,720 | 8/22/2018 |
140.17283.0 | 1,694,886 | 8/15/2018 |
140.17283.0-preview | 2,106 | 8/15/2018 |
140.17282.0-preview | 2,113 | 8/7/2018 |
140.17279.0 | 225,643 | 7/9/2018 |
140.17267.0-preview | 5,304 | 5/21/2018 |
140.17265.0 | 134,001 | 5/15/2018 |
140.17235.0 | 103,587 | 3/29/2018 |
140.17224.0 | 310,837 | 2/22/2018 |
140.17218.0 | 168,275 | 1/4/2018 |
140.17199.0 | 382,007 | 10/6/2017 |
140.17177.0 | 144,395 | 8/7/2017 |
See https://docs.microsoft.com/sql/ssms/sql-server-management-studio-changelog-ssms for combined release notes of SMO and SSMS.