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?

The forums are in read-only mode. In case that you want to directly contact the Progress Sitefinity team use the support center. In our Google Plus group you can find more than one thousand Sitefinity developers discussing different topics. For the Stack Overflow threads don’t forget to use the “Sitefinity” tag.
3 posts, 0 answered
  1. Kai
    Kai avatar
    0 posts
    22 Apr 2014
    02 Feb 2017
    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
    01 Jul 2014
    02 Feb 2017 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
    18 Jul 2004
    02 Feb 2017 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




    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