One of the apps that I am researching as a possible project, will be a database application that allows clients to access the data on a hosted platform. We will initially be using a C# Desktop front-end, but I could really do with some additional advice as to the back-end. We will be seeking professional guidance on this - but I would really like a little heads-up first.
The type of application means that each client could have multiple, individual databases of between 1k and 10k records (average), which although are initially based on a standard template are slightly altered for each project (there could be in excess of 100 projects (although not all will be used at the same time)). Also, there could be up to 50 users (working on the various projects). In addition to this, the aim will be to get multiple clients....who may need the same type of setup.
So my question is - would you initially have one instance of a server such as Microsoft SQL / PostgreSQL (other suggestions greatly appreciated) for all of the clients, or would you need to set-up a separate instance/server for each one?
As mentioned, we will be seeking help on this - I'd just also like some EE help first.