SQLIse A Powershell Based SQL Server Query Tool

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:

{ 4 comments… add one }

  • Chad Miller March 10, 2010, 10:31 pm

    Oracle ISE, I like it! There was some talk of VSDB supporting Oracle, but even if it doesn’t you could build the query piece.

    Reply
  • Bernd Kriszio March 10, 2010, 10:31 pm

    Looks good. Would be nice to extend it to Oracle.

    Reply
  • Chad Miller March 10, 2010, 10:31 pm

    lol — Query Analyzer Lives!

    Reply
  • Aaron Nelson March 10, 2010, 10:31 pm

    This is AWESOME. Looks like you made Buck Woody’s wish come true. Query Analyzer Lives!

    Reply

Leave a Comment


two × = 6

%d bloggers like this: