Pros/Cons of using multiple databases vs using a single database
30
votes
8
answers
85792
views
I was working on a new project which has the requirement to use 7 databases, arguing that performance, stability, optimization are more easily implemented.
While I don't agree, I'm having trouble collecting good arguments to use a single database (splitting the tables into logical domains).
One argument I have so far is data integrity (I can't use foreign keys between databases).
What are good pros/cons for using a single or multiple databases?
**[summary so far]**
Arguments against multiple databases:
- Losing data integrity (can't use foreign keys over databases)
- Losing restore integrity
- Gaining complexity (db users/roles)
- Small odds server/database will go down
Solutions:
- Use schemas to separate domains.
- POC: Use dummy data to prove the point in 7/1 db's execution plans
Asked by rdkleine
(421 rep)
Jul 12, 2011, 09:08 AM
Last activity: Jul 5, 2025, 05:39 PM
Last activity: Jul 5, 2025, 05:39 PM