CODEWITHSUNDEEP
sql-server-2008ssms
Rodney Clark
Rodney Clark

Reputation: 253

How to group databases in folders in SQL Server Management Studio?

My question comes from the frustration that I have every time I launch SSMS. We have few hundred of different databases in one server instance, from different projects and customers, and having them in one long flat tree view just does not feel very ergonomic to me.

Is there any smart way to keep them more organized? I thought, that for example being able to group them in custom folders would be a nice solutions, but AFAIK SSMS does not support it.

Being able to group stored procedures in a similar way would be a nice added value, but I'd be more than happy with being able to group databases only.

Upvotes: 25

Views: 14197

Answers (2)

Defria Manda
Defria Manda

Reputation: 86

In case someone comes here through a google search. In SSMS Press ctrl + alt + G to open the Registered Server pane. There you can add a folder and add connection strings as New Server Registration...

SSMS Registered Servers

Upvotes: 1

Sebastian Zaklada
Sebastian Zaklada

Reputation: 2376

I have good news for all of you. There is an SSMS add-in for this. It allows to organize into custom folders all databases, stored procedures and other database objects as well. Just as if this was a native SQL Server Management Studio functionality.

The tool name is SQL Handy Groupie and can be found at www.skilledsoftware.com. Have fun.

Upvotes: 5

Related Questions