SQL Treeo is free add-in to SQL Server Management Studio (SSMS) which enables user to create own folder structures within standard SQL Server nodes. With SQL Treeo you can logically separate your databases, stored procedures, tables, views and user-defined functions directly in standard Object Explorer within SSMS. And finally stop dealing with hundreds of objects contained in one folder within SSMS.
Reason why SQL Treeo appears is that I was frustrated with continuous browsing for SQL objects in standard e.g. “Programmability/Stored procedures” node. Almost every database project provides “some” logical structure (based e.g. on modules, parts…) which should be ideally reflected in naming convention and security schemas. But naming convention and schemas provide only limited possibilities how to achieve that goal and in short while you suddenly have maintainability issue again. It is really helpful if you group your logically related SQL objects into groups/folders and dramatically improve your orientation in SSMS then.
I decided to provide SQL Treeo for free.
I hope that this add-in will help others as it helped me.
Jakub Dvorak
Tags: SQL Server, SSMS
Looks great, however what are the drawback of this addin?
Does it modify the server in any way?
Does it move the sprocs from their original location?
Are the folders logical only from SSMS perspective?
What about other users not having this addin installed? Will they see the folders?
Where is stored the “layout” of the folders and the sprocs ?
Hi Stecy,
here are answers for you:
Does it modify the server in any way? – yes, it writes meta data of folder’s structures to extended properties of particular objects. Extended properties are scripted with objects thus folder assignment is stored invisibly with objects. This is same way as e.g. column description are stored within your database.
Does it move the sprocs from their original location? – No
Are the folders logical only from SSMS perspective? – Not sure If understood well but, since folder assignment is stored in db, logical structure is shared for anybody who has installed this add-in.
What about other users not having this addin installed? Will they see the folders? – See previous answer
Where is stored the “layout” of the folders and the sprocs ? – See very first answers.
Hope it helps for clarification.
Jakub
Thank you for answering.
It clarifies a lot.
[...] thing is that I will finally finish my SSMS add-in I promised. If you are not aware about it, read here why I am developing [...]
This tool looks great but I was really hoping it would work for Solution Explorer SSMS projects. Any thought on this or how hard it would be? There is no way to add folders to an SSMS project or move items around.
Sorry, that’s something completely different. I guess I saw some solution how to use folders in SSMS projects but can’t remember where. It had something to do with editing XML of the SSMS project.