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

46 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

  7. Hello,

    I know this is an old post but I am hoping it is still being monitored. Does the ERD generator create a model of the tables being used or is it base on what entity you select? I am trying to create an ERD model of the entities that are actually being used by the users in the legacy system before we migrate to Dynamics 365.

    I created one using ERWIN but there are over 300 tables and I am not sure if all are really being used. I excluded the ones I noted rowcount = 0 but I would like to go further or separate model into subject areas if possible in an easier and quicker fashion.

      • I was thinking to divide entities based on subject area. I am not sure if all 300 are published. I indicated over 300 because I was going by the row count >0 to see what to include in the ERWIN model. It maybe different using the generator within CRM. I was hoping for alternatives.


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