Copied to clipboard

Flag this post as spam?

This post will be reported to the moderators as potential spam to be looked at


  • DanH 36 posts 61 karma points
    Oct 23, 2013 @ 11:15
    DanH
    0

    SQL Server Replication and Umbraco

    I would like to do a "transactional publication with updatable subscriptions".  SQL Server gave me this warning: 

     

    All articles in a publication allowing updatable subscriptions contain a uniqueidentifier column named 'MSrepl_tran_version' used for tracking changes to the replicated data. SQL Server adds such a column to published tables that do not have one. 
    Adding a new column will:
         » Cause INSERT statements without column lists to fail.
         » Increase the size of the table. 
    SQL Server will add a uniqueidentifier column to each of the following tables when the publication is created.
    [dbo].[cmsContent]
    [dbo].[cmsContentType]
    [dbo].[cmsContentType2ContentType]
    [dbo].[cmsContentTypeAllowedContentType]
    [dbo].[cmsContentVersion]
    [dbo].[cmsContentXml]
    [dbo].[cmsDataType]
    [dbo].[cmsDataTypePreValues]
    [dbo].[cmsDictionary]
    [dbo].[cmsDocument]
    [dbo].[cmsDocumentType]
    [dbo].[cmsLanguageText]
    [dbo].[cmsMacro]
    [dbo].[cmsMacroProperty]
    [dbo].[cmsMacroPropertyType]
    [dbo].[cmsMember]
    [dbo].[cmsMember2MemberGroup]
    [dbo].[cmsMemberType]
    [dbo].[cmsPreviewXml]
    [dbo].[cmsPropertyData]
    [dbo].[cmsPropertyType]
    [dbo].[cmsPropertyTypeGroup]
    [dbo].[cmsStylesheet]
    [dbo].[cmsStylesheetProperty]
    [dbo].[cmsTagRelationship]
    [dbo].[cmsTags]
    [dbo].[cmsTask]
    [dbo].[cmsTaskType]
    [dbo].[cmsTemplate]
    [dbo].[ELMAH_Error]
    [dbo].[umbracoDomains]
    [dbo].[umbracoLanguage]
    [dbo].[umbracoLog]
    [dbo].[umbracoNode]
    [dbo].[umbracoRelation]
    [dbo].[umbracoRelationType]
    [dbo].[umbracoServer]
    [dbo].[umbracoUser]
    [dbo].[umbracoUser2app]
    [dbo].[umbracoUser2NodeNotify]
    [dbo].[umbracoUser2NodePermission]
    [dbo].[umbracoUserType]
    That's a lot of tables being modified.  So does anyone know if this breaks Umbraco?  Is it possible to get replication working at all?
    Thanks.
  • DanH 36 posts 61 karma points
    Oct 25, 2013 @ 21:37
    DanH
    0

    No one has tried SQL Server Replication with Umbraco?  Shall I be the guinea pig then?

  • Jeavon Leopold 3074 posts 13632 karma points MVP 11x admin c-trib
    Oct 25, 2013 @ 23:52
    Jeavon Leopold
    0

    Hi Dan,

    I've not heard of anyone having done this, interested to hear what happens :-)

    Jeavon

  • Simon steed 378 posts 700 karma points
    Nov 18, 2013 @ 22:35
    Simon steed
    0

    Hi Dan

    How did you get on with this, i'm about to start looking at this as a possible solution to sharing the same db across multiple devs

    Simon

  • This forum is in read-only mode while we transition to the new forum.

    You can continue this topic on the new forum by tapping the "Continue discussion" link below.

Please Sign in or register to post replies