SQLTeam.com | Weblogs | Forums

Saas Multi Tenant Setup

Hi all,

Our company has about 700 clients. We currently put most of those 700 clients into one shared database. We have started to adopt a strategy of having more databases for performance reasons but it is impacting our build and deployment capabilities. How do other people architect their solution with this setup. Assuming others adopt a multiple database setup (perhaps even one database per client), how do you manage DB changes, indexes, deployments, etc.