Skip to content
Mohamed Mostafa's Blog

Mohamed Mostafa's Blog

#MSDyn365 #MSDynCRM Resources, Information, best practices & help on Microsoft Dynamics 365 CRM, .NET (C#, MVC & ASP.Net), Integration, Scribe, ECommerce, Business Transfomration and more.

Month: December 2012

Posted on 7 December 20124 October 2013

Generate Data Model and Entity Relationship Diagram (ERD) Visio diagram for a Dynamics CRM solution Using CRM SDK

This is a quick post on how to generate Data Model and Entity Relationship Diagram (ERD) Visio diagram for a Dynamics CRM implementation using the metadata application in the Dynamics CRM SDK.

Download and unpack Dynamics CRM SDK somewhere onto your machine. You can download Dynamics CRM 2011 (or 0nline) SDK from this location url:

http://www.microsoft.com/en-gb/download/details.aspx?id=24004

In your SDK unpacked location, you will find the following sample code for data model and ERD diagram generation (Visio):

SDK\SampleCode\CS\metadata\diagram\

Open the visual Studio solution (metadatadiagram.sln) and then build the Visual Studio solution (in release mode rather than debug). Once the visual studio project runs successfully, you will find a new release (or debug) folder under your bin folder: SDK\SampleCode\CS\metadata\diagram\bin\release

In this file you will find your file: Metadatadiagramconsole.exe

Run a command prompt as administrator (right click run as administrator) and then navigate to your exe file location. Type in the file name: Metadatadiagramconsole.exe and then press enter.

You will have the console application running and it will take you through the process to choose which CRM server and which organisation to connect to.

Select your chosen configuration (if you already have one setup) or create a new one.

The metadata diagram in Visio will be created for you in the bin folder under your debug or release folder.

One important note: If you run the command for the file Metadatadiagramconsole.exe it will generate the data model for absolutely all CRM entities which will be a very big and unreadable Visio file. You should limit your diagram to the entities you require so in this case your command line will be:

Metadatadiagramconsole.exe contact account

or

Metadatadiagramconsole.exe contact

instead of the general command:

Metadatadiagramconsole.exe

which will generate ERD for every single CRM entity which is huge and will probably take forever (haven’t dared to try it).

Hope this helps.

 

 

Share this:

  • Share
  • Twitter
  • LinkedIn
  • Email
  • Print
  • Facebook
  • Google
  • Reddit
  • Tumblr
  • Pinterest
  • Pocket

Like this:

Like Loading...
Authorised Microsoft Dynamics CRM Community Blog

Follow me on Twitter!

Tweets by @MIM_CRM

Top Posts

  • Microsoft Dynamics CRM 2011 and Online Error Codes - full list of API Web Service Error Codes from SDK
  • Automatically Track All Incoming and Outgoing Email Messages in Dynamics 365 without opening Outlook and across any device :: Pure Exchange and Dynamics 365 Server Side Synchronisation
  • Overcoming the 2 minutes limit on execution of Microsoft Dynamics CRM Online workflow activities and plugins #MSDynCRM
  • Difference between Microsoft Dynamics CRM Portals, ADX Studio, Portals from Microsoft, XRM Portals and Open Source Dynamics Portal
  • Set Field Default Value in Microsoft Dynamics CRM Online and On-premise using Business Rules without Javascript or custom components: plugins or workflows
  • Dynamics CRM Entity and Field Display Name, Field Schema Name and Field Logical name or Attribute name
  • Webhooks to Dynamics 365 Serverless Integration using Azure Functions
  • Generate Data Model and Entity Relationship Diagram (ERD) Visio diagram for a Dynamics CRM solution Using CRM SDK

Most recent comments

  • Pooja Srivastava on Microsoft Dynamics 365 Sales AI (Sales Artificial Intelligence) Navigation Link Disappears / cannot be found!
  • himanshu sharma on SAP and Microsoft Dynamics CRM Integration using SCRIBE
  • Thomas Sandsør on Automatically Track All Incoming and Outgoing Email Messages in Dynamics 365 without opening Outlook and across any device :: Pure Exchange and Dynamics 365 Server Side Synchronisation
  • Daryl LaBar on Dynamics 365 Testing Frameworks – open source GitHub Microsoft Dynamics CRM Testing Tools
  • suersh on Are you watching Dynamics 365 Fortnight Fridays?

RSS Feeds

  • RSS - Posts
  • RSS - Comments

RSS Dynamics 365 Blog

  • Dynamics 365 Customer Service adds Facebook Messenger capabilities 13 December 2019
  • Predictive lead scoring in Dynamics 365 Sales Insights 11 December 2019
  • Upcoming changes to the Cloud Business Applications competency 10 December 2019
  • Building a more successful workforce with Dynamics 365 Human Resources 6 December 2019
  • Microsoft Forms Pro updates help improve customer feedback management 5 December 2019

RSS Microsoft Dynamics CRM UK Blog

  • So Long, Farewell, Auf Wiedersehen, Goodbye 4 July 2014
  • Microsoft UK Apprenticeship Scheme 2014 4 June 2014
  • What Is The Microsoft & Salesforce.com Partnership All About? 2 June 2014

RSS Unknown Feed

Recent posts on my favourite blogs:

  • Keep your head high...
  • Infrastructure: Forests, Tenants, Orgs, Environments, Software as a Service, Infrastructure as a service .. the Vocabulary noise is high
  • Let's Change this number : Page Views 289,849
  • Just after sunset
  • How To Disable Unified Interface Only Setting in Dynamics 365
  • Microsoft Dynamics 365 v9.0 (on-premises) Downloads
  • Error of the Day: Could not load file or assembly Microsoft.Crm.Site.Services
  • Should I bring back Free Webinar Friday?
  • Using the Lookup function to create reports on multiple DataSets
  • Solution Layers
  • Clinical depression is not an emotion
  • A decade of XRM
  • Customizing Charts using XML – Part 1
  • Selecting a Mail Merge Addon for Microsoft Dynamics CRM 2011

Tags & Posts

#Announcement #LearnDyn365 #Learning #Mentoring #MSDynCRM .NET API Azure Book Review CRM CRM 2011 CRM 2013 CRM 2015 Custom Entity Dynamics Dynamics365 Dynamics 365 Dynamics CRM Entity Error Event Log Field GDPR IIS Integration Internet Explorer JavaScript Microsoft Microsoft Dynamics CRM MSDyn365 New Features Outlook Relationship Reporting Services Report Server Report Viewer SCRIBE Scribe Console Scribe CRM Adaptor script SDK SQL Server WCF Web Service what's new

Archives

  • March 2019
  • November 2018
  • October 2018
  • August 2018
  • July 2018
  • May 2018
  • March 2018
  • February 2018
  • January 2018
  • October 2017
  • August 2017
  • July 2017
  • June 2017
  • May 2017
  • April 2017
  • March 2017
  • February 2017
  • January 2017
  • November 2016
  • August 2016
  • July 2016
  • June 2016
  • January 2015
  • December 2014
  • November 2014
  • October 2014
  • September 2014
  • July 2014
  • June 2014
  • May 2014
  • April 2014
  • March 2014
  • February 2014
  • January 2014
  • October 2013
  • September 2013
  • August 2013
  • July 2013
  • June 2013
  • May 2013
  • April 2013
  • March 2013
  • February 2013
  • January 2013
  • December 2012
  • November 2012
  • October 2012
  • September 2012
  • August 2012
  • July 2012
  • June 2012
  • May 2012
  • April 2012
  • March 2012
  • February 2012
  • January 2012
  • December 2011
  • November 2011
  • September 2011
  • January 2011
  • December 2010
  • November 2010
  • October 2010
  • September 2010
  • August 2010
  • July 2010
  • June 2010
  • May 2010
  • April 2010
  • March 2010
  • February 2010
  • January 2010
  • November 2009
  • October 2009
  • September 2009
  • August 2009
  • July 2009
  • June 2009
  • April 2009
  • March 2009
  • February 2009
  • January 2009
Proudly powered by WordPress
loading Cancel
Post was not sent - check your email addresses!
Email check failed, please try again
Sorry, your blog cannot share posts by email.
%d bloggers like this: