locked
many to many with data migration manager RRS feed

  • Question

  • I need to migrate source data into CRM 4.0 using data migration manager. One of the relationships that I need to migrate is a many to many that has been created as a native relationship, meaning that the system has created a "hidden" intersect table. I have been able to see this interesct table in SQL Server, but not sure how to create the relationship during the migration process as I can not see any way to update the intersect table with the correct foreign keys. Any ideas?

    -Mark
    Friday, October 30, 2009 2:53 PM

Answers

  • Data Migration Manager cannot migrate data into many-to-many relationships. It can only migrate data into one-to-many or many-to-one relationships.
    My Dynamics CRM Blog: http://bovoweb.blogspot.com
    Friday, October 30, 2009 2:57 PM
  • Hi,

    You could use a tool such as scribe which supports writting N:N relationships OR manually write code via the crm web services.
    Alex Fagundes - www.PowerObjects.com
    Friday, October 30, 2009 3:54 PM
  • Hi,

    I wrote a small command line tool to import Many to Many relationships into CRM, you'll need VS 2008 to compile it, but that's it.

    http://crmmanytomanyimport.codeplex.com/

    You just need to put the keys (GUIDS) from either side of the M:M relationship into it.

    I should get around to uploading a binary to codeplex.. maybe this weekend I'll do it.

    Cheers

    Matt.

    Saturday, October 31, 2009 12:12 AM

All replies

  • Data Migration Manager cannot migrate data into many-to-many relationships. It can only migrate data into one-to-many or many-to-one relationships.
    My Dynamics CRM Blog: http://bovoweb.blogspot.com
    Friday, October 30, 2009 2:57 PM
  • If that is the case, then how do people migrate data into out of the box N:N relationships such as campaign to product?
    Friday, October 30, 2009 3:18 PM
  • Hi,

    You could use a tool such as scribe which supports writting N:N relationships OR manually write code via the crm web services.
    Alex Fagundes - www.PowerObjects.com
    Friday, October 30, 2009 3:54 PM
  • Can anyone recommend a good book, article, anything that goes into more detail about DMM?

    -Mark
    Friday, October 30, 2009 5:25 PM
  • Hi,

    I wrote a small command line tool to import Many to Many relationships into CRM, you'll need VS 2008 to compile it, but that's it.

    http://crmmanytomanyimport.codeplex.com/

    You just need to put the keys (GUIDS) from either side of the M:M relationship into it.

    I should get around to uploading a binary to codeplex.. maybe this weekend I'll do it.

    Cheers

    Matt.

    Saturday, October 31, 2009 12:12 AM
  • Thank you, Matt. That looks very interesting. I'll definitely give your utility a try. How would you use it if you don't have the GUIDs ahead of time? I assume you need to import the data to the entities first and then extract the GUIDs before putting them into a CSV for uploading with your tool.

    -Mark
    Saturday, October 31, 2009 2:25 PM