开发者

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

开发者 https://www.devze.com 2023-01-28 17:49 出处:网络
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

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

精彩评论

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