SQL Server Powershell Powershell Extensions (SQLPSX) has been updated to version 2.1. The most notable change is the addition of a Powershell Integrated Scripting Editor (ISE) module called SQLIse (pronounced “SQL Ice”). The module provides a basic IDE for T-SQL that includes the ability to edit, execute, parse and format SQL code from within Powershell ISE.
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
SQLIse Requirements
SQLIse uses the following modules that part of the CodePlex project SQLPSX as well as PowershellPack available on MSDN Code Gallery:
- SQLParser (SQLPSX)
- AdoLib (SQLPSX)
- IsePack (PowershellPack)
- WPK (PowershellPack)
NOTE: The use of external modules is a change for SQLPSX, however sometimes its important to leverage other people’s code to greatly simplify your own. So, in order to use SQLIse you’ll need to install both SQLPSX and the PowershellPack.
Credits
A big thanks to Mike Shepard for creating the AdoLib module and James Brundage for his excellent WPK and IsePack modules that make creating GUIs and customizing Powershell ISE seem easy.
Next Steps
Check out this 5 minute video of SQLIse: and leave some feedback on the SQLPSX site:
