Introduction:
We want to develop a C# ASP.Net web application which will use SQL Server database. Now clients will license in our application and then use it. This application also supports PDF uploading option.
Objective:
There might be a stage where user may want us to separate his data and deploy that at his own server OR from beginning he don’t desire to have shared database and wants to have a separate database for him at our server.
If we design a single database for all users then in future how will we separate a specific client’s data? And if we create separate databases dynamically for each user then let’s say if 200 number of clients desire to have independent databases at our server then in the end our server will end up having 200 Independent and 1 Shared database.
If that would be the situation then how will we backup all databases? Moreover I think our server downtime may increase too.
Please help & suggest me in deciding and designing the most appropriate, effective and accurate solution.
Please Note:
We are using Microsoft Azure services at the moment.