SQLShell is an extension of the Microsoft Windows PowerShell to provide DBAs a tool to query or manage they owner database. Right, we already have the command line tool sqlcmd.exe, bcp.exe and so on. But do you think those are strong enough for all your daily uses. Definitely no. So what I will do is to extend the PowerShell to recoginze the SQL Server instances as drives in the shell, and [database]\tables\[table] as the path (database, table will be the substitite to the real database, table name), it will support view and stored procedures as well. Under that you can see the SQL script for the tables, or the data for the tables, you can use things like ”mytable | where {$_.age < 30} | sort {$_.salary}" inside the windows shell.
Right now the project is in planning/designing phase. Any ideas are welcome.
This is the extension of PowerShell and released under BSD license.
|
