DB relationships in Microsoft CRM 2011
Is there an easier way for tracking down the relationships between tables in MS CRM 2011 than using the ER diagram from http://www.microsoft.com/en-us/download/details.aspx?id=2640?
More particularly, I entered a note for a Contact and I need to build a Select that shows me the note and the Contact’s name.
So I have to go from dbo.Annotation to dbo.Contact.
I also tried View Dependencies from SQL Management studio but it only shows me BusinessUnitBase and OwnerBase.
More particularly, I entered a note for a Contact and I need to build a Select that shows me the note and the Contact’s name.
So I have to go from dbo.Annotation to dbo.Contact.
I also tried View Dependencies from SQL Management studio but it only shows me BusinessUnitBase and OwnerBase.
Who is Participating?
Yeah, it is a pain in the proverbial but "they" all say use those ER diagrams.
It has been quite some time since playing with CRM at a DB level, but thought I would chime in anyway...
There is a bit more help out there...
Have a look at the reporting modules and the "Filtered" views (filtered taking into consideration the permissions you have to actually see the data) : http://msdn.microsoft.com/en-us/library/cc308184.aspx And following that through... I have linked to the "customer" filtered views : http://msdn.microsoft.com/en-us/library/dd548500.aspx
Look for "Report Writing" as a general guide - found more help that way than trying to unravel the actual database. Having said that, once you get into the actual DB and have a look at the views (the views also exist without the "filtered" prefix)
http://msdn.microsoft.com/en-us/library/cc308174.aspx
Hope that helps a bit...
p.s. there is a wiki which might help : http://social.technet.microsoft.com/wiki/contents/articles/2490.microsoft-dynamics-crm-2011-development-resources-en-us.aspx
It has been quite some time since playing with CRM at a DB level, but thought I would chime in anyway...
There is a bit more help out there...
Have a look at the reporting modules and the "Filtered" views (filtered taking into consideration the permissions you have to actually see the data) : http://msdn.microsoft.com/en-us/library/cc308184.aspx And following that through... I have linked to the "customer" filtered views : http://msdn.microsoft.com/en-us/library/dd548500.aspx
Look for "Report Writing" as a general guide - found more help that way than trying to unravel the actual database. Having said that, once you get into the actual DB and have a look at the views (the views also exist without the "filtered" prefix)
http://msdn.microsoft.com/en-us/library/cc308174.aspx
Hope that helps a bit...
p.s. there is a wiki which might help : http://social.technet.microsoft.com/wiki/contents/articles/2490.microsoft-dynamics-crm-2011-development-resources-en-us.aspx
Question has a verified solution.
Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.
Have a better answer? Share it in a comment.
All Courses
From novice to tech pro — start learning today.
-
Course of the Month9 days, 8 hours left to enrollMonitoring and Operating a Private Cloud with System Center 2012 R2 273 lessons
http://www.thuta.info/2011/04/xrmvisioer-crmxrm-2011-er-diagram.html
Regards,
Chinmay.