Re: Database Hosting

paul c wrote:

> 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. ...
>
> All tables? Why would a single client's view need to include his client identifier?

It doesn't. That's the whole problem. I don't believe that the method that has been proposed is the correct one.

--