More in this section

Forums / Developing with Sitefinity / Merging Content Between Dev and Live Site

Merging Content Between Dev and Live Site

11 posts, 0 answered
  1. Armysniper
    Armysniper avatar
    126 posts
    Registered:
    03 Mar 2005
    20 Mar 2009
    Link to this post
    We are in the middle of having content providers moving content from our old site to our new Site Finity site. While that is happening I am creating controls and functionality for the new site. Some of my controls have their own documentation which I would like to have the content authors change as they need to (we all know developers are usually crappy writers). I want to do this in my developer machine by creating some generic content pieces locally in development and then displaying them via the API. Problem is, content is being authored on the main site. How can I merge my content that I am creating on the development site, with the content that is being created on the live site?
  2. Ivan Dimitrov
    Ivan Dimitrov avatar
    16072 posts
    Registered:
    12 Sep 2017
    24 Mar 2009
    Link to this post
    Hello Armysniper,

    The process of merging is really complex. There is no easy way that I could come up. Probably if you use database comparison and some merging database tool you could see the changes on the both bases.

    All the best,
    Ivan Dimitrov
    the Telerik team

    Check out Telerik Trainer , the state of the art learning tool for Telerik products.
  3. Randy
    Randy avatar
    19 posts
    Registered:
    13 Nov 2007
    24 Mar 2009
    Link to this post
    We use Redgate's DataCompare.  This tool is a must have for any developer who manages data driven applications.  You can create compares for dev to staging or staging to live or live back dev. Very simple to syncing wizard. 
    Like I said "A Must Have" .

    http://www.red-gate.com/
  4. Ivan Dimitrov
    Ivan Dimitrov avatar
    16072 posts
    Registered:
    12 Sep 2017
    25 Mar 2009
    Link to this post
    Hello Randy,

    Visual Studio also supports Data compare option( Data >> Data compare). I think that there is also option for synchronization as well.

    Kind regards,
    Ivan Dimitrov
    the Telerik team

    Check out Telerik Trainer , the state of the art learning tool for Telerik products.
  5. Armysniper
    Armysniper avatar
    126 posts
    Registered:
    03 Mar 2005
    25 Mar 2009
    Link to this post
    Ivan,  I believe that is only the case if you have the Database Edition of Visual Studio. I have heard of Red-Gate and will give them a shot. Need something that will help mitigate the differences.

    As an aside question. What is the need for the SiteFinity.mdf file in the App_Data folder of every project? Is it needed if I am connecting to an external SQL Server? Can't open it with SQL Server 2005.
  6. Nikolai
    Nikolai avatar
    216 posts
    Registered:
    01 Jun 2017
    26 Mar 2009
    Link to this post
    Hello Armysniper,

    The Sitefinity.mdf file in the App_Data folder is only used for SQL Express connection. If you are using SQL server you can delete it. Also *.mdf must be attached to SQL server, not opened, so I am not sure what exactly do you mean by "open". If you are not using it, it will basically be an empty data base.

    All the best,
    Nikolai
    the Telerik team

    Check out Telerik Trainer , the state of the art learning tool for Telerik products.
  7. Armysniper
    Armysniper avatar
    126 posts
    Registered:
    03 Mar 2005
    30 Mar 2009
    Link to this post
    So I purchased Red Gate's SQL Compare and SQL Data Compare and I have some differences between my database and my production site. I have brought down a copy of the production site database to my system and started to use the compare tool to merge my changes data wise. The problem I ran into is that I have NO idea what each table does. Doing a blind compare and synch does work as it was blowing away my local development changes in favor of changes done on the production site. My question is, is there a document you guys can give us that tells us what each table does? Some are self explanatory but some like sf_CmsWebControl and sf_VrsTxtData. In merging I want to make sure that the content of both are included when it comes to Generic Content, but for pages I want it to be the production site. So if you guys can give us a document that tells us what each table does, that would REALLY help me out. This is not something I want to mess up. If any of you guys that have used Red Gate could give me an idea what tables I need, that would help too! ;)
  8. Ivan Dimitrov
    Ivan Dimitrov avatar
    16072 posts
    Registered:
    12 Sep 2017
    30 Mar 2009
    Link to this post
    Hi Armysniper,

    We do not have documentation regarding the tables.

    sf_CmsWebControls collects data for the control IDs you have on a pages. - Example: EventsView on home.aspx.

    sf_VrsTxtData collects data for the version of an content item, conentIDs, culture that is set to this content, content meta keys and data set for this meta keys

    Best wishes,
    Ivan Dimitrov
    the Telerik team

    Check out Telerik Trainer , the state of the art learning tool for Telerik products.
  9. Armysniper
    Armysniper avatar
    126 posts
    Registered:
    03 Mar 2005
    30 Mar 2009
    Link to this post
    Maybe you guys could whip up something like you just did right there. :) You provided more help than I could have found just roaming the tree of tables. Anything like that would make it much easier for people to do this type of work until 4.0.
  10. Ivan Dimitrov
    Ivan Dimitrov avatar
    16072 posts
    Registered:
    12 Sep 2017
    31 Mar 2009
    Link to this post
    Hello Armysniper,

    I agree with you. However, from 4.0 we will have different conception about the database and it will be more easy for users to make any changes. As you know we always suggest using the api instead executing sql queries to the database.

    Thanks for your feedback!

    Greetings,
    Ivan Dimitrov
    the Telerik team

    Check out Telerik Trainer , the state of the art learning tool for Telerik products.
  11. Adam @Habanero
    Adam @Habanero avatar
    45 posts
    Registered:
    22 Jun 2012
    02 Apr 2009
    Link to this post
    On our team we have decided to keep the "source of truth" as the live database.

    What this means is that when we make changes on dev, we then make the same changes on live when we move our custom code over.

    It is not the best process as it is not automated, but it works.

    We then do a backup of the live db and move it back into dev.

    This works, requires no tools, and does not risk something strange happening in the database.  The DB of sitefinity in my opinion is a black box, you should not actually touch the internals.

    My 2 cents.        
Register for webinar
11 posts, 0 answered