web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Service | Customer Service, Contact Center, Fie...
Suggested Answer

Reverse Engineer - ER diagrams

(0) ShareShare
ReportReport
Posted on by 5

This seems to be a repeat, but we really need to be able to see an ER diagram of our database. We have Microsoft Dynamics 365 - Cloud, and we are stuck with going entity by entity and then clicking on show relationships. Tracing this back field by field to see a text description is painful and unclear. Please tell me someone has something that actually builds a real DIAGRAM.

I have the same question (0)
  • Suggested answer
    Community Member Profile Picture
    on at

    Hi ChrisGriggs,

    You can use the Metadata Diagram sample code provided for Dynamics 365 to generate the entity relationship diagrams manually.

    Use metadata to generate entity diagrams (Developer Guide for Dynamics 365 Customer Engagement (on-premises)) | Microsoft Docs

    If you have coding experience, a nifty little tool in the CRM SDK called MetaDiagramConsole.exe which allows you to generate Visio diagrams of entity relationship mappings.

    How to Generate Dynamics 365 ERD (shanebart.com)

    In addition, there are three tools from XrmToolBox that is ideal for users who have no coding experience:

    https://docs.microsoft.com/en-us/dynamics365/customerengagement/on-premises/developer/use-metadata-generate-entity-diagrams?view=op-9-1#community-tools 

    pastedimage1642125231560v1.png

  • Community Member Profile Picture
    on at

    Hi Partner,

    Can you click Yes under "Did this answer your question?" to close this thread if my answer is helpful.

     pastedimage1643276340547v1.png

    Thanks in advance!:)

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > Service | Customer Service, Contact Center, Field Service, Guides

#1
Tom_Gioielli Profile Picture

Tom_Gioielli 45 Super User 2025 Season 2

#2
Daniyal Khaleel Profile Picture

Daniyal Khaleel 27 Most Valuable Professional

#3
Soundari Profile Picture

Soundari 15

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans