Guide to SQLTreeo Addin

29 Sep 2019 0 minutes to read Contributors

ORGANIZE YOUR WORK

Create structure in your environment with dynamic folders.

Dynamic folders allow you to work more efficient in a team.

It will truly improve the way of working, you'll enjoy it

Teams work together on the same dynamic folders.

No changes are made to your user databases.

Dynamic folders

PROJECT TEAMWORK

Folder information is visible to everyone using SQLTreeo SSMS ADDIN.

Ideal for any project team structure. Categorize per project, customer, team, ...

Communication is being improved when your work is structured.

Project teamwork

OPTIMIZE YOUR MAINTENANCE TASKS

Maintenance jobs, Reporting jobs, user jobs.

By default All jobs are shown in one large list

you have to visually go through the list to "find" the job you need to work on

Separate maintenance tasks from user tasks from etl tasks and cleanup

You will never have any problems to find the right job.

custom-folders custom-folders

COMPARE OBJECTS

Compare your work with another environment/database.

A single click and you have a detailed comparization

Compare ANY object: Server, Database, Table, Procedure, View, Job, ...

Compare objects

GENERATE SCRIPTS

Get any object scripted by one mouse click. No more struggle finding the right efficient tool to script your Databases. SSMS ADDIN is able to script nearly any database object or folder.

Generate scripts

HOW BIG IS YOUR DATABASE

Immediately see the size of your Database. Detailed information on data and log size, used data and more.

taking away the extra step of querying this information.

Database properties

HOW MANY ROWS IN YOUR TABLE?

Immediately see the size of your table. Detailed information on number of rows, used data and more.

taking away the extra step of querying this information.

Table properties

EASILY EXPORT DATA

Extracting data is always a daunting task

Export the columns / rows that you want with a simple dialog

The output is a SQL Script that you can execute on any other database.

export table data

Guide to SQLTreeo Addin

29 Sep 2019 0 minutes to read Contributors

SQL Server Management Studio

  • Installed on the computer before the installation of SQLTreeo SSMS AddIn.
  • SQLTreeo will be installed in all locally installed SSMS versions.
  • SSMS 2005, SSMS2008, SSMS2008R2, SSMS2012, SSMS2016, SSMS2017, SSMS2018, SSMS2019 and up.

Windows

  • Minimum .Net version: .Net 4.0.
  • Minimum Windows version: Windows XP with additionally installed .Net 4.0.
  • Minimum Windows version with pre-installed .Net 4.0: Windows 8 / Latest Windows Server (all editions).
  • HDD footprint is about 4MB.

References

Guide to SQLTreeo Addin

29 Sep 2019 0 minutes to read Contributors

Features

The SQLTreeo Addin has the following features and functions available:

  • Create static folder
  • Create dynamic folder
  • Compare objects
  • Quick filter
  • Object information
  • Collapse all
  • Script CREATE/INSERT TO
  • Manage folders

Features per version

SQLTreeo Static Folders

  • Available from SSMS version 2005 and up.

SQLTreeo Dynamic Folders

  • Available from SSMS version 2016 and up.

SQLTreeo Compare

  • Available from SSMS version 2016 and up.
  • Requires license for Compare.

If SQL Server Management Studio is installed after SQLTreeo, then reinstall SQLTreeo SSMS Addin

SQL Server version/

Function

2008 2008R2 2012 2014 2016 2017 2018 2019
Static folder x x x x x x x x
Dynamic folder         x x x x
Compare         x x x x
Quick filter         x x x x
Object information x x x x x x x x
Collapse/script/manage x x x x x x x x

 

Guide to SQLTreeo Addin

29 Sep 2019 0 minutes to read Contributors

SQL Server Management Studio – Object tree

Depending on the SSMS version some features are not available, for more information first refer to Features

to see which features are available for your version.

 

Listed below are the objects in which the SQLTreeo features are available:

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

 

 

Guide to SQLTreeo Addin

29 Sep 2019 0 minutes to read Contributors

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 like the default SSMS filter function but then in a more convenient place.

By entering a value in the “click here to filter” folder it will immediately start to filter any targets that fulfill the value condition, allowing for fast searching.

The quick filter function is per Object in the SSMS explorer, it is not possible for example entering a value in "Tables"  object to find targets in "Views".

The filter does not change the order of existing objects but simply presents them below the folder.

The Quick Filter function is available in several tree objects as shown in Object explorer

Guide to SQLTreeo Addin

29 Sep 2019 0 minutes to read Contributors

Static folders

Static folders are folders that can be customized by the user and hold database objects of the placeholder.

Static folders cannot be created inside System databases.

By right-clicking on an object tree component a context menu will be opened with an option to create a “New Folder..”

this will create a new folder. The folder can be in any language.

The folder can be filled by dragging the database objects into the folder(note that only objects retained in the expanded menu can be placed in the folder, e.g. a folder created in tables menu cannot contain stored procedures or views).

Another option is to right-click the folder and select “Manage folder” to open the folder interface in which you can quickly select multiple tables to be placed in the folder at once.

Once objects are placed in the folder it can be expanded to show the content inside.

In case the folder is created and no objects are placed inside the folder it will disappear upon a refresh of the sub-menu or higher.

Created folders are registered inside the database in which it is created the information is visible in the extended properties of the database when database storage is selected.

Guide to SQLTreeo Addin

29 Sep 2019 0 minutes to read Contributors

Dynamic Folders

Dynamic folders can be given certain criteria to group all objects that meet the value condition.

By right-clicking and selecting “Create dynamic folder” a menu will open where you can name the folder and insert the condition value, upon creating it will automatically group all objects that meet the condition.

Dynamic folders cannot be created in the system databases

Selecting the properties of the folder opens the interface in which you can adjust the value condition and folder name.

Guide to SQLTreeo Addin

29 Sep 2019 0 minutes to read Contributors

Compare

The SQLTreeo Add-in comes with an additional module that allows users to compare objects of the same server or different server with each other.

It is possible to add multiple targets allowing for easy and quick comparison in for example an DTAP environment.

The compare module is a seperate feature of the SQLTreeo Add-in and is only included during trial period or when purchased seperately.

 

The link below is a tutorial on how to configure/work the compare function.

SSMS ADDIN Compare Module – How it Works 

 

 

 

 

Guide to SQLTreeo Addin

29 Sep 2019 0 minutes to read Contributors

Plugin Load Troubleshooting

Troubleshooting using Windows Assembly Load logging tool, Fuslogvw.exe

  1. A temp folder needs to be created on a local PC, where logging output will be written, i.e. c:\temp\fuslog.

  2. Find the 'FUSLOGVW.exe' tool. It might be installed already on the system. A typical location, depending on .Net SDK version, would be C:\Program Files (x86)\Microsoft SDKs\Windows\v10.0A\bin\NETFX 4.7.2 Tools.
    If the tool is not installed, it can be downloaded from the Jira.

  3. Run the FUSLOGVW.exe as Admin. Click the Settings button. In the opened Log Settings window, select 'Log all binds to the disk'. Tick 'Enable custom log path' checkbox, and enter the path from step (1), i.e. c:\temp\fuslog, to the 'Custom log path' field.

  4. Click OK.
    NOTE: this utility must NOT be left unattended. The logging SHOULD be stopped after the testing is done. to avoid a significant overload of the system.

  5. Run SSMS and replicate the plugin issue that is being troubleshooted.

  6. Collect the log files from the folder that location was entered on step (3). Please zip all the content of that folder. It will contain multiple folders and files.

  7. CRITICAL!!! Switch to the utility. Click the Settings button. In the opened window tick 'Log Disabled' radiobutton in the Settings group. Click OK. Close the Fuslogvw utility.

SQLTreeo Addin Logging

  1. Run SSMS and replicate the plugin issue that is being troubleshooted.

  2. Collect the log files from the following folder:
    %appdata%..\local\SQLTreeo\SQLTreeo\logs

Running SSMS With Logging Enabled

  1. A temp folder needs to be created on a local PC, where logging output will be written, i.e. c:\temp\ssms_log.

  2. Please find SQL Server Management Studio in Windows Start menu, either using Windows Start menu 'Type here to search' prompt, or using Start menu programs list.

  3. Right click on the SSMS run menu item, select 'Open File Location'.

  4. In the opened window that contains shortcuts, select (click) the one that starts SSMS. Press Ctrl+C and Ctrl+V. Rename the shortcut using key F2 to something like 'SSMS 2017 with log'. Save.

  5. Right click the new shortcut, select Properties.

  6. At the end of the 'Target' field, add the following:
    -log "c:\temp\ssms_log\log.xml"

Click OK.

  1. Run SSMS using the new shortcut and replicate the plugin issue that is being troubleshooted.

  2. Collect the log files from c:\temp\ssms_log folder, and upload to SQLTreeo Plugin Support for further investigation.
    The log files will be named 'log.xml', 'log1.xml', ....
    Please also provide the ActivityLog.xsl that is going to be in the same folder.

SSMS *config Controlled Logging

  1. Please find SQL Server Management Studio in Windows Start menu, either using Windows Start menu 'Type here to search' prompt, or using Start menu programs list.

  2. Right click on the SSMS run menu item, select 'Open File Location'.

  3. In the opened window that contains shortcuts, right click the SQL Server Management Studio item, right click, choose Properties and then Open File Location button.

  4. Find a file named Ssms.exe.config. Make sure it contains the following:

  1. Run SSMS and replicate the plugin issue that is being troubleshooted.

  2. Collect the log files from %TEMP%\SSMS folder, and upload to SQLTreeo Plugin Support for further investigation.

In this article