Databse architecture (single db vs client specific db) for Building Enterprise Web (RIA) application on cloud
The three main techniques that is usually applied to the database usage for this kind of a multi-tenant requirement is below. You have already specified some of them. Separate databases for each tenant: very high cost, easy to maintain/customize, easy to tune, easy to backup, easy to code to. Shared database but different schema: Low … Read more