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.
- 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
- 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.
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.