Here we are:
Beta-Release v2.6
http://www.ssmsboost.com...r2008_2.6.4660.29434.msi http://www.ssmsboost.com...r2012_2.6.4660.31272.msi Links are active until release to public.
Important for v 2.5 users: to get updated "ResultsGrid:Scripting Templates" please after installation go to settings and delete ALL Scripting templates and restart SSMS. New default improved templates will be created. One of them is template that allows to get all results grid into Excel with 1 click !
Changelog v 2.6
NEW FEATURES:
-Jump to parent BEGIN or END statement in SQL code.
Command is available via Ctrl+Shift-UpArrow / Ctrl+Shift-DownArrow shortcuts or via SQL Editor context menue.
-Added support for Registered Servers functionality of SSMS (View->Registered Servers):
-Added "Expand All"/"Collapse All" commands to "Local Server Groups" context menue as well as for all subfolders.
-Added commands to context menue of registered servers:
-Set as active connection - makes connection active in current SQL Editor window
-Add to preferred connections - adds registered server to SSMSBoost preferred connections list
-New GridScripter functionality:
-right clicking grid results allows to select range for data scripting:
-selected data in current grid
-all data from current grid
-data from all returned grids
-added possibility to specify output file name using flexible templates
-added data-type specific formatting
-new setting "Save Granularity", allowing to specify when to begin scripting into new file. Choose between
-Row (generates one output file per row)
-Block (Selection or Grid)
-Entire (all output is scripted into one file)
-Post-process scripted values usage in SQL/HTML or XML documents,encoding special symbols
-IMPORTANT: GridScripter templates were updated to re-use the full power of new functionality. If you
upgrade from v2.5 and already have Scripting Templates which you did not modify, we advise you to
DELETE all of them, using Settings dialogue. After restart of SSMS environment SSMSBoost will fill
Scripting Templates collection with default templates.
IMPROVEMENTS:
-Increased interval for community edition updates to 120 days. (Presious value was 45)
-Improved connection coloring logic (Status bar coloring logic), concerning Registered Servers support.
Status bar color for current connection of SQL Editor window will be determined in following sequence:
-Match current database with databases from preferred connections
-Match current database with databases from registered servers
-Match current server with servers from preferred connections
-Match current server with servers from registered servers
-Default status bar color from SSMS Settings
-Added "Set as active connection" and "Add to preferred connection" on SERVER nodes in Object Explorer.
Commands were previously availanle on database nodes only.
-Added possibility to copy/paste single config entries via Clipboard as XML. This feature is enabled for
Scripting templates, Grid Visualisers and Connections. It allows you to copy configuration entries outside
the SSMSBoost, process them in any text editor and paste them back. Purpose: we will add a special
"Scripting templates" thread in user forum, so users can exchange useful scripting templates with each other.
-Preferred connections can be sorted now in settings dialogue
-New option "General Settings"->"Focus Object Explorer After locate" controls whether to move focus to Object
Explorer or leave it in SQL Editor
-Added General->"Show local databases in quick connections switch drop-down" Setting. You can decide if you
want SSMSBoost quick connection switch drop-down to show only preferred connections or also local
databases from current server (these databases are available in native SSMS connection switch drop-down)
-General->"Expand Object after locate" option defines whether to expand object's node after it was located
in Object Explorer tree
-Updated Tao Klerks SqlFormatter.exe to v1.4.1 (Used for formatting feature)
FIXES:
-Locate/Script object command did not work on Synonyms, if they were prefixed with schema name
-Fixed some minor bugs reported by users