SSMS AddIn Version History

06 Jun 2022 784 views 0 minutes to read Contributors

Future versions

Static Folders are not supported anymore. Use Dynamic Folders instead.

In this release we have fixed the following errors:

  • On startup of SSMS, when your license is expired it is generating an error. 

Now a different error is shown:

  • When you try to create a new Dynamic Folder the following error is shown:

This only happens when your storage type is "User Database" and the database you want to create the dynamic folder in is a different database. That error is now fixed.

When you choose storage type "User Database" and the database to store the settings in, that is the only database where a new table SQLTreeoFolders will be created. 

  • SQLTreeo is now installed in C:\Program Files (x86)\SQLTreeo (without the space in "SQL Treeo")

In this release we have changed the following behaviour:

  • SQLTreeo SSMS AddIn is moving away from Static Folders.

A Static Folder is different from a Dynamic Folder in where SQLTreeo is saving it's folder information. Static Folder information is written into the extended properties of an object (Table, View, Procedure, Function, etc...). It does not change the functionality of an object, it just records additional information about an object. Additional information on Extended Properties can be found here: sp_addextendedproperty (Transact-SQL) - SQL Server | Microsoft Docs.

In order for SQLTreeo to construct the folder structure it needs to read from all the objects, the extended properties information. In case of many objects (Tables, Views, Procedures, Functions, etc...) it takes a long (too long) time to do this. Dynamic Folders are much more efficient and cover all the functionality of a Static Folder. 

In version Static Folders are still shown but you cannot create new Static Folders anymore. 

Instead a message is shown to create Dynamic Folders instead:

In new releases of SQLTreeo SSMS AddIn we will enable the option to disable Static Folders via the properties screen and set it as a default on new installations. Users then can have the benefit of the improved speed if they do not use Static Folders.

  • SQLTreeo download link is now a direct link of the SSMS AddIn setup instead of via the DBASuite.

Several performance optimizations

Report a Bug

In this article