SimplySql
1.4.1
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
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 -SqlTransaction >> Utilize transactions!
Show more
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 -SqlTransaction >> Utilize transactions!
Minimum PowerShell version
5.0
Installation Options
Owners
Copyright
(c) 2017 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. Check project repository for Release Notes.
FileList
- SimplySql.nuspec
- Classes.ps1
- DataReaderToPSObject.dll
- SimplySql.psd1
- SimplySql.psm1
- Cmdlets\Clear-SqlMessage.ps1
- Cmdlets\Close-SqlConnection.ps1
- Cmdlets\Complete-SqlTransaction.ps1
- Cmdlets\Get-SqlConnection.ps1
- Cmdlets\Get-SqlMessage.ps1
- Cmdlets\Invoke-SqlBulkCopy.ps1
- Cmdlets\Invoke-SqlQuery.ps1
- Cmdlets\Invoke-SqlScalar.ps1
- Cmdlets\Invoke-SqlUpdate.ps1
- Cmdlets\Set-SqlConnection.ps1
- Cmdlets\Show-SqlConnection.ps1
- Cmdlets\Start-SqlTransaction.ps1
- Cmdlets\Test-SqlConnection.ps1
- Cmdlets\Undo-SqlTransaction.ps1
- Cmdlets\xTest.ps1
- en-US\about_SimplySql.help.txt
- en-US\about_SimplySql_Providers.help.txt
- Functions\TestConnectionName.ps1
- Providers\MySql\config.ps1
- Providers\MySql\MySql.Data.dll
- Providers\MySql\provider.ps1
- Providers\Oracle\config.ps1
- Providers\Oracle\Oracle.ManagedDataAccess.dll
- Providers\Oracle\provider.ps1
- Providers\PostGre\config.ps1
- Providers\PostGre\Npgsql.dll
- Providers\PostGre\provider.ps1
- Providers\PostGre\System.Threading.Tasks.Extensions.dll
- Providers\SQL\config.ps1
- Providers\SQLite\config.ps1
- Providers\SQLite\provider.ps1
- Providers\SQLite\System.Data.SQLite.dll
- Providers\SQLite\x64\SQLite.Interop.dll
- Providers\SQLite\x86\SQLite.Interop.dll
Version History
| Version | Downloads | Last updated |
|---|---|---|
| 2.0.4.75 | 197,582 | 6/15/2024 |
| 2.0.3.73 | 55,509 | 5/11/2024 |
| 2.0.2.70 | 106,997 | 3/2/2024 |
| 2.0.1.69 | 325 | 3/1/2024 |
| 2.0.0.67 | 25,220 | 2/9/2024 |
| 1.9.1 | 665,101 | 1/29/2023 |
| 1.9.0 | 213,980 | 5/28/2022 |
| 1.8.0 | 123,910 | 4/2/2021 |
| 1.7.0 | 4,933 | 2/16/2021 |
| 1.6.2 | 64,251 | 2/26/2019 |
| 1.6.1 | 122 | 2/7/2019 |
| 1.6.0 | 60 | 2/7/2019 |
| 1.5.9 | 216 | 11/27/2018 |
| 1.5.4 | 155 | 10/5/2018 |
| 1.5.2 | 83 | 9/18/2018 |
| 1.5.1 | 57 | 9/4/2018 |
| 1.4.1 (current version) | 248 | 6/11/2018 |
| 1.4.0 | 1,253 | 5/16/2018 |
| 1.3.8 | 51 | 5/11/2018 |
| 1.3.7 | 42 | 5/9/2018 |
| 1.3.6 | 96 | 3/24/2018 |
| 1.3.5 | 42 | 3/22/2018 |
| 1.3.3 | 61 | 3/19/2018 |
| 1.3.2 | 122 | 2/12/2018 |
| 1.3.1 | 37 | 2/12/2018 |
| 1.3.0 | 39 | 2/12/2018 |
| 1.2.0 | 94 | 1/8/2018 |
| 1.1.1 | 100 | 11/30/2017 |