PsSqlClient

1.1.0

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.1.0

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

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

Version History

Version Downloads Last updated
2.2.0-alpha0031 1,352 11/27/2023
2.1.1-alpha0030 555 8/16/2023
2.1.0 4,502 8/3/2023
2.1.0-alpha0029 7 8/2/2023
2.0.1 17 8/2/2023
2.0.0 120 7/19/2023
2.0.0-alpha0028 165 5/30/2023
1.5.0 876 4/3/2023
1.5.0-alpha0027 4 4/3/2023
1.5.0-alpha0026 9 3/29/2023
1.4.0 252 2/23/2023
1.4.0-alpha0025 4 2/23/2023
1.4.0-alpha0024 4 2/21/2023
1.4.0-alpha0023 5 2/16/2023
1.4.0-alpha0022 4 2/16/2023
1.4.0-alpha0021 4 2/16/2023
1.4.0-alpha0020 4 2/16/2023
1.4.0-alpha0019 4 2/16/2023
1.4.0-alpha0017 4 2/16/2023
1.4.0-alpha0016 5 2/15/2023
1.4.0-alpha0015 29 11/23/2022
1.3.1 1,114 5/30/2022
1.3.1-alpha0014 189 5/30/2022
1.3.1-alpha0013 200 5/19/2022
1.3.0 250 5/12/2022
1.2.0 361 3/24/2022
1.2.0-alpha0012 210 3/23/2022
1.1.0 (current version) 220 3/23/2022
1.1.0-alpha0011 214 3/21/2022
1.1.0-alpha0010 212 3/20/2022
1.1.0-alpha0009 266 3/19/2022
1.1.0-alpha0008 214 3/19/2022
1.1.0-alpha0007 218 3/19/2022
1.0.0 227 3/18/2022
1.0.0-alpha0006 210 3/18/2022
1.0.0-alpha0005 213 3/15/2022
1.0.0-alpha0004 210 3/14/2022
1.0.0-alpha0003 213 3/14/2022
0.4.0 360 11/3/2021
0.3.0 229 9/16/2021
0.2.0 216 9/15/2021
0.1 221 9/12/2021
Show less