2
Answers

Need urgent help in designing SQL database strategy

Photo of Emad khan

Emad khan

8y
278
1

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.

Answers (2)

0
Photo of Sam Hobbs
NA 28.7k 1.3m 14y
The term plugin means that the software issuing the message was not written by Microsoft so you need to refer to the documentation of the other software. The problem is not the result of the C# DLL not getting loaded. If you wrote both the C# program and the C++ program and you don't recognize the error message then it is a problem with non-Micorosoft software that you are using.