Sign in
Microsoft.com
 
Microsoft
 
 
 

locked
CRM and Peer to Peer replication RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    I would liket to set up peer to peer replication from Microsoft CRM 2011 using SQL Server 2008R2 Enterprise Edition. Is this sort of replication supported?

    • Edited by dbSlave65 Thursday, November 15, 2012 6:01 PM
    Thursday, November 15, 2012 5:58 PM

Answers

  • Question
    Sign in to vote
    0
    Sign in to vote

    If you want to populate a data warehouse, then I wouldn't call this peer-to-peer replication - the CRM server and the data warehouse will perform different roles.

    A key question is whether the data warehouse should have the same schema as the CRM system. Normally, I would expect a data warehouse wou;d have a different schema,to optimise query performance, and to only include relevant data. If the schemas are different, then you'd need to use ETL tools like SSIS.

    You could use CDC, though I'm not sure how easy it will be to interpret this data - SSIS 2012 has components that use CDC, but SQL 2008. You may find it easier to either use the modifiedon attribute on each entity to identify changes (though that doesn't help for N-N relationships), or just to reload all the data on a batch basis

    Microsoft CRM MVP - http://mscrmuk.blogspot.com/ http://www.excitation.co.uk

    • Marked as answer by dbSlave65 Tuesday, March 8, 2016 6:33 PM
    Thursday, November 22, 2012 9:34 AM
    Moderator

All replies

  • Question
    Sign in to vote
    0
    Sign in to vote

    SQL Server replication is not supported with Microsoft Dynamics CRM. If you run SQL Server replication, disable it.

    From: Microsoft Dynamics CRM 2011 Implementation Guide

    Jason Lattimer
    My Blog -  Follow me on Twitter -  LinkedIn

    Friday, November 16, 2012 3:06 AM
    Moderator
  • Question
    Sign in to vote
    0
    Sign in to vote
    Can you tell my why. Also do you know if CDC Change Data Capture is supported?
    Wednesday, November 21, 2012 2:49 PM
  • Question
    Sign in to vote
    0
    Sign in to vote

    I'm not sure that is is explicitly called out anywhere as being supported or not. My understanding of CDC is that is does not change the source database's schema as something that would make CRM database schema changes would almost immediately be consider unsupported. 

    Depending on your specific requirements, you might also look at using the native CRM auditing functionality. 

    Microsoft Dynamics CRM 2011 – Auditing 

    Jason Lattimer
    My Blog -  Follow me on Twitter -  LinkedIn

    Wednesday, November 21, 2012 3:23 PM
    Moderator
  • Question
    Sign in to vote
    0
    Sign in to vote
    I want to use it to populate a data warehouse.
    Thursday, November 22, 2012 5:43 AM
  • Question
    Sign in to vote
    0
    Sign in to vote

    If you want to populate a data warehouse, then I wouldn't call this peer-to-peer replication - the CRM server and the data warehouse will perform different roles.

    A key question is whether the data warehouse should have the same schema as the CRM system. Normally, I would expect a data warehouse wou;d have a different schema,to optimise query performance, and to only include relevant data. If the schemas are different, then you'd need to use ETL tools like SSIS.

    You could use CDC, though I'm not sure how easy it will be to interpret this data - SSIS 2012 has components that use CDC, but SQL 2008. You may find it easier to either use the modifiedon attribute on each entity to identify changes (though that doesn't help for N-N relationships), or just to reload all the data on a batch basis

    Microsoft CRM MVP - http://mscrmuk.blogspot.com/ http://www.excitation.co.uk

    • Marked as answer by dbSlave65 Tuesday, March 8, 2016 6:33 PM
    Thursday, November 22, 2012 9:34 AM
    Moderator
  • Question
    Sign in to vote
    0
    Sign in to vote
    SSIS will not work as it need to be real time.
    Friday, November 23, 2012 3:35 PM