dbatools.library

2023.1.28

The library that powers dbatools, the community module for SQL Server Pros

There is a newer prerelease version of this module available.
See the version list below for details.

Installation Options

Copy and Paste the following command to install this package using PowerShellGet More Info

Install-Module -Name dbatools.library -RequiredVersion 2023.1.28

Copy and Paste the following command to install this package using Microsoft.PowerShell.PSResourceGet More Info

Install-PSResource -Name dbatools.library -Version 2023.1.28

You can deploy this package directly to Azure Automation. Note that deploying packages with dependencies will deploy all the dependencies to Azure Automation. Learn More

Manually download the .nupkg file to your system's default download location. Note that the file won't be unpacked, and won't include any dependencies. Learn More

Owners

Copyright

Copyright (c) 2023 by dbatools, licensed under MIT

Package Details

Author(s)

  • the dbatools team

Tags

sqlserver migrations sql dba databases mac linux core smo

Functions

Get-DbatoolsLibraryPath

Dependencies

This module has no dependencies.

FileList

  • dbatools.library.nuspec
  • dbatools.library.psd1
  • dbatools.library.psm1
  • LICENSE
  • lib\Azure.Core.dll
  • lib\Azure.Identity.dll
  • lib\Azure.Security.KeyVault.Keys.dll
  • lib\DacUnpack.exe
  • lib\dbatools.dll
  • lib\dbatools.dll.config
  • lib\instapi160.dll
  • lib\Microsoft.Bcl.AsyncInterfaces.dll
  • lib\Microsoft.Data.SqlClient.AlwaysEncrypted.AzureKeyVaultProvider.dll
  • lib\Microsoft.Data.SqlClient.dll
  • lib\Microsoft.Data.SqlClient.SNI.arm64.dll
  • lib\Microsoft.Data.SqlClient.SNI.dll
  • lib\Microsoft.Data.SqlClient.SNI.x64.dll
  • lib\Microsoft.Data.SqlClient.SNI.x86.dll
  • lib\Microsoft.Data.Tools.Schema.Sql.dll
  • lib\Microsoft.Data.Tools.Schema.Tasks.Sql.dll
  • lib\Microsoft.Data.Tools.Sql.BatchParser.dll
  • lib\Microsoft.Data.Tools.Utilities.dll
  • lib\Microsoft.Extensions.Caching.Abstractions.dll
  • lib\Microsoft.Extensions.Caching.Memory.dll
  • lib\Microsoft.Extensions.DependencyInjection.Abstractions.dll
  • lib\Microsoft.Extensions.Logging.Abstractions.dll
  • lib\Microsoft.Extensions.Options.dll
  • lib\Microsoft.Extensions.Primitives.dll
  • lib\Microsoft.Identity.Client.dll
  • lib\Microsoft.Identity.Client.Extensions.Msal.dll
  • lib\Microsoft.IdentityModel.Abstractions.dll
  • lib\Microsoft.IdentityModel.JsonWebTokens.dll
  • lib\Microsoft.IdentityModel.Logging.dll
  • lib\Microsoft.IdentityModel.Protocols.dll
  • lib\Microsoft.IdentityModel.Protocols.OpenIdConnect.dll
  • lib\Microsoft.IdentityModel.Tokens.dll
  • lib\Microsoft.SqlServer.Assessment.dll
  • lib\Microsoft.SqlServer.Assessment.Types.dll
  • lib\Microsoft.SqlServer.ConnectionInfo.dll
  • lib\Microsoft.SqlServer.Dac.dll
  • lib\Microsoft.SqlServer.Dac.Extensions.dll
  • lib\Microsoft.SqlServer.DacAzureExtensions.dll
  • lib\Microsoft.SqlServer.Dmf.Common.dll
  • lib\Microsoft.SqlServer.Dmf.dll
  • lib\Microsoft.SqlServer.Management.Assessment.dll
  • lib\Microsoft.SqlServer.Management.Collector.dll
  • lib\Microsoft.SqlServer.Management.CollectorEnum.dll
  • lib\Microsoft.SqlServer.Management.HadrData.dll
  • lib\Microsoft.SqlServer.Management.HadrModel.dll
  • lib\Microsoft.SqlServer.Management.RegisteredServers.dll
  • lib\Microsoft.SqlServer.Management.Sdk.Sfc.dll
  • lib\Microsoft.SqlServer.Management.SqlScriptPublish.dll
  • lib\Microsoft.SqlServer.Management.XEvent.dll
  • lib\Microsoft.SqlServer.Management.XEventDbScoped.dll
  • lib\Microsoft.SqlServer.Management.XEventDbScopedEnum.dll
  • lib\Microsoft.SqlServer.Management.XEventEnum.dll
  • lib\Microsoft.SqlServer.PolicyEnum.dll
  • lib\Microsoft.SqlServer.RegSvrEnum.dll
  • lib\Microsoft.SqlServer.Replication.dll
  • lib\Microsoft.SqlServer.Rmo.dll
  • lib\Microsoft.SqlServer.Server.dll
  • lib\Microsoft.SqlServer.ServiceBrokerEnum.dll
  • lib\Microsoft.SqlServer.Smo.dll
  • lib\Microsoft.SqlServer.Smo.Notebook.dll
  • lib\Microsoft.SqlServer.SmoExtended.dll
  • lib\Microsoft.SqlServer.SqlClrProvider.dll
  • lib\Microsoft.SqlServer.SqlEnum.dll
  • lib\Microsoft.SqlServer.SqlWmiManagement.dll
  • lib\Microsoft.SqlServer.TransactSql.ScriptDom.dll
  • lib\Microsoft.SqlServer.Types.dll
  • lib\Microsoft.SqlServer.WmiEnum.dll
  • lib\Microsoft.SqlServer.XEvent.XELite.dll
  • lib\Microsoft.Win32.Primitives.dll
  • lib\msodbcsql17.dll
  • lib\netstandard.dll
  • lib\Newtonsoft.Json.dll
  • lib\SqlPackage.exe
  • lib\SqlPackage.exe.config
  • lib\System.AppContext.dll
  • lib\System.Buffers.dll
  • lib\System.Collections.Concurrent.dll
  • lib\System.Collections.dll
  • lib\System.Collections.NonGeneric.dll
  • lib\System.Collections.Specialized.dll
  • lib\System.ComponentModel.Annotations.dll
  • lib\System.ComponentModel.dll
  • lib\System.ComponentModel.EventBasedAsync.dll
  • lib\System.ComponentModel.Primitives.dll
  • lib\System.ComponentModel.TypeConverter.dll
  • lib\System.Configuration.ConfigurationManager.dll
  • lib\System.Console.dll
  • lib\System.Data.Common.dll
  • lib\System.Diagnostics.Contracts.dll
  • lib\System.Diagnostics.Debug.dll
  • lib\System.Diagnostics.DiagnosticSource.dll
  • lib\System.Diagnostics.FileVersionInfo.dll
  • lib\System.Diagnostics.Process.dll
  • lib\System.Diagnostics.StackTrace.dll
  • lib\System.Diagnostics.TextWriterTraceListener.dll
  • lib\System.Diagnostics.Tools.dll
  • lib\System.Diagnostics.TraceSource.dll
  • lib\System.Diagnostics.Tracing.dll
  • lib\System.Drawing.Common.dll
  • lib\System.Drawing.Primitives.dll
  • lib\System.Dynamic.Runtime.dll
  • lib\System.Globalization.Calendars.dll
  • lib\System.Globalization.dll
  • lib\System.Globalization.Extensions.dll
  • lib\System.IdentityModel.Tokens.Jwt.dll
  • lib\System.IO.Compression.dll
  • lib\System.IO.Compression.ZipFile.dll
  • lib\System.IO.dll
  • lib\System.IO.FileSystem.dll
  • lib\System.IO.FileSystem.DriveInfo.dll
  • lib\System.IO.FileSystem.Primitives.dll
  • lib\System.IO.FileSystem.Watcher.dll
  • lib\System.IO.IsolatedStorage.dll
  • lib\System.IO.MemoryMappedFiles.dll
  • lib\System.IO.Pipes.dll
  • lib\System.IO.UnmanagedMemoryStream.dll
  • lib\System.Linq.dll
  • lib\System.Linq.Expressions.dll
  • lib\System.Linq.Parallel.dll
  • lib\System.Linq.Queryable.dll
  • lib\System.Memory.Data.dll
  • lib\System.Memory.dll
  • lib\System.Net.Http.dll
  • lib\System.Net.NameResolution.dll
  • lib\System.Net.NetworkInformation.dll
  • lib\System.Net.Ping.dll
  • lib\System.Net.Primitives.dll
  • lib\System.Net.Requests.dll
  • lib\System.Net.Security.dll
  • lib\System.Net.Sockets.dll
  • lib\System.Net.WebHeaderCollection.dll
  • lib\System.Net.WebSockets.Client.dll
  • lib\System.Net.WebSockets.dll
  • lib\System.Numerics.Vectors.dll
  • lib\System.ObjectModel.dll
  • lib\System.Reflection.dll
  • lib\System.Reflection.Extensions.dll
  • lib\System.Reflection.Primitives.dll
  • lib\System.Resources.Extensions.dll
  • lib\System.Resources.Reader.dll
  • lib\System.Resources.ResourceManager.dll
  • lib\System.Resources.Writer.dll
  • lib\System.Runtime.CompilerServices.Unsafe.dll
  • lib\System.Runtime.CompilerServices.VisualC.dll
  • lib\System.Runtime.dll
  • lib\System.Runtime.Extensions.dll
  • lib\System.Runtime.Handles.dll
  • lib\System.Runtime.InteropServices.dll
  • lib\System.Runtime.InteropServices.RuntimeInformation.dll
  • lib\System.Runtime.Numerics.dll
  • lib\System.Runtime.Serialization.Formatters.dll
  • lib\System.Runtime.Serialization.Json.dll
  • lib\System.Runtime.Serialization.Primitives.dll
  • lib\System.Runtime.Serialization.Xml.dll
  • lib\System.Security.AccessControl.dll
  • lib\System.Security.Claims.dll
  • lib\System.Security.Cryptography.Algorithms.dll
  • lib\System.Security.Cryptography.Csp.dll
  • lib\System.Security.Cryptography.Encoding.dll
  • lib\System.Security.Cryptography.Primitives.dll
  • lib\System.Security.Cryptography.ProtectedData.dll
  • lib\System.Security.Cryptography.X509Certificates.dll
  • lib\System.Security.Permissions.dll
  • lib\System.Security.Principal.dll
  • lib\System.Security.Principal.Windows.dll
  • lib\System.Security.SecureString.dll
  • lib\System.Text.Encoding.dll
  • lib\System.Text.Encoding.Extensions.dll
  • lib\System.Text.Encodings.Web.dll
  • lib\System.Text.Json.dll
  • lib\System.Text.RegularExpressions.dll
  • lib\System.Threading.dll
  • lib\System.Threading.Overlapped.dll
  • lib\System.Threading.Tasks.Dataflow.dll
  • lib\System.Threading.Tasks.dll
  • lib\System.Threading.Tasks.Extensions.dll
  • lib\System.Threading.Tasks.Parallel.dll
  • lib\System.Threading.Thread.dll
  • lib\System.Threading.ThreadPool.dll
  • lib\System.Threading.Timer.dll
  • lib\System.ValueTuple.dll
  • lib\System.Xml.ReaderWriter.dll
  • lib\System.Xml.XDocument.dll
  • lib\System.Xml.XmlDocument.dll
  • lib\System.Xml.XmlSerializer.dll
  • lib\System.Xml.XPath.dll
  • lib\System.Xml.XPath.XDocument.dll
  • lib\x64\SqlServerSpatial160.dll
  • lib\x86\SqlServerSpatial160.dll
  • third-party\bogus\bogus.dll
  • third-party\LumenWorks\LumenWorks.Framework.IO.dll
  • third-party\XESmartTarget\CommandLine.dll
  • third-party\XESmartTarget\CsvHelper.dll
  • third-party\XESmartTarget\DouglasCrockford.JsMin.dll
  • third-party\XESmartTarget\InfluxDB.Client.Core.dll
  • third-party\XESmartTarget\InfluxDB.Client.dll
  • third-party\XESmartTarget\JsonSubTypes.dll
  • third-party\XESmartTarget\Microsoft.SqlServer.BatchParser.dll
  • third-party\XESmartTarget\Microsoft.SqlServer.XE.Core.dll
  • third-party\XESmartTarget\Microsoft.SqlServer.XEvent.Linq.dll
  • third-party\XESmartTarget\netstandard.dll
  • third-party\XESmartTarget\Newtonsoft.Json.dll
  • third-party\XESmartTarget\NLog.dll
  • third-party\XESmartTarget\NodaTime.dll
  • third-party\XESmartTarget\RestSharp.dll
  • third-party\XESmartTarget\SmartFormat.dll
  • third-party\XESmartTarget\System.Buffers.dll
  • third-party\XESmartTarget\System.Collections.Immutable.dll
  • third-party\XESmartTarget\System.Configuration.ConfigurationManager.dll
  • third-party\XESmartTarget\System.Memory.dll
  • third-party\XESmartTarget\System.Numerics.Vectors.dll
  • third-party\XESmartTarget\System.Reactive.dll
  • third-party\XESmartTarget\System.Runtime.CompilerServices.Unsafe.dll
  • third-party\XESmartTarget\System.Threading.Tasks.Extensions.dll
  • third-party\XESmartTarget\System.ValueTuple.dll
  • third-party\XESmartTarget\XESmartTarget.Core.dll
  • third-party-licenses\sql-server-data-tools-license-terms-vs2017.txt
  • third-party-licenses\sql-server-data-tools-license-terms.txt
  • third-party-licenses\ThirdPartyNoticesDacFramework.rtf

Version History

Version Downloads Last updated
2026.9.14 863 9/16/2026
2026.5.3 343,826 7/10/2026
2025.12.28 1,214,156 12/28/2025
2025.12.26 15,111 12/26/2025
2025.12.25 1,631 12/25/2025
2025.12.21 26,278 12/21/2025
2025.12.4 111,517 12/5/2025
2025.11.29 41,142 11/29/2025
2025.11.12 114,647 11/12/2025
2025.8.17 526,784 8/18/2025
2025.8.5 193,364 8/5/2025
2025.7.20 108,001 7/23/2025
2025.7.19 46,096 7/20/2025
2025.7.19-pr... 11 7/20/2025
2024.4.12 2,307,610 4/12/2024
2024.3.9 100,187 3/9/2024
2024.3.9-pre... 31 3/9/2024
2024.3.8 183 3/9/2024
2024.3.8-pre... 50 3/9/2024
2023.9.21 431,005 9/21/2023
2023.5.5 297,165 5/5/2023
2023.4.27 17,430 4/28/2023
2023.4.18 645 4/18/2023
2023.4.17 115 4/16/2023
2023.4.16 16 4/16/2023
2023.4.9 379 4/9/2023
2023.4.4 358 4/5/2023
2023.1.29 1,398 1/29/2023
2023.1.28 (current version) 77 1/28/2023
2023.1.25-pr... 171 1/26/2023
2022.11.8-pr... 545 11/8/2022
Show less