PsSqlClient

1.4.0-alpha0021

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

Minimum PowerShell version

7.0

This is a prerelease version of PsSqlClient.
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.4.0-alpha0021 -AllowPrerelease

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

Install-PSResource -Name PsSqlClient -Version 1.4.0-alpha0021 -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) 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\System.Management.Automation.dll
  • Azure.Identity.dll
  • runtimes\win\lib\netcoreapp3.1\System.Runtime.Caching.dll
  • Microsoft.ApplicationInsights.dll
  • runtimes\win\lib\netcoreapp3.1\System.Text.Encoding.CodePages.dll
  • Microsoft.Bcl.AsyncInterfaces.dll
  • runtimes\win\lib\netcoreapp3.1\System.Windows.Extensions.dll
  • Microsoft.Data.SqlClient.dll
  • runtimes\win\lib\netstandard2.0\Microsoft.Win32.Registry.AccessControl.dll
  • Microsoft.Identity.Client.dll
  • runtimes\win\lib\netstandard2.0\Microsoft.Win32.Registry.dll
  • Microsoft.Identity.Client.Extensions.Msal.dll
  • runtimes\win\lib\netstandard2.0\System.Security.AccessControl.dll
  • Microsoft.IdentityModel.Abstractions.dll
  • runtimes\win\lib\netstandard2.0\System.Security.Cryptography.ProtectedData.dll
  • Microsoft.IdentityModel.JsonWebTokens.dll
  • runtimes\win\lib\netstandard2.1\Microsoft.Data.SqlClient.dll
  • Microsoft.IdentityModel.Logging.dll
  • runtimes\win-arm\lib\netstandard1.6\Microsoft.Management.Infrastructure.dll
  • Microsoft.IdentityModel.Protocols.dll
  • runtimes\win-arm\lib\netstandard1.6\Microsoft.Management.Infrastructure.Native.dll
  • Microsoft.IdentityModel.Protocols.OpenIdConnect.dll
  • runtimes\win-arm\native\mi.dll
  • Microsoft.IdentityModel.Tokens.dll
  • runtimes\win-arm\native\Microsoft.Data.SqlClient.SNI.dll
  • Microsoft.SqlServer.Server.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.EventLog.dll
  • runtimes\win-x64\native\PowerShell.Core.Instrumentation.dll
  • System.DirectoryServices.dll
  • runtimes\win-x64\native\pwrshplugin.dll
  • System.Drawing.Common.dll
  • runtimes\win-x86\native\Microsoft.Data.SqlClient.SNI.dll
  • System.Formats.Asn1.dll
  • runtimes\win-x86\native\PowerShell.Core.Instrumentation.dll
  • System.IdentityModel.Tokens.Jwt.dll
  • runtimes\win-x86\native\pwrshplugin.dll
  • System.Management.dll
  • runtimes\win10-x64\lib\netstandard1.6\Microsoft.Management.Infrastructure.dll
  • System.Memory.Data.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.Text.Json.dll
  • runtimes\win7-x64\native\mi.dll
  • System.Windows.Extensions.dll
  • runtimes\win7-x64\native\Microsoft.Management.Infrastructure.Native.Unmanaged.dll
  • en-US\PsSqlClient.dll-Help.xml
  • runtimes\win7-x64\native\miutils.dll
  • runtimes\linux-arm\native\libpsl-native.so
  • runtimes\win7-x86\lib\netstandard1.6\Microsoft.Management.Infrastructure.dll
  • runtimes\linux-arm64\native\libpsl-native.so
  • runtimes\win7-x86\lib\netstandard1.6\Microsoft.Management.Infrastructure.Native.dll
  • runtimes\linux-musl-x64\native\libpsl-native.so
  • runtimes\win7-x86\native\mi.dll
  • runtimes\linux-x64\native\libmi.so
  • runtimes\win7-x86\native\Microsoft.Management.Infrastructure.Native.Unmanaged.dll
  • runtimes\linux-x64\native\libpsl-native.so
  • runtimes\win7-x86\native\miutils.dll
  • runtimes\linux-x64\native\libpsrpclient.so
  • runtimes\win8-x64\lib\netstandard1.6\Microsoft.Management.Infrastructure.dll
  • runtimes\osx\native\libmi.dylib
  • runtimes\win8-x64\lib\netstandard1.6\Microsoft.Management.Infrastructure.Native.dll
  • runtimes\osx\native\libpsl-native.dylib
  • runtimes\win8-x64\native\mi.dll
  • runtimes\osx\native\libpsrpclient.dylib
  • runtimes\win8-x64\native\miutils.dll
  • runtimes\unix\lib\netcoreapp2.1\System.Security.Principal.Windows.dll
  • runtimes\win8-x86\lib\netstandard1.6\Microsoft.Management.Infrastructure.dll
  • runtimes\unix\lib\netcoreapp3.1\System.Drawing.Common.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\unix\lib\netstandard2.1\Microsoft.Data.SqlClient.dll
  • runtimes\win81-x64\lib\netstandard1.6\Microsoft.Management.Infrastructure.dll
  • runtimes\win\lib\netcoreapp2.0\System.Diagnostics.EventLog.dll
  • runtimes\win81-x64\lib\netstandard1.6\Microsoft.Management.Infrastructure.Native.dll
  • runtimes\win\lib\netcoreapp2.0\System.DirectoryServices.dll
  • runtimes\win81-x64\native\mi.dll
  • runtimes\win\lib\netcoreapp2.0\System.Management.dll
  • runtimes\win81-x64\native\Microsoft.Management.Infrastructure.Native.Unmanaged.dll
  • runtimes\win\lib\netcoreapp2.1\System.Security.Principal.Windows.dll
  • runtimes\win81-x64\native\miutils.dll
  • runtimes\win\lib\netcoreapp3.0\System.Security.Cryptography.Cng.dll
  • runtimes\win81-x86\lib\netstandard1.6\Microsoft.Management.Infrastructure.dll
  • runtimes\win\lib\netcoreapp3.0\System.Security.Cryptography.Pkcs.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\Microsoft.Win32.SystemEvents.dll
  • runtimes\win81-x86\native\Microsoft.Management.Infrastructure.Native.Unmanaged.dll
  • runtimes\win\lib\netcoreapp3.1\System.Drawing.Common.dll
  • runtimes\win81-x86\native\miutils.dll

Version History

Version Downloads Last updated
2.2.0-alpha0031 3,336 11/27/2023
2.1.1-alpha0030 557 8/16/2023
2.1.0 10,290 8/3/2023
2.1.0-alpha0029 8 8/2/2023
2.0.1 19 8/2/2023
2.0.0 121 7/19/2023
2.0.0-alpha0028 166 5/30/2023
1.5.0 951 4/3/2023
1.5.0-alpha0027 5 4/3/2023
1.5.0-alpha0026 10 3/29/2023
1.4.0 253 2/23/2023
1.4.0-alpha0025 5 2/23/2023
1.4.0-alpha0024 5 2/21/2023
1.4.0-alpha0023 6 2/16/2023
1.4.0-alpha0022 5 2/16/2023
1.4.0-alpha0021 (current version) 5 2/16/2023
1.4.0-alpha0020 5 2/16/2023
1.4.0-alpha0019 5 2/16/2023
1.4.0-alpha0017 5 2/16/2023
1.4.0-alpha0016 6 2/15/2023
1.4.0-alpha0015 30 11/23/2022
1.3.1 1,126 5/30/2022
1.3.1-alpha0014 190 5/30/2022
1.3.1-alpha0013 201 5/19/2022
1.3.0 251 5/12/2022
1.2.0 362 3/24/2022
1.2.0-alpha0012 211 3/23/2022
1.1.0 221 3/23/2022
1.1.0-alpha0011 215 3/21/2022
1.1.0-alpha0010 213 3/20/2022
1.1.0-alpha0009 267 3/19/2022
1.1.0-alpha0008 215 3/19/2022
1.1.0-alpha0007 219 3/19/2022
1.0.0 228 3/18/2022
1.0.0-alpha0006 211 3/18/2022
1.0.0-alpha0005 214 3/15/2022
1.0.0-alpha0004 211 3/14/2022
1.0.0-alpha0003 214 3/14/2022
0.4.0 361 11/3/2021
0.3.0 230 9/16/2021
0.2.0 217 9/15/2021
0.1 222 9/12/2021
Show less