Building a multi-tenancy application

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Hi,

Can anyone point me to a article of product about using an application hosted on a webserver for multiple customers? So everything is the same except for the connection string each customer runs with, which gets loaded upon logon.

My situation is a following:
- 1 set of code which can interact with the database
- 1 SQL Server instance with multiple Databases (1 per customer)
- 1 File Storage Folder with a folder in which a structue for each client resides

Is this a keepable structure in performance? Are there better "best practices"?

Any comments will be appericiated!

Greets,
Gab
.

Relevant Pages

  • RE: Multiple Selections Using Dynamic Lists
    ... I have a bid list that has multiple customers quoting each bid. ... to be able to select the customer from a drop down, ... I need to be able to select multiple customers and contacts per instance. ... Steel and B1 reads Jeff Ransom? ...
    (microsoft.public.excel.misc)
  • Re: Multi-User Access design
    ... Conncurrent access - I think I can handle this simply my keeping a table ... So when one user opens a customer for editing I create ... Managing accessing multiple customers seems to be my main concern. ...
    (borland.public.delphi.database.ado)
  • Re: Create a query for specified text in a field
    ... This is a tough problem to solve for more than one customer at a time due to the combination of multiple customers in one field. ... IF you need to do this for multiple customers at once and cannot change the structure of your source table, your best solution would be to create a table of the unique customer values and use that in a non-equi join. ... In this query, i have include a input dialog for the user to enter the customer name. ...
    (microsoft.public.access.queries)
  • Re: How do I remove the individual subtotal lines from a pivot table..
    ... If you double click on that Customer header, you'll see options for subtotals ... > I made a pivot table to subtotal sales to multiple customers for multiple ...
    (microsoft.public.excel.misc)