troubleshooting Question

need opinion/ideia.. multiple databases good or bad ideia?

Avatar of Edgard Yamashita
Edgard YamashitaFlag for Brazil asked on
DatabasesMicrosoft SQL ServerMicrosoft SQL Server 2005
1 Comment1 Solution346 ViewsLast Modified:
today i have the human resources database with tables like the employees.. emp address/fones/documents/ and everything related to the employees of the company.. and at the main system we use the employees info from this database to create a login system, where can tell what employee has access to what..

so then came the pcs inventory system where we store all pcs from the company.. then came several others small system such as this one.. and all related tables went to the human resources db..  (since we store info like last employee that modified this/that and stuff like a small ticket system that uses the employee id)

now there is now a kind of big system that will be related to the employees id and such again.. but is it better to make another database for it and then when we need to get the like who did what in this new db will need a join between databases to get it i dont know how good or bad that is..

should we let all system stay at the human resource db or split them all into their own db and make joins between databases to get the info from the employee ??

what i am afraid is that if i keep all system in one db.. it will get very big this db.. not sure if its a good thing..

ps. sorry for my bad english since it isnt my main language
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 1 Comment.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 1 Comment.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros