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?
SQL Server Replication and Umbraco
I would like to do a "transactional publication with updatable subscriptions". SQL Server gave me this warning:
No one has tried SQL Server Replication with Umbraco? Shall I be the guinea pig then?
Hi Dan,
I've not heard of anyone having done this, interested to hear what happens :-)
Jeavon
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
is working on a reply...