Search code examples
dynamics-crm-2011dynamics-crmcrmdynamics-crm-2013microsoft-dynamics

How to get CRM 2013 Online Database schema


How can i get database schema for my Dynamics CRM 2013 Online? Is it possible in CRM 2013 online? If it is possible to get database schema, can you tell me any procedure?


Solution

  • A quicker option that doesn't require getting a backup of the database is to use the XRMtoolbox available at http://xrmtoolbox.codeplex.com and use the Metadata Doc Generator tool. That allows you to retrieve the Metadata and select all or some entities and various options for those entities and to save the output to a Word document or an Excel document. While maybe not technically a database schema, it allows you to see even more information at a glance than you would see in the database schema because you can see things like if an attribute is available for Advanced find and which form or forms it is located on.

    Another option is to install a local copy of Microsoft CRM that is the same version as the online version and to export the customizations and solutions from the CRM online version and then import them to the local CRM install. This will give your local database the same schema as what exists in CRM online and you can either view the schema in SQL server management studio or other SQL database schema generation tools. Hope this helps.