PsSqlClient

1.3.1

The PowerShell SQL Client module replaces the SQL Server utilities SQLCMD and BCP 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 PsSqlClient -RequiredVersion 1.3.1

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

Install-PSResource -Name PsSqlClient -Version 1.3.1

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) 2020 Steffen Kampmann. Alle Rechte vorbehalten.

Package Details

Author(s)

  • Steffen Kampmann

Tags

sql sqlserver sqlclient

Cmdlets

Connect-Instance Disconnect-Instance Get-Value Invoke-Command Invoke-Procedure Export-Table

Dependencies

This module has no dependencies.

FileList

  • PsSqlClient.nuspec
  • Azure.Core.dll
  • runtimes\win\lib\netcoreapp3.1\Microsoft.Data.SqlClient.dll
  • Azure.Identity.dll
  • runtimes\win\lib\netcoreapp3.1\Microsoft.PowerShell.CoreCLR.Eventing.dll
  • Microsoft.ApplicationInsights.dll
  • runtimes\win\lib\netcoreapp3.1\System.Management.Automation.dll
  • Microsoft.Bcl.AsyncInterfaces.dll
  • runtimes\win\lib\netstandard2.0\Microsoft.Win32.Registry.AccessControl.dll
  • Microsoft.Data.SqlClient.dll
  • runtimes\win\lib\netstandard2.0\Microsoft.Win32.Registry.dll
  • Microsoft.Identity.Client.dll
  • runtimes\win\lib\netstandard2.0\System.Runtime.Caching.dll
  • Microsoft.Identity.Client.Extensions.Msal.dll
  • runtimes\win\lib\netstandard2.0\System.Security.Cryptography.ProtectedData.dll
  • Microsoft.IdentityModel.JsonWebTokens.dll
  • runtimes\win-arm\lib\netstandard1.6\Microsoft.Management.Infrastructure.dll
  • Microsoft.IdentityModel.Logging.dll
  • runtimes\win-arm\lib\netstandard1.6\Microsoft.Management.Infrastructure.Native.dll
  • Microsoft.IdentityModel.Protocols.dll
  • runtimes\win-arm\native\mi.dll
  • Microsoft.IdentityModel.Protocols.OpenIdConnect.dll
  • runtimes\win-arm\native\Microsoft.Data.SqlClient.SNI.dll
  • Microsoft.IdentityModel.Tokens.dll
  • runtimes\win-arm\native\Microsoft.Management.Infrastructure.Native.Unmanaged.dll
  • Microsoft.Win32.Registry.AccessControl.dll
  • runtimes\win-arm\native\miutils.dll
  • Microsoft.Win32.Registry.dll
  • runtimes\win-arm\native\PowerShell.Core.Instrumentation.dll
  • Microsoft.Win32.SystemEvents.dll
  • runtimes\win-arm\native\pwrshplugin.dll
  • Newtonsoft.Json.dll
  • runtimes\win-arm64\lib\netstandard1.6\Microsoft.Management.Infrastructure.dll
  • PsSqlClient.deps.json
  • runtimes\win-arm64\lib\netstandard1.6\Microsoft.Management.Infrastructure.Native.dll
  • PsSqlClient.dll
  • runtimes\win-arm64\native\mi.dll
  • runtimes\win-arm64\native\Microsoft.Data.SqlClient.SNI.dll
  • PsSqlClient.pdb
  • runtimes\win-arm64\native\Microsoft.Management.Infrastructure.Native.Unmanaged.dll
  • PsSqlClient.psd1
  • runtimes\win-arm64\native\miutils.dll
  • PsSqlClient.psm1
  • runtimes\win-arm64\native\PowerShell.Core.Instrumentation.dll
  • System.CodeDom.dll
  • runtimes\win-arm64\native\pwrshplugin.dll
  • System.Configuration.ConfigurationManager.dll
  • runtimes\win-x64\native\Microsoft.Data.SqlClient.SNI.dll
  • System.Diagnostics.DiagnosticSource.dll
  • runtimes\win-x64\native\PowerShell.Core.Instrumentation.dll
  • System.Diagnostics.EventLog.dll
  • runtimes\win-x64\native\pwrshplugin.dll
  • System.DirectoryServices.dll
  • runtimes\win-x86\native\Microsoft.Data.SqlClient.SNI.dll
  • System.Drawing.Common.dll
  • runtimes\win-x86\native\PowerShell.Core.Instrumentation.dll
  • System.Formats.Asn1.dll
  • runtimes\win-x86\native\pwrshplugin.dll
  • System.IdentityModel.Tokens.Jwt.dll
  • runtimes\win10-x64\lib\netstandard1.6\Microsoft.Management.Infrastructure.dll
  • System.Management.dll
  • runtimes\win10-x64\lib\netstandard1.6\Microsoft.Management.Infrastructure.Native.dll
  • System.Runtime.Caching.dll
  • runtimes\win10-x64\native\mi.dll
  • System.Runtime.CompilerServices.Unsafe.dll
  • runtimes\win10-x64\native\Microsoft.Management.Infrastructure.Native.Unmanaged.dll
  • System.Security.AccessControl.dll
  • runtimes\win10-x64\native\miutils.dll
  • System.Security.Cryptography.Cng.dll
  • runtimes\win10-x86\lib\netstandard1.6\Microsoft.Management.Infrastructure.dll
  • System.Security.Cryptography.Pkcs.dll
  • runtimes\win10-x86\lib\netstandard1.6\Microsoft.Management.Infrastructure.Native.dll
  • System.Security.Cryptography.ProtectedData.dll
  • runtimes\win10-x86\native\mi.dll
  • System.Security.Permissions.dll
  • runtimes\win10-x86\native\Microsoft.Management.Infrastructure.Native.Unmanaged.dll
  • System.Security.Principal.Windows.dll
  • runtimes\win10-x86\native\miutils.dll
  • System.Text.Encoding.CodePages.dll
  • runtimes\win7-x64\lib\netstandard1.6\Microsoft.Management.Infrastructure.dll
  • System.Text.Encodings.Web.dll
  • runtimes\win7-x64\lib\netstandard1.6\Microsoft.Management.Infrastructure.Native.dll
  • System.Windows.Extensions.dll
  • runtimes\win7-x64\native\mi.dll
  • en-US\PsSqlClient.dll-Help.xml
  • runtimes\win7-x64\native\Microsoft.Management.Infrastructure.Native.Unmanaged.dll
  • runtimes\linux-arm\native\libpsl-native.so
  • runtimes\win7-x64\native\miutils.dll
  • runtimes\linux-arm64\native\libpsl-native.so
  • runtimes\win7-x86\lib\netstandard1.6\Microsoft.Management.Infrastructure.dll
  • runtimes\linux-musl-x64\native\libpsl-native.so
  • runtimes\win7-x86\lib\netstandard1.6\Microsoft.Management.Infrastructure.Native.dll
  • runtimes\linux-x64\native\libmi.so
  • runtimes\win7-x86\native\mi.dll
  • runtimes\linux-x64\native\libpsl-native.so
  • runtimes\win7-x86\native\Microsoft.Management.Infrastructure.Native.Unmanaged.dll
  • runtimes\linux-x64\native\libpsrpclient.so
  • runtimes\win7-x86\native\miutils.dll
  • runtimes\osx\native\libmi.dylib
  • runtimes\win8-x64\lib\netstandard1.6\Microsoft.Management.Infrastructure.dll
  • runtimes\osx\native\libpsl-native.dylib
  • runtimes\win8-x64\lib\netstandard1.6\Microsoft.Management.Infrastructure.Native.dll
  • runtimes\osx\native\libpsrpclient.dylib
  • runtimes\win8-x64\native\mi.dll
  • runtimes\unix\lib\netcoreapp2.1\System.Security.Principal.Windows.dll
  • runtimes\win8-x64\native\miutils.dll
  • runtimes\unix\lib\netcoreapp3.0\System.Drawing.Common.dll
  • runtimes\win8-x86\lib\netstandard1.6\Microsoft.Management.Infrastructure.dll
  • runtimes\unix\lib\netcoreapp3.1\Microsoft.Data.SqlClient.dll
  • runtimes\win8-x86\lib\netstandard1.6\Microsoft.Management.Infrastructure.Native.dll
  • runtimes\unix\lib\netcoreapp3.1\System.Management.Automation.dll
  • runtimes\win8-x86\native\mi.dll
  • runtimes\unix\lib\netstandard1.6\Microsoft.Management.Infrastructure.dll
  • runtimes\win8-x86\native\miutils.dll
  • runtimes\win\lib\netcoreapp2.0\System.Diagnostics.EventLog.dll
  • runtimes\win81-x64\lib\netstandard1.6\Microsoft.Management.Infrastructure.dll
  • runtimes\win\lib\netcoreapp2.0\System.DirectoryServices.dll
  • runtimes\win81-x64\lib\netstandard1.6\Microsoft.Management.Infrastructure.Native.dll
  • runtimes\win\lib\netcoreapp2.0\System.Management.dll
  • runtimes\win81-x64\native\mi.dll
  • runtimes\win\lib\netcoreapp2.0\System.Security.AccessControl.dll
  • runtimes\win81-x64\native\Microsoft.Management.Infrastructure.Native.Unmanaged.dll
  • runtimes\win\lib\netcoreapp2.0\System.Text.Encoding.CodePages.dll
  • runtimes\win81-x64\native\miutils.dll
  • runtimes\win\lib\netcoreapp2.1\System.Security.Principal.Windows.dll
  • runtimes\win81-x86\lib\netstandard1.6\Microsoft.Management.Infrastructure.dll
  • runtimes\win\lib\netcoreapp3.0\Microsoft.Win32.SystemEvents.dll
  • runtimes\win81-x86\lib\netstandard1.6\Microsoft.Management.Infrastructure.Native.dll
  • runtimes\win\lib\netcoreapp3.0\System.Drawing.Common.dll
  • runtimes\win81-x86\native\mi.dll
  • runtimes\win\lib\netcoreapp3.0\System.Security.Cryptography.Cng.dll
  • runtimes\win81-x86\native\Microsoft.Management.Infrastructure.Native.Unmanaged.dll
  • runtimes\win\lib\netcoreapp3.0\System.Security.Cryptography.Pkcs.dll
  • runtimes\win81-x86\native\miutils.dll
  • runtimes\win\lib\netcoreapp3.0\System.Windows.Extensions.dll

Version History

Version Downloads Last updated
2.2.0-alpha0031 8,880 11/27/2023
2.1.1-alpha0030 558 8/16/2023
2.1.0 21,497 8/3/2023
2.1.0-alpha0029 9 8/2/2023
2.0.1 20 8/2/2023
2.0.0 122 7/19/2023
2.0.0-alpha0028 167 5/30/2023
1.5.0 1,020 4/3/2023
1.5.0-alpha0027 6 4/3/2023
1.5.0-alpha0026 11 3/29/2023
1.4.0 254 2/23/2023
1.4.0-alpha0025 6 2/23/2023
1.4.0-alpha0024 6 2/21/2023
1.4.0-alpha0023 7 2/16/2023
1.4.0-alpha0022 6 2/16/2023
1.4.0-alpha0021 6 2/16/2023
1.4.0-alpha0020 6 2/16/2023
1.4.0-alpha0019 6 2/16/2023
1.4.0-alpha0017 6 2/16/2023
1.4.0-alpha0016 7 2/15/2023
1.4.0-alpha0015 31 11/23/2022
1.3.1 (current version) 1,151 5/30/2022
1.3.1-alpha0014 191 5/30/2022
1.3.1-alpha0013 202 5/19/2022
1.3.0 252 5/12/2022
1.2.0 363 3/24/2022
1.2.0-alpha0012 212 3/23/2022
1.1.0 222 3/23/2022
1.1.0-alpha0011 216 3/21/2022
1.1.0-alpha0010 214 3/20/2022
1.1.0-alpha0009 268 3/19/2022
1.1.0-alpha0008 216 3/19/2022
1.1.0-alpha0007 220 3/19/2022
1.0.0 229 3/18/2022
1.0.0-alpha0006 212 3/18/2022
1.0.0-alpha0005 215 3/15/2022
1.0.0-alpha0004 212 3/14/2022
1.0.0-alpha0003 215 3/14/2022
0.4.0 362 11/3/2021
0.3.0 231 9/16/2021
0.2.0 218 9/15/2021
0.1 223 9/12/2021
Show less