[eluser]skattabrain[/eluser]
[quote author="CI beyond" date="1204081809"]
I'm also considering stuffing all customers in one DB and separate them by introducing a companyID or something. That way i prevent a lot of annoyances when there are DB changes. The latter will take some extra time, but i'm sure it'll pay off in the future.
[/quote]
This would be key as far as I'm concerned. It's not like your writing an application that people install and manage themselves, thus making updating their responsibility.
I couldn't imagine you being 6 months into this, decide you need a DB schema tweak and then have to make that change on 100 databases ... talk about setting yourself up for failure! You'd be hating it and coming up with reasons not to evolve your program.
