I got a note from Jakub Dvorak via LinkedIn inviting me to try SQLTreeO. I checked out the site, liked what I read, navigated to the download, and installed it. I think it’s pretty cool. Here’s how I used it:
Create a New Folder in SSMS
To create a folder, right-click the desired parent folder and click New Folder:
When the new folder appears, you can rename it by simply typing a new name. Here, I typed “MyNewFolder” as the new folder name:
To move objects into the new folder, I right-clicked the Stored Procedures folder and click Manage Folders… This brought up the Manage Folders window:
I multi-selected some stored procedures to move into MyNewFolder, then dragged and dropped them onto MyNewFolder. To view the contents of MyNewFolder, I clicked it in the treeview on the left:
After closing the Manage Folders window, Object Explorer now lists the stored procedures I moved inside the MyNewFolder virtual folder created by the SQLTreeO add-in:
I like the idea behind SQLTreeO a lot. It will help keep my database development more organized when building projects in SSMS for current versions of SQL Server.