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.
| Author |
Topic |
|
Lamune
Starting Member
3 Posts |
 Posted - 2008-01-21 : 12:40:22
|
I'm very new to SQL, so you'll have to excuse the nubishness of this question. I've got my trusty O'Reilly book here!  We're using Microsoft SQL Server 2005 on our web server. I'm currently working on a project to get a few MS Access Databases available on the web page. The web part is actually working fine, with the DBs exported into SQL for performance reasons. (From what I've read pulling data from the .mdb file could cause me problems in the future, so I'm tossing it all onto the SQL server from the start.)Before I get into the project full-tilt, though, I'm curious about how best to organize all the data?  I'm using the Upsizing Wizard in Access for the conversions, and every new DB gets added under Databases. If this gets approved I may be looking at well over a hundred DBs which will eventually be converted and made web accessible. I can keep everything neat and tidy on the web server by just tossing things in a few directories, but the menu on the SQL Server Management Studio is going to become a mess really quickly if I let it just keep adding to +Databases. Is there a way to sort everything into a series of folder/groups, like how System Databases has it? Thanks in advance,-Lamune |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-01-21 : 14:50:21
|
| No you can't, at least in sql2k5. |
 |
|
|
CShaw
Yak Posting Veteran
65 Posts |
Posted - 2008-01-22 : 01:33:29
|
| From the view that you are looking at your going to have a lot of databases to go through when you get done. Once thing you may want to consider is once the new database is created is to import it into one database with a different Scheme. This way you can keep objects in the logical order or grouping internal to one database.I hope this helps a little.Chris Shawwww.SQLonCall.com |
|
|
|
|
|
|
Best way to organize multiple databases?