More in this section

Forums / General Discussions / Multiple Projects but just one DB in Sitefinity 8.2?

Multiple Projects but just one DB in Sitefinity 8.2?

3 posts, 0 answered
  1. Kai
    Kai avatar
    0 posts
    Registered:
    22 Apr 2014
    02 Feb
    Link to this post

    Hey guys,

     

    as we have one database server for multiple applications, our Database tech staff was quite surprised by getting the Sitefinity project from us. They were surprised because each Sitefinity project does create it's very own database, resulting in 10 databases in our instance.

     

    I read it was possible to store all projects in just one database, which our tech team is more comfortable with. But this was a SF version from years ago. We currently use 8.2 and I'd like to ask if such a "consolidation" of databases would be possible?

  2. Victor Leontyev
    Victor Leontyev avatar
    65 posts
    Registered:
    01 Jul 2014
    02 Feb in reply to Kai
    Link to this post
    Hi Kai, you can use Miltisite module. It will allows you to have one Backend for different project (websites) and one DB
  3. Darrin Robertson
    Darrin Robertson avatar
    105 posts
    Registered:
    18 Jul 2004
    02 Feb in reply to Victor Leontyev
    Link to this post
    If you don't have\can not get the multisite option (which I recommend you do if you have 10 sites)

    You can actually have all the sites use one database by creating different user accounts and not associating them with the same schema (ie not dbo)

    What happens is that each user account ends up creating all the tables for Sitefinity prefixed with the user as the schema

    [UserA]sf_users

    [UserB]sf_users

    etc

    Down side is that you will have 10x the number of tables.

    I have never actually tried it. I usually end up fixing it when people have run into the issue. I haven't actually tried\implemented it but I think I will give it a go when I have some time. It will be interesting to see the result.

3 posts, 0 answered