Blog Post

SQL Treeo – Create custom folders in SSMS

,

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

 

Rate

You rated this post out of 5. Change rating

Share

Share

Rate

You rated this post out of 5. Change rating