PowerSql
PowerSql is a simple powershell snapin for easy execution of sql commands. There are 2 flavors - OleDb and SqlServer specific commands.
The current cmdlets include:
Get-SqlData - returns strongly typed objects
Get-OleDbData - returns strongly typed objects
Get-SqlDataSet
Get-OleDbDataSet
Invoke-SqlCommand - returns number of rows affected
Invoke-OleDbCommand - returns number of rows affected
update: These cmdlets have been included in Powershell Community Extentions - the source is available from codeplex @ http://www.codeplex.com/PowerShellCX
2/4/2008 12:00:00 AM
Published by
admin
Category
Powershell
Back