More in this section

Forums / Developing with Sitefinity / Separation between content and structure...

Separation between content and structure...

2 posts, 0 answered
  1. Chris
    Chris avatar
    10 posts
    Registered:
    30 Apr 2008
    12 Dec 2008
    Link to this post
    Is there a way to have a separate database for the content from the site pages?

    We tend to only allow clients to edit content and not add new pages to a site. In this context as we go live with a site we will often start work on pages and functionality, which we'd need to develop on a different server to the live server. I'm not sure of the best way of releasing this new work without duplicating effort...
  2. Vlad
    Vlad avatar
    498 posts
    Registered:
    19 Jun 2017
    16 Dec 2008
    Link to this post
    Hi Chris,

    If your mean to store the data related to the CMS pages in a different database, yes it is possible. You just need to configure this in the web.config. You should change the connection for the cms provider:

      <connectionStrings> 
        <add name="SitefinityPages" connectionString="data source=..." 
          providerName="System.Data.SqlClient" /> 
        ... 
      </connectionStrings> 
      ... 
      <telerik> 
        <dataAccess defaultConnection="DefaultConnection"
          <connections> 
            <add name="PagesConnection" driver="Nolics.ORMapper.DataProviders.SqlServer2005Provider" 
              connectionStringName="SitefinityPages" /> 
            ... 
          </connections> 
        </dataAccess> 
        <cms defaultProvider="Sitefinity" pageExtension=".aspx" disabled="false" 
          pageEditorUIMode="Overlay"
          <providers> 
            <clear /> 
            <add connectionStringName="PagesConnection"  
              applicationName="/" 
              name="Sitefinity" type="Telerik.Cms.Data.DefaultProvider, Telerik.Cms.Data" /> 
          </providers> 
        </cms> 
        ... 
      </telerik> 
     

    However, the better approach for the described scenario is to use page permissions. You should set the appropriate permissions for the content editor, denying him access to the Site Map root.

    Hope this is helpful. Please let us know if you need any further assistance.

    Kind regards,
    Vlad
    the Telerik team

    Check out Telerik Trainer, the state of the art learning tool for Telerik products.
2 posts, 0 answered