SQLTreeo Add-In plugin for SQL Server Management Studio Version Applies to SQLTreeo Add-In version 0.8.7 or higher. Purpose Informational guide on how to use the SQLTreeo Add-In. Functionalities SQLTreeo Add-in allows users to create customized folders in the object tree of SQL Server Management Studio (SSMS). The Add-in has multiple functionalities as listed below: Create static folder Create dynamic folder Compare objects Quick filter Object information Collapse all Script CREATE/INSERT TO Manage folders Licenses SQLTreeo Add-in comes in the following license forms and extensions: SQLTreeo month license SQLTreeo year license SQLTreeo lifetime license SQLTreeo Compare module (seperate from above license forms) During the trial period the compare module is enabled. Compatibility SQL Server version/ Function 2008 2008R2 2012 2014 2016 2017 2018 Static folder x x x x x x x Dynamic folder x x x Compare x x x Quick filter x x x Object information x x x x x x x Collapse/script/manage x x x x x x x SQL Server Management Studio – Object tree SQLTreeo add-in is build in the various objects in which users can create customized tables/view object information/compare information. Listed below the Objects in which the different functionalities and features of the Add-in are applicable: Object/Function Static folder Dynamic folder Compare Quick filter Databases x x x X Tables x x x X Views x x x X Stored procedures x x x x Table-valued Functions x x x x Scalar-valued Functions x x x X Agent jobs x x x X The availability of above features depend on the SQL Server version used. Older versions of SQL Server do not support all features such as SQL Server Agent jobs/Dynamic folders. Quick filter The Quick Filter is a function that filters database objects such as tables based on the input value. The Quick filter is much alike the standard SSMS filter function.
The post SQLTreeo SSMS Add-In guide appeared first on SQLTreeo.
