Re: Database Hosting

From: Bob Badour <bbadour_at_pei.sympatico.ca>
Date: Mon, 20 Nov 2006 20:50:33 GMT
Message-ID: <tyo8h.22676$cz.345986@ursa-nb00s0.nbnet.nb.ca>

Murdoc wrote:

> Hi all,
>
> Our company is about to embark on rewriting our entire application to be truly
> client/server based, and bring the UI up to .NET. One of the additional services that
> our CEO wants to provide is the hosting of the software ourselves (to save our smaller
> clients the licensing costs of the database server software, etc).
>
> However, the proposed solution to this is to simply have a single database with every
> client's data in it, and add a 'client-code'/'client-id' field to EVERY single table in
> the database.
>
> Now, to me this seems to be a seriously flawed method of doing it, when a much simpler
> option (one database per client) is available.
>
> What are your thoughts, and how do other companies provide a similar service?

Does your company ever plan to do any cross-company analyses of the data? Received on Mon Nov 20 2006 - 14:50:33 CST