I was working on a new project which has the requirement to use 7 databases. Arguing, arguing that performance, stability, optimization is easierare more easily implemented.
While I don't agree, I'm having trouble collecting good arguments to use a single database. (While the 7 databases splitssplitting the tables ininto 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 itegrityintegrity (can't use foreign keykeys over databases)
Losing restore integrity.
Gaining complexity (db userusers/roles)
Small odds server/database will go down.
Solutions:
Use schemas to seperateseparate domains.
POC: Use dummy data to proofprove the point in 7/1 db's execution plans