After the first release of SQLIse (“SQL Ice”)--a basic IDE for T-SQL that includes ability to edit, execute, parse, format SQL code from within PowerShell ISE, several people contacted me to help add new features. The result is SQL Server PowerShell Extensions (SQLPSX) 2.2 with many enhancements to SQLIse…
SQLIse Features
- Offline parsing of T-SQL code
- Formatting (prettifying) of T-SQL with an extensive customization abilities
- Comment/Uncomment T-SQL code
- Uppercase/Lowercase T-SQL code
- Execute T-SQL code and output to grid, text, text file or CSV file
- Apply any of the above actions to selections of code by highlighting
- Table and object browsers*
- PoshMode (like sqlcmdmode)*
- Save output to variable*
- Save and manage connections*
- Tab Expansion of schemas, tables, views, functions, procedures, columns and parameters.*
- OracleIse module*
- OracleClient module used by OracleIse*
- Redistributed WPK and ISECreamBasic modules from PowerShellPack and ISECream projects*
- Created an SQLPSX installer*
* = New features for release 2.2
Credits
My thanks to
- Steve Murawski for his work creating most of the new GUIs (table/object browsers, saved connections, and output to variable).
- Bernd Kriszio for his work in adding a slimmed down ISE menu module, IceCreamBasic, all of the Oracle components and his willingness to test and provide feedback to the rest us
- Max Trinidad put a lot of work into creating an installer for SQLPSX built entirely in PowerShell. Max was very patient in our requests to build several interactions of the installer as we worked through various scenarios.
Next Steps
- Download SQLPSX
- Check out the SQLIse screen shots
- Watch the 10 minute SQLIse video
www.youtube.com/watch?v=8WoZ5aUsNwM
2.2
