I wanted to Run my Application on cloud.Application will be for multiple clients . I wanted to know. which db architecture should i follow to handle multiple client and their data. I have browsed some sites. here i found there multiple way to handle this situation . we can use multi tenant DB architecture for the same.
- Catalog based multi tenant db architecture
- schema based multi tenant db architecture
- Table based multi tenant db architecture
so for cloud application which db architecture is preferable. ??
i am using SQL server 2012.
There will be huge data for each client.