开发者

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 on开发者_开发问答e 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.


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.


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...

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

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜