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 376 posts 688 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

Please Sign in or register to post replies

Write your reply to:

Draft