How to group databases (in folders?) in SSMS

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

How to group databases (in folders?) in SSMS

Author

Topic

rodney.clark
Starting Member

2 Posts

Posted - 2010-12-04 : 19:01:26

Hi,

My question comes from the frustration that I have every time I launch SSMS. Having a 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.

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2010-12-05 : 02:30:19

SSMS doesn't provide that functionality. You should consider splitting your databases into multiple instances. A few hundred databases on one single instance is not a good practice. We set a maximum of 100. The more databases you have, the longer generic maintenance routines will run and you could run out of hours in a day.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

sebekz
Starting Member

5 Posts

Posted - 2010-12-06 : 03:14:27

Try this SSMS Add In - [url]www.skilledsoftware.com[/url]

rodney.clark
Starting Member

2 Posts

Posted - 2010-12-06 : 18:58:23

Thanks. I have been given similar advice on another forum, and this one is exactly what I needed.

Lumbago
Norsk Yak Master

3271 Posts

Posted - 2010-12-07 : 04:24:45

Wow! I wish I knew about this in my previous job...not so much for grouping databases but for grouping objects inside databases. The system I worked on had over 1000 tables and quite a few stored procedures as well...would have been nice to be able to group them. I even asked about it in a forum thread a while back

-> http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=94016

- Lumbago

My blog (yes, I have a blog now! just not that much content yet)
-> www.thefirstsql.com

jdvorak
Starting Member

1 Post

Posted - 2011-06-15 : 02:39:20

Hi,

I've just finished beta of free SSMS Add-In which enables you to do what is described in this thread (grouping databases and other SQL objects in folders within SSMS). Check it here http://www.sqltreeo.com

Jakub

------------------------------------------------------------------------------
http://www.sqltreeo.com - Free SMSS Productivity Add-In

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources