PsSmo

1.1.0

The PowerShell SQL Client module replaces the SQL Server utilities SQLCMD with native PowerShell commands.

Minimum PowerShell version

7.0

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 PsSmo -RequiredVersion 1.1.0

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

Install-PSResource -Name PsSmo -Version 1.1.0

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

(c) 2021 Steffen Kampmann. Alle Rechte vorbehalten.

Package Details

Author(s)

  • Steffen Kampmann

Tags

sql sqlserver sqlclient

Cmdlets

Connect-Instance Disconnect-Instance Get-Table Invoke-Command

Dependencies

This module has no dependencies.

FileList

  • PsSmo.nuspec
  • Azure.Core.dll
  • Azure.Identity.dll
  • runtimes\win\lib\net6.0\Microsoft.PowerShell.CoreCLR.Eventing.dll
  • Microsoft.ApplicationInsights.dll
  • runtimes\win\lib\net6.0\Microsoft.Win32.Registry.AccessControl.dll
  • Microsoft.Azure.Services.AppAuthentication.dll
  • runtimes\win\lib\net6.0\Microsoft.Win32.SystemEvents.dll
  • Microsoft.Bcl.AsyncInterfaces.dll
  • runtimes\win\lib\net6.0\System.Diagnostics.EventLog.dll
  • Microsoft.Data.SqlClient.dll
  • runtimes\win\lib\net6.0\System.Diagnostics.EventLog.Messages.dll
  • Microsoft.Data.Tools.Sql.BatchParser.dll
  • runtimes\win\lib\net6.0\System.DirectoryServices.dll
  • Microsoft.Identity.Client.dll
  • runtimes\win\lib\net6.0\System.Drawing.Common.dll
  • Microsoft.Identity.Client.Extensions.Msal.dll
  • runtimes\win\lib\net6.0\System.Management.Automation.dll
  • Microsoft.IdentityModel.Clients.ActiveDirectory.dll
  • runtimes\win\lib\net6.0\System.Management.dll
  • Microsoft.IdentityModel.JsonWebTokens.dll
  • runtimes\win\lib\net6.0\System.Security.Cryptography.Pkcs.dll
  • Microsoft.IdentityModel.Logging.dll
  • runtimes\win\lib\net6.0\System.Security.Cryptography.ProtectedData.dll
  • Microsoft.IdentityModel.Protocols.dll
  • runtimes\win\lib\net6.0\System.Windows.Extensions.dll
  • Microsoft.IdentityModel.Protocols.OpenIdConnect.dll
  • runtimes\win\lib\netcoreapp2.0\System.Diagnostics.PerformanceCounter.dll
  • Microsoft.IdentityModel.Tokens.dll
  • runtimes\win\lib\netcoreapp3.1\Microsoft.Data.SqlClient.dll
  • Microsoft.SqlServer.Assessment.dll
  • runtimes\win\lib\netstandard2.0\System.Data.OleDb.dll
  • Microsoft.SqlServer.Assessment.Types.dll
  • runtimes\win\lib\netstandard2.0\System.Runtime.Caching.dll
  • Microsoft.SqlServer.ConnectionInfo.dll
  • runtimes\win-arm\lib\netstandard1.6\Microsoft.Management.Infrastructure.dll
  • Microsoft.SqlServer.Dmf.Common.dll
  • runtimes\win-arm\lib\netstandard1.6\Microsoft.Management.Infrastructure.Native.dll
  • Microsoft.SqlServer.Dmf.dll
  • runtimes\win-arm\native\mi.dll
  • Microsoft.SqlServer.Management.Assessment.dll
  • runtimes\win-arm\native\Microsoft.Data.SqlClient.SNI.dll
  • Microsoft.SqlServer.Management.Collector.dll
  • runtimes\win-arm\native\Microsoft.Management.Infrastructure.Native.Unmanaged.dll
  • Microsoft.SqlServer.Management.CollectorEnum.dll
  • runtimes\win-arm\native\miutils.dll
  • Microsoft.SqlServer.Management.HadrData.dll
  • runtimes\win-arm\native\PowerShell.Core.Instrumentation.dll
  • Microsoft.SqlServer.Management.HadrModel.dll
  • runtimes\win-arm\native\pwrshplugin.dll
  • Microsoft.SqlServer.Management.RegisteredServers.dll
  • runtimes\win-arm64\lib\netstandard1.6\Microsoft.Management.Infrastructure.dll
  • Microsoft.SqlServer.Management.Sdk.Sfc.dll
  • runtimes\win-arm64\lib\netstandard1.6\Microsoft.Management.Infrastructure.Native.dll
  • Microsoft.SqlServer.Management.SqlScriptPublish.dll
  • runtimes\win-arm64\native\mi.dll
  • Microsoft.SqlServer.Management.XEvent.dll
  • runtimes\win-arm64\native\Microsoft.Data.SqlClient.SNI.dll
  • Microsoft.SqlServer.Management.XEventDbScoped.dll
  • runtimes\win-arm64\native\Microsoft.Management.Infrastructure.Native.Unmanaged.dll
  • Microsoft.SqlServer.Management.XEventDbScopedEnum.dll
  • runtimes\win-arm64\native\miutils.dll
  • Microsoft.SqlServer.Management.XEventEnum.dll
  • runtimes\win-arm64\native\PowerShell.Core.Instrumentation.dll
  • Microsoft.SqlServer.PolicyEnum.dll
  • runtimes\win-arm64\native\pwrshplugin.dll
  • Microsoft.SqlServer.ServiceBrokerEnum.dll
  • runtimes\win-x64\native\Microsoft.Data.SqlClient.SNI.dll
  • Microsoft.SqlServer.Smo.dll
  • runtimes\win-x64\native\PowerShell.Core.Instrumentation.dll
  • Microsoft.SqlServer.Smo.Notebook.dll
  • runtimes\win-x64\native\pwrshplugin.dll
  • Microsoft.SqlServer.SmoExtended.dll
  • runtimes\win-x86\native\Microsoft.Data.SqlClient.SNI.dll
  • Microsoft.SqlServer.SqlEnum.dll
  • runtimes\win-x86\native\PowerShell.Core.Instrumentation.dll
  • Microsoft.SqlServer.SqlWmiManagement.dll
  • runtimes\win-x86\native\pwrshplugin.dll
  • Microsoft.SqlServer.WmiEnum.dll
  • runtimes\win10-x64\lib\netstandard1.6\Microsoft.Management.Infrastructure.dll
  • Microsoft.Win32.Registry.AccessControl.dll
  • runtimes\win10-x64\lib\netstandard1.6\Microsoft.Management.Infrastructure.Native.dll
  • Microsoft.Win32.SystemEvents.dll
  • runtimes\win10-x64\native\mi.dll
  • Newtonsoft.Json.dll
  • runtimes\win10-x64\native\Microsoft.Management.Infrastructure.Native.Unmanaged.dll
  • PsSmo.deps.json
  • runtimes\win10-x64\native\miutils.dll
  • PsSmo.dll
  • runtimes\win10-x86\lib\netstandard1.6\Microsoft.Management.Infrastructure.dll
  • runtimes\win10-x86\lib\netstandard1.6\Microsoft.Management.Infrastructure.Native.dll
  • PsSmo.pdb
  • runtimes\win10-x86\native\mi.dll
  • PsSmo.psd1
  • runtimes\win10-x86\native\Microsoft.Management.Infrastructure.Native.Unmanaged.dll
  • System.CodeDom.dll
  • runtimes\win10-x86\native\miutils.dll
  • System.Configuration.ConfigurationManager.dll
  • runtimes\win7-x64\lib\netstandard1.6\Microsoft.Management.Infrastructure.dll
  • System.Data.OleDb.dll
  • runtimes\win7-x64\lib\netstandard1.6\Microsoft.Management.Infrastructure.Native.dll
  • System.Diagnostics.EventLog.dll
  • runtimes\win7-x64\native\mi.dll
  • System.Diagnostics.PerformanceCounter.dll
  • runtimes\win7-x64\native\Microsoft.Management.Infrastructure.Native.Unmanaged.dll
  • System.DirectoryServices.dll
  • runtimes\win7-x64\native\miutils.dll
  • System.Drawing.Common.dll
  • runtimes\win7-x86\lib\netstandard1.6\Microsoft.Management.Infrastructure.dll
  • System.IdentityModel.Tokens.Jwt.dll
  • runtimes\win7-x86\lib\netstandard1.6\Microsoft.Management.Infrastructure.Native.dll
  • System.Management.dll
  • runtimes\win7-x86\native\mi.dll
  • System.Memory.Data.dll
  • runtimes\win7-x86\native\Microsoft.Management.Infrastructure.Native.Unmanaged.dll
  • System.Runtime.Caching.dll
  • runtimes\win7-x86\native\miutils.dll
  • System.Security.Cryptography.Pkcs.dll
  • runtimes\win8-x64\lib\netstandard1.6\Microsoft.Management.Infrastructure.dll
  • System.Security.Cryptography.ProtectedData.dll
  • runtimes\win8-x64\lib\netstandard1.6\Microsoft.Management.Infrastructure.Native.dll
  • System.Security.Permissions.dll
  • runtimes\win8-x64\native\mi.dll
  • System.Windows.Extensions.dll
  • runtimes\win8-x64\native\miutils.dll
  • en-US\PsSmo.dll-Help.xml
  • runtimes\win8-x86\lib\netstandard1.6\Microsoft.Management.Infrastructure.dll
  • runtimes\linux-arm\native\libpsl-native.so
  • runtimes\win8-x86\lib\netstandard1.6\Microsoft.Management.Infrastructure.Native.dll
  • runtimes\linux-arm64\native\libpsl-native.so
  • runtimes\win8-x86\native\mi.dll
  • runtimes\linux-musl-x64\native\libpsl-native.so
  • runtimes\win8-x86\native\miutils.dll
  • runtimes\linux-x64\native\libmi.so
  • runtimes\win81-x64\lib\netstandard1.6\Microsoft.Management.Infrastructure.dll
  • runtimes\linux-x64\native\libpsl-native.so
  • runtimes\win81-x64\lib\netstandard1.6\Microsoft.Management.Infrastructure.Native.dll
  • runtimes\linux-x64\native\libpsrpclient.so
  • runtimes\win81-x64\native\mi.dll
  • runtimes\osx\native\libmi.dylib
  • runtimes\win81-x64\native\Microsoft.Management.Infrastructure.Native.Unmanaged.dll
  • runtimes\osx\native\libpsl-native.dylib
  • runtimes\win81-x64\native\miutils.dll
  • runtimes\osx\native\libpsrpclient.dylib
  • runtimes\win81-x86\lib\netstandard1.6\Microsoft.Management.Infrastructure.dll
  • runtimes\unix\lib\net6.0\System.Drawing.Common.dll
  • runtimes\win81-x86\lib\netstandard1.6\Microsoft.Management.Infrastructure.Native.dll
  • runtimes\unix\lib\net6.0\System.Management.Automation.dll
  • runtimes\win81-x86\native\mi.dll
  • runtimes\unix\lib\netcoreapp3.1\Microsoft.Data.SqlClient.dll
  • runtimes\win81-x86\native\Microsoft.Management.Infrastructure.Native.Unmanaged.dll
  • runtimes\unix\lib\netstandard1.6\Microsoft.Management.Infrastructure.dll
  • runtimes\win81-x86\native\miutils.dll

Version History

Version Downloads Last updated
1.3.0-alpha0007 3,333 11/27/2023
1.2.1 3,580 9/7/2023
1.2.1-alpha0006 5 9/7/2023
1.2.1-alpha0005 5 9/6/2023
1.2.0 89 8/24/2023
1.1.0 (current version) 889 8/18/2022
1.0.0 12 8/18/2022
1.0.0-alpha0004 12 8/18/2022
1.0.0-alpha0003 10 8/18/2022
1.0.0-alpha0002 33 7/9/2022
0.5.0 121 10/15/2021
0.4.0 14 9/27/2021
0.3.0 14 9/16/2021
0.2.0 25 9/15/2021
0.1.0 15 9/12/2021
Show less