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: https://dynamicsofdynamicscrm.wordpress.com/2015/04/16/new-versionerd-generator-tool-for-crm-2015/
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
53 thoughts on “ERD Generator for Dynamics CRM 2011/2013”
Amazing tool.. great work..
It will work fine with CRM 2015 also.
I am not able to connect on-premise 2011. Please guide me
What is the issue you are facing?
Great tool. Thanks.
If you do not want to share the source code, that’s fine, just please remove the project from CodePlex.
Thanks and done the needful, removed it from codeplex.
Really Good tool
can you share the file as an EXE. When I change the doc to an EXE it doesn’t work.
You need to change the file to .zip extension, extract it to a folder and run it from there.
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?
Can you tell me which entity are you using it on. Some entities would not work like system user, etc which have tonnes of relationships.
HI Deepesh, great work done….it would be truly usable stuff for generating ERD without any effort….Keep up the great work…..
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 ?
Which version of CRM are you connecting to?
Nice tool to have but whenever I generate it .. it gives operation completed message but nothing is generated in destination folder. I am using Dynamic CRM online (2013)
I do not think you should have any issues. can you check event logs?
Which section of event log should I refer to?
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
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
Any luck on above request please.
I tried it with same version and working fine. I am not sure what might be missing from your local machine.
Thanks for the reply Deepesh,
I have tried with the same version but no luck. It still doesn’t generate the document. Also no error found in the EventLog.
Not sure what I am doing wrong.
Don’t know what I may be missing either, but am having the same problem. REALLY hoping to get this figured out! Could be a phenomenal tool! Using v2015 online.
I have put CRM 2015 version to a new blog link mentioned in description. Tested and fixed some performance issues.
Thanks for being so responsive! Could you perhaps just run through the process with a screen record? For some reason, I am able to get it to run with the previous file, but not this one. Hard to imagine I’m missing something since I was able to execute successfully using previous file.
Please send me details of what screens you are seeing and error on firstname.lastname@example.org
[…] https://dynamicsofdynamicscrm.wordpress.com/2014/10/08/erd-generator-for-dynamics-crm-20112013/ […]
Very helpful and easy to use. Well done Deepesh!
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
Yes, purposely some entities which have lot of connections are omitted because it is not possible to plot them in the algorithm. Other example includes System user entity.
Deepesh, JOU YSTER (meaning in Afrikaans: You beaty, I love the tool) !
Regardt du Preez
[…] ERD Generator for Dynamics CRM 2011/2013 […]
Deepesh,I am able to connect with CRM,but its not creating any ERD file.I tried to wait 1-2 Hrs for output.
Do you have visio installed on your machine?
Windows identity framework is also required.
Hi Deepesh, I have installed visio.
I might need to debug on your environment to find the issue. Let me know if it is possible?
Thanks but I was used other tool which is in SDK. It was worked. Thanks for help.
Thanks Deepseh, really appreciate your time and efforts for this wonderful tool.
I have used it for CRM 2011 worked like a charm
Welcome GK Paribandala. Happy CRMing!
Great Work Deepesh.
What If i want to generate ER Diagram for all entities instead of selected entity?
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.
The solution is not meant for 300 entities in one go.
It might just time out and not work due to memory leaks. I am working on a new build.
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.
Thanks for the tool, I am trying to generate entity relationship for my crm 2011 app. Unfortunately i am getting an error when trying to connect. Hoping you could help.
Error while retrieving organizations: The remote name cound not be resolved: ‘https’
The remote name could not be resolved: ‘https’
Metadata contains a reference that cannot be resolved:
The upgraded version of tool is in works.
can use in dynamics 365 online version?
This tool is in the works for an upgrade
Deepesh – I’m trying to document an old 2011 system. Using your 2011/2013 tool, it appears to run to completion without error, but there is no output when it finishes. I tried running it on a Win7 system with Office and VS 2010, and on a WIn10 system with Office and VS 2017, and I had the same results on both. Any suggestions?
With too many number of entities and relationship, The tool does this. Its a limitation of the tool.
We have 215 custom entities, so that’s probably problem.
Thank you for the reply.