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...
精彩评论