Post reply

Database per client vs consolidated database

  • April 28, 2006 at 4:26 pm

    #93968

    The company I work for services a number of large corporate clients - we currently maintain each client's data in a separate SQL server database.  There are a number of benefits to this configuration but the origanization would like to evaluate the concept of merging all clients back to one consolidated database.  As part of the review, mgmt would like to see case studies involving in-depth evals other compaines have done to compare the separate vs consolidated architecture.

     

    Is anyone aware of any good case studies on the subject?

     

    Thanks,

    Harley

  • May 1, 2006 at 8:00 am

    This was removed by the editor as SPAM

  • May 1, 2006 at 9:44 am

    #635148

    Don't know of any case studies, but it becomes much harder to scale out, be fault tolerant for some clients, etc. if they are combined. Definitely lowers admin if you work on one db v 100.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply