This an extension for SQL Server Management Studio 18 and above. Version 17 and lower are only supported until version 1.0.4. It groups databases in the Object Explorer tree into folders.
Source code, documentation and issues can be found at https://github.com/micjahn/SSMS-Database-Folders
This work is based upon SSMS Schema Folders.
There are a few user options which change the style and behaviour of the databases folders.
Tools > Options > SQL Server Object Explorer > Database Folders
- Group databases in folders by name - Activates grouping of databases in folders by using that part of the database names before the first underscore
- Separate folders for readonly databases - Use a separate folder for readonly databases
- Custom folder configurations - set a list of configurations for custom folders
- Custom folder name - user defined name of the folder
- Add databases to folder by regular expressions - a list of regular expression to define which databases should be added to the folder
- Use other grouping mechanisms inside the custom folder - the main options are used to make sublevels of folders and build a structure
- Build folder name by regular expressions
- Enabled - enables or disables the extension. can also be toggled by a button in the toolbar
This extension moves nodes in the Object Explorer tree view. This could cause problems with other extensions that are not expecting it. At this point in time, I am not aware of any extensions where this is an issue. If you do have problems then let me know.
Please report any issues to https://github.com/micjahn/SSMS-Database-Folders/issues.
The last version of this extension which works with SSMS 17 and lower is version 1.0.4.
- added support for SSMS 21
- removed support for SSMS 17 and older
- added support for custom folders
- added support for SSMS 20
- added support for SSMS 19
- added button to the SSMS toolbar for temporary activation/deactivation of the addin
- added option for showing debug output
- added option for regulare expressions
- sort folders
- first release.