Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2010
    Posts
    39

    Unanswered: Code Table Database

    I am working on a large project that will be web based. We have a good database design but can potentially have 1000's of databases to support customers, yes we are looking into multi-tenant design, but until then I am wondering if we created a database that would support all our system type tables, like zip_code, etc. There are over 120 tables that could be migrated to the 'common' database.

    Would it be worth the time as I am thinking yes? Although there would need to be quite a bit of code to modify, connect 'common' database, etc the real benefits would be in the upgrades where would have one database to update with code tables?

    Just asking for opinions.

  2. #2
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    Definitely migrate the data. Maintaining and managing one is a thousand times better than maintaining and managing a thousand.

    As a kludge, create views in the tenant databases that reference the migrated tables that are now in the common database. These views should allow you code to be left unchanged for now. The kludge needs to be considered depricated and should eventually be removed, but now you can do that at your leisure instead of having to have it completed "right now" for this release.

    -PatP
    In theory, theory and practice are identical. In practice, theory and practice are unrelated.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •