A simple GUI tool to help use Microsoft.SqlServer.TransactSql.ScriptDom
I created this tool when I was learning on how to use the library to analyze T-SQL scripts. It basically contains a treeview to show the hierarchical structure of the SQL scripts, showing each fragment's properties, and generating formatted SQL scripts.
- You can pipe SQL scripts to the tool by using
"select * from foo" | TsqlScriptDom.exe - - You can pass multiple SQL files to the tool from command line
- You can drag & drop files onto the SQL script pane
- You can open a new window by select some SQL scripts to parse them alone
- Select a tree node will also select the corresponding SQL scripts in the editor
- Double click a location in the editor, or use menu item "Tools/Locate in Tree" to locate the corresponding node in treeview