SimplySql

1.9.0

Querying SQL (SQL Server, Oracle, PostgreSql, SQLite, & mySql) the PowerShell way: simple commands... powerful opportunities.

SimplySql is a module that provides an intuitive set of cmdlets for talking to databases that abstracts the vendor specifics, allowing you to focus on getting work done.  The basic pattern is to connect to a database, execute one or more sql
Querying SQL (SQL Server, Oracle, PostgreSql, SQLite, & mySql) the PowerShell way: simple commands... powerful opportunities.

SimplySql is a module that provides an intuitive set of cmdlets for talking to databases that abstracts the vendor specifics, allowing you to focus on getting work done.  The basic pattern is to connect to a database, execute one or more sql statements and then close your database connection.  This module provides cmdlets that map to this basic pattern.  Each provider has its own Open-*Connection cmdlet -> Open-SqlConnection, Open-SQLiteConnection, Open-OracleConnection, Open-PostGreConnection, Open-MySqlConnection.  The rest of the commands are provider agnostic.

Open/Close/Show/Test/Set/Get -SqlConnection >> Control as many active connections as you want.
Invoke- SqlScalar/SqlQuery/SqlUpdate >> Interact with those connections.
Get/Clear -SqlMessage >> Get Informational messages, if provider supports it.
Invoke-SqlBulkCopy >> Bulk Dataload from one connection to another.
Start/Complete/Undo/Get -SqlTransaction >> Utilize transactions!
Show more

Minimum PowerShell version

5.0

Installation Options

Copy and Paste the following command to install this package using PowerShellGet More Info

Install-Module -Name SimplySql -RequiredVersion 1.9.0

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

Install-PSResource -Name SimplySql -Version 1.9.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 Mithrandyr. All rights reserved.

Package Details

Author(s)

  • Mithrandyr

Tags

SQL SQLite Database Oracle MySql PostGre Npgsql MSSQL

Dependencies

This module has no dependencies.

Release Notes

Currently Supporting Microsoft SQL, SQLite, MySql, PostGre and Oracle.  1.7 added support for retrieving the sqlconnection and sqltransaction objects.  1.8 enhanced support for notifications from BulkCopy.

FileList

  • SimplySql.nuspec
  • Classes.ps1
  • Cmdlets\xTest.ps1
  • DataReaderToPSObject\System.Diagnostics.Process.dll
  • DataReaderToPSObject\System.IO.MemoryMappedFiles.dll
  • DataReaderToPSObject\System.Reflection.dll
  • DataReaderToPSObject\System.Security.Cryptography.Csp.dll
  • DataReaderToPSObject\System.Xml.XDocument.dll
  • Providers\Oracle\Oracle.ManagedDataAccess.dll
  • DataReaderToPSObject\DataReaderToPSObject.dll
  • DataReaderToPSObject\System.Diagnostics.StackTrace.dll
  • DataReaderToPSObject\System.IO.Pipes.dll
  • DataReaderToPSObject\System.Reflection.Extensions.dll
  • DataReaderToPSObject\System.Security.Cryptography.Encoding.dll
  • DataReaderToPSObject\System.Xml.XmlDocument.dll
  • Providers\Oracle\provider.ps1
  • SimplySql.psd1
  • DataReaderToPSObject\DataReaderToPSObject.dll.config
  • DataReaderToPSObject\System.Diagnostics.TextWriterTraceListener.dll
  • DataReaderToPSObject\System.IO.UnmanagedMemoryStream.dll
  • DataReaderToPSObject\System.Reflection.Primitives.dll
  • DataReaderToPSObject\System.Security.Cryptography.Primitives.dll
  • DataReaderToPSObject\System.Xml.XmlSerializer.dll
  • Providers\PostGre\config.ps1
  • SimplySql.psm1
  • DataReaderToPSObject\Microsoft.Win32.Primitives.dll
  • DataReaderToPSObject\System.Diagnostics.Tools.dll
  • DataReaderToPSObject\System.Linq.dll
  • DataReaderToPSObject\System.Resources.Reader.dll
  • DataReaderToPSObject\System.Security.Cryptography.X509Certificates.dll
  • DataReaderToPSObject\System.Xml.XPath.dll
  • Providers\PostGre\GeoAPI.dll
  • Cmdlets\Clear-SqlMessage.ps1
  • DataReaderToPSObject\netstandard.dll
  • DataReaderToPSObject\System.Diagnostics.TraceSource.dll
  • DataReaderToPSObject\System.Linq.Expressions.dll
  • DataReaderToPSObject\System.Resources.ResourceManager.dll
  • DataReaderToPSObject\System.Security.Principal.dll
  • DataReaderToPSObject\System.Xml.XPath.XDocument.dll
  • Providers\PostGre\NetTopologySuite.dll
  • Cmdlets\Close-SqlConnection.ps1
  • DataReaderToPSObject\System.AppContext.dll
  • DataReaderToPSObject\System.Diagnostics.Tracing.dll
  • DataReaderToPSObject\System.Linq.Parallel.dll
  • DataReaderToPSObject\System.Resources.Writer.dll
  • DataReaderToPSObject\System.Security.SecureString.dll
  • en-US\about_SimplySql.help.txt
  • Providers\PostGre\NetTopologySuite.IO.PostGis.dll
  • Cmdlets\Complete-SqlTransaction.ps1
  • DataReaderToPSObject\System.Collections.Concurrent.dll
  • DataReaderToPSObject\System.Drawing.Primitives.dll
  • DataReaderToPSObject\System.Linq.Queryable.dll
  • DataReaderToPSObject\System.Runtime.CompilerServices.VisualC.dll
  • DataReaderToPSObject\System.Text.Encoding.dll
  • en-US\about_SimplySql_Providers.help.txt
  • Providers\PostGre\Npgsql.dll
  • Cmdlets\Get-SqlConnection.ps1
  • DataReaderToPSObject\System.Collections.dll
  • DataReaderToPSObject\System.Dynamic.Runtime.dll
  • DataReaderToPSObject\System.Net.Http.dll
  • DataReaderToPSObject\System.Runtime.dll
  • DataReaderToPSObject\System.Text.Encoding.Extensions.dll
  • Functions\TestConnectionName.ps1
  • Providers\PostGre\Npgsql.NetTopologySuite.dll
  • Cmdlets\Get-SqlMessage.ps1
  • DataReaderToPSObject\System.Collections.NonGeneric.dll
  • DataReaderToPSObject\System.Globalization.Calendars.dll
  • DataReaderToPSObject\System.Net.NameResolution.dll
  • DataReaderToPSObject\System.Runtime.Extensions.dll
  • DataReaderToPSObject\System.Text.RegularExpressions.dll
  • Providers\MySql\BouncyCastle.Crypto.dll
  • Providers\PostGre\provider.ps1
  • Cmdlets\Get-SqlTransaction.ps1
  • DataReaderToPSObject\System.Collections.Specialized.dll
  • DataReaderToPSObject\System.Globalization.dll
  • DataReaderToPSObject\System.Net.NetworkInformation.dll
  • DataReaderToPSObject\System.Runtime.Handles.dll
  • DataReaderToPSObject\System.Threading.dll
  • Providers\MySql\config.ps1
  • Providers\PostGre\System.Runtime.CompilerServices.Unsafe.dll
  • Cmdlets\Invoke-SqlBulkCopy.ps1
  • DataReaderToPSObject\System.ComponentModel.dll
  • DataReaderToPSObject\System.Globalization.Extensions.dll
  • DataReaderToPSObject\System.Net.Ping.dll
  • DataReaderToPSObject\System.Runtime.InteropServices.dll
  • DataReaderToPSObject\System.Threading.Overlapped.dll
  • Providers\MySql\Google.Protobuf.dll
  • Providers\PostGre\System.Threading.Tasks.Extensions.dll
  • Cmdlets\Invoke-SqlQuery.ps1
  • DataReaderToPSObject\System.ComponentModel.EventBasedAsync.dll
  • DataReaderToPSObject\System.IO.Compression.dll
  • DataReaderToPSObject\System.Net.Primitives.dll
  • DataReaderToPSObject\System.Runtime.InteropServices.RuntimeInformation.dll
  • DataReaderToPSObject\System.Threading.Tasks.dll
  • Providers\MySql\K4os.Compression.LZ4.Streams.dll
  • Providers\PostGre\System.ValueTuple.dll
  • Cmdlets\Invoke-SqlScalar.ps1
  • DataReaderToPSObject\System.ComponentModel.Primitives.dll
  • DataReaderToPSObject\System.IO.Compression.ZipFile.dll
  • DataReaderToPSObject\System.Net.Requests.dll
  • DataReaderToPSObject\System.Runtime.Numerics.dll
  • DataReaderToPSObject\System.Threading.Tasks.Parallel.dll
  • Providers\MySql\MySql.Data.dll
  • Providers\SQL\config.ps1
  • Cmdlets\Invoke-SqlUpdate.ps1
  • DataReaderToPSObject\System.ComponentModel.TypeConverter.dll
  • DataReaderToPSObject\System.IO.dll
  • DataReaderToPSObject\System.Net.Security.dll
  • DataReaderToPSObject\System.Runtime.Serialization.Formatters.dll
  • DataReaderToPSObject\System.Threading.Thread.dll
  • Providers\MySql\provider.ps1
  • Providers\SQLite\config.ps1
  • Cmdlets\Set-SqlConnection.ps1
  • DataReaderToPSObject\System.Console.dll
  • DataReaderToPSObject\System.IO.FileSystem.dll
  • DataReaderToPSObject\System.Net.Sockets.dll
  • DataReaderToPSObject\System.Runtime.Serialization.Json.dll
  • DataReaderToPSObject\System.Threading.ThreadPool.dll
  • Providers\MySql\System.Memory.dll
  • Providers\SQLite\provider.ps1
  • Cmdlets\Show-SqlConnection.ps1
  • DataReaderToPSObject\System.Data.Common.dll
  • DataReaderToPSObject\System.IO.FileSystem.DriveInfo.dll
  • DataReaderToPSObject\System.Net.WebHeaderCollection.dll
  • DataReaderToPSObject\System.Runtime.Serialization.Primitives.dll
  • DataReaderToPSObject\System.Threading.Timer.dll
  • Providers\MySql\Ubiety.Dns.Core.dll
  • Providers\SQLite\System.Data.SQLite.dll
  • Cmdlets\Start-SqlTransaction.ps1
  • DataReaderToPSObject\System.Diagnostics.Contracts.dll
  • DataReaderToPSObject\System.IO.FileSystem.Primitives.dll
  • DataReaderToPSObject\System.Net.WebSockets.Client.dll
  • DataReaderToPSObject\System.Runtime.Serialization.Xml.dll
  • DataReaderToPSObject\System.ValueTuple.dll
  • Providers\MySql\ZstdNet.dll
  • Providers\SQLite\x64\SQLite.Interop.dll
  • Cmdlets\Test-SqlConnection.ps1
  • DataReaderToPSObject\System.Diagnostics.Debug.dll
  • DataReaderToPSObject\System.IO.FileSystem.Watcher.dll
  • DataReaderToPSObject\System.Net.WebSockets.dll
  • DataReaderToPSObject\System.Security.Claims.dll
  • DataReaderToPSObject\System.Xml.ReaderWriter.dll
  • Providers\Oracle\config.ps1
  • Providers\SQLite\x86\SQLite.Interop.dll
  • Cmdlets\Undo-SqlTransaction.ps1
  • DataReaderToPSObject\System.Diagnostics.FileVersionInfo.dll
  • DataReaderToPSObject\System.IO.IsolatedStorage.dll
  • DataReaderToPSObject\System.ObjectModel.dll
  • DataReaderToPSObject\System.Security.Cryptography.Algorithms.dll

Version History

Version Downloads Last updated
2.0.2.70 56,564 3/2/2024
2.0.1.69 324 3/1/2024
2.0.0.67 25,191 2/9/2024
1.9.1 659,007 1/29/2023
1.9.0 (current version) 208,325 5/28/2022
1.8.0 122,477 4/2/2021
1.7.0 4,930 2/16/2021
1.6.2 63,881 2/26/2019
1.6.1 120 2/7/2019
1.6.0 57 2/7/2019
1.5.9 212 11/27/2018
1.5.4 154 10/5/2018
1.5.2 82 9/18/2018
1.5.1 56 9/4/2018
1.4.1 247 6/11/2018
1.4.0 1,249 5/16/2018
1.3.8 50 5/11/2018
1.3.7 41 5/9/2018
1.3.6 95 3/24/2018
1.3.5 41 3/22/2018
1.3.3 60 3/19/2018
1.3.2 120 2/12/2018
1.3.1 36 2/12/2018
1.3.0 37 2/12/2018
1.2.0 92 1/8/2018
1.1.1 98 11/30/2017
Show more