SimplySQL

Action Pack for SimplySQL

Note: The use of the scripts requires the PowerShell Module SimplySQL.

• Close-DMSSIMConnection.ps1

  Closes an existing connection

• Get-DMSSIMConnections.ps1

  Lists the specified or all SqlConnections

• Invoke-DMSSIMQuery.ps1

  Executes a query

• Invoke-DMSSIMQueryLib.ps1

  Executes a query using, library script functions

• Invoke-DMSSIMScalarQuery.ps1

  Executes a Scalar query against the targeted connection

• Invoke-DMSSIMScalarQueryLib.ps1

  Executes a Scalar query against the targeted connection, using library script functions

• Invoke-DMSSIMUpdateQuery.ps1

  Executes a query and returns number of record affected

• Invoke-DMSSIMUpdateQueryLib.ps1

  Executes a query and returns number of record affected, using library script functions

• Open-DMSSIMSQLConnection.ps1

  Open a connection to a SQL Server