SimplySql

1.3.2

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 -SqlTransaction >> Utilize transactions!

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

You can deploy this package directly to Azure Automation. Note that deploying packages with dependencies will deloy 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

Author(s)

Mithrandyr

Copyright

(c) 2017 Mithrandyr. All rights reserved.

Owners

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.  (Latest Nuget Packages as of 2018/2/12)  Added support for Sql Azure

Version History

Version Downloads Last updated
1.5.4 43 10/5/2018
1.5.2 52 9/18/2018
1.5.1 24 9/4/2018
1.4.1 219 6/11/2018
1.4.0 55 5/16/2018
1.3.8 12 5/11/2018
1.3.7 7 5/9/2018
1.3.6 59 3/24/2018
1.3.5 7 3/22/2018
1.3.3 11 3/19/2018
1.3.2 (current version) 66 2/12/2018
1.3.1 2 2/12/2018
1.3.0 3 2/12/2018
1.2.0 50 1/8/2018
1.1.1 43 11/30/2017
Show less