PsSmo

1.0.0-alpha0004

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

Minimum PowerShell version

7.0

This is a prerelease version of PsSmo.
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.0.0-alpha0004 -AllowPrerelease

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

Install-PSResource -Name PsSmo -Version 1.0.0-alpha0004 -Prerelease

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

Version History

Version Downloads Last updated
1.3.0-alpha0007 3,338 11/27/2023
1.2.1 3,595 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 889 8/18/2022
1.0.0 12 8/18/2022
1.0.0-alpha0004 (current version) 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