+1-888-365-2779
Try Now
More in this section

Forums / Deployment / Exclude blogs from deployment

Exclude blogs from deployment

5 posts, 0 answered
  1. Matthew Snyder
    Matthew Snyder avatar
    15 posts
    Registered:
    21 Sep 2009
    01 Apr 2010
    Link to this post
    We have a development and production environment and we perform regular deployments by using third party software to transfer the Sitefinity database tables from our dev to prod database. We normally have our employees perform updates on dev first, and then deploy to prod at a later date, however, for blog posts, we will be having our employees posting directly on our prod environment. Can you please tell me which Sitefinity tables I should exclude from moving from dev to prod so that the blog posts in prod will not be overridden when we deploy? Thanks.
  2. Ivan Dimitrov
    Ivan Dimitrov avatar
    16072 posts
    Registered:
    25 Nov 2016
    01 Apr 2010
    Link to this post
    Hi Matthew Snyder,

    There are several tables that contain common data from all modules - News, Blogs, Generic_Content etc. You need to filter the data by provider name from these tables

    [sf_Blogs] - contains data for the IBlog objects
    [sf_CmsCategory] - contains data for the categories.
    [sf_CmsComment] - contains data for the comments.
    [sf_CmsContentBase] - contains data for the IContent item - blog post
    [sf_CmsContentVersion] - contains data for the Versioning of the item - History
    [sf_CmsTaggedContent] - contains data for the tagged items.
    [sf_CmsTextContent] - text data that is set in the RadEditor control of the views.

    I suggest that you should use database comparison and database replication tools.

    Sincerely yours,
    Ivan Dimitrov
    the Telerik team

    Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items.
  3. Matthew Snyder
    Matthew Snyder avatar
    15 posts
    Registered:
    21 Sep 2009
    19 Apr 2010
    Link to this post
    We are actually using a database comparison tool for our deployments. When we copy the data from development to production using the database comparison tool, we usually just select every table in our database prefixed with "sf_" and "telerik_" and have the comparison tool transfer all of the new content from development to production. Can you tell me how I can ensure that the blog posts in development would not be transferred to production?
  4. Ivan Dimitrov
    Ivan Dimitrov avatar
    16072 posts
    Registered:
    25 Nov 2016
    19 Apr 2010
    Link to this post
    Hello Matthew Snyder,

    All of the above mentioned tables have column called Application. You do not have to merge rows which has Application equal to "/Blogs"

    All the best,
    Ivan Dimitrov
    the Telerik team

    Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items.
  5. Matthew Snyder
    Matthew Snyder avatar
    15 posts
    Registered:
    21 Sep 2009
    19 Apr 2010
    Link to this post
    Thanks.
Register for webinar
5 posts, 0 answered