0
Hi.
First thing as you mentioned of Pdf uploading then don't directly store the pdf in db and as you mentioned for 200 number of clients and if each one upload then the size of db increase for which it will effect on the performance. So for that upload the pdf in a folder and save the path of the image in db. Shared db is also called as Multitenant and where there is a master db and all subsequent db connected to master. As many number of clients increase you can create that many number of db and for which there is no link up from one db to another. Even if once i worked on one project related to mulitenant application and one thing make sure that all client database have same structure.
thanks.
0 While I may not be quite qualified to answer your questions, here are my thoughts.
The database which you call "shared" is called "multi-tenant" database. To use it effectively, I am sure there is already an Id implemented in tables which identify Client.
You will need to develop an application, which will upon request, prepare a script which will extract all of that client's data + master data, which should be able create a separate db.
If a client is asking for a separate db from the beginning then you should have a copy of a model db which has all of the master data. You will use this copy as a starting point for a client. Important point: Even if clients are in separate db, give them unique numbers. So that you can bring independent client into the shared environment.
You definitely will not take back-up manually of 200 dbs, there will be scheduled task which will run in the night.
I don't think downtime is anything to with number of dbs. Your typical downtime would be for patching servers and Windows Update, etc.