Since CRM entities are composed of TWO SQL tables (i.e; extension and extension based), it is very time consuming for developers to draw an ER diagrams for each entity. If we used ER Diagram generators in the market, the diagrams they generated become very complex and it will not be easy to understand by users when they try read it.
That's why, Microsoft came out with a very useful Metadata diagram generator (CRM ER Diagram Generator) which we can find under CRM SDK samples. But, I still feel that the program is quite difficult to use for beginners since it is written in console application mode and can be run only from server (if you do not know how to change server URL in program).
This weekend, I re-modal the whole program to provide following functions for CRM developers:
- Allow program to run from anywhere (no need to reside in server)
- Ask users to choose which entities they want to generate diagram and where to save them
- Allow each ER diagram to save in separate pages within one MS Visio file
- Allow users to customize exclusion entities and relationships when they generate diagram
- .NET Framework 2.0
- Microsoft Visio
Feel free to use this application.
Either leave comment or email me if you want to know further information.
Revised version can be found here.