Re: FN-FORUM: dB growth

date posted 21st September 2006 19:47

Dave Boulden wrote:

> Let's say you go down the 1 db per customer route and you do well and have
> 50 customers (hence 50 databases). You come up with a new feature you want
> to give to each customer and it involves new code, a new table or two and
> some new columns in existing tables and a bit of manipulation of
> pre-existing data... You now have to make that change 50 times. There will
> also be a performance overhead for running multiple databases rather than
> one database for all.

Doesn't everyone have database migration scripts for this sort of stuff?
How else do you test on a separate server and know that it'll work on
the live one(s)?



Regards,

Rob...