ERD Generator for Dynamics CRM 2011/2013

ERD Generator for Dynamics CRM 2011/2013 is a Windows Form application that is can be used for Dynamics CRM 2011 or Dynamics CRM 2013:


For CRM 2015, Use following link:

Here is a video to see how this will work:

Just download the above .doc file and rename it to .zip and run the tool.

This tool allows you to build ERD (Entity relationship diagrams) that are dynamically updated based on the published CRM entities and Fields. You can pick a source entity and build ERD around it. It generate a VISIO output but also lets you pick CSV to document Entity relationships.

It generates a CSV having details like:


It generates ERD in VISIO:


Visio legend below:


Hope it helps!

Check this out

42 thoughts on “ERD Generator for Dynamics CRM 2011/2013

  1. Hi Deepesh

    Great tool. Thanks.
    Could you please add the source code to CodePlex. Otherwise you are breaking their terms of use!
    If you do not want to share the source code, that’s fine, just please remove the project from CodePlex.


  2. Hi Deepesh,
    I am able to install and connect to the CRM server ,however the tool keeps returning a blank visio file whenever I generate an ERD.Is there something I am not doing correctly?

  3. HI Deepesh, great work done….it would be truly usable stuff for generating ERD without any effort….Keep up the great work…..

  4. Hi Dipesh,

    It seems a good stuff you did. i was able to download and unzip the application, i tested by connecting to CRM and selecting “Lead” entity, however it says “operation completed” but when i go to see folder which i selected to store generated diagram, it shows nothing, i tried several times but same result. Any idea why it should have happened ?


    • Application: ERDGenerator.exe Framework Version: v4.0.30319 Description: The process was terminated due to an unhandled exception. Exception Info: System.IO.FileLoadException Stack: at TeamAllocator_New.UserCloner..ctor() at TeamAllocator_New.Program.Main() error generated in event log

      • Hello Deepesh,

        Above, I have added error details. Kindly let me know if I am missing any environment setup or any library based on the error details.

        I think I am almost done and missing some settings.

        Your help will really make my day.

        Thanks in advance

  5. Great tool. Some entities are not showing e.g.: Service. It exists in the database as I can see it both with SQL Server management Studio, and CRM console (Settings -> Customisation -> Customise the System -> Entities

  6. Thanks Deepseh, really appreciate your time and efforts for this wonderful tool.
    I have used it for CRM 2011 worked like a charm

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s