Microsoft xRM Database Structure

The more you understand about the Database structure, the more easy for you to work with Microsoft Dynamic CRM (xRM). You should remember that each CRM Deployment will contain these Database. All the content of this article focus on CRM 2013, 2015, maybe there is different from latest version. You should check frequently in MSDN.

Config Database: MSCRM_Config

This database will contain CRM Server information deployment, such as users and licensing. One config database will be created during the time you  install CRM server. It is important to remem that  “Each CRM Deployment will require its own SQL instance“.

Content Database: Organization_name_MSCRM

• CRM metadata architecture allows for portability of CRM configuration solutions. All configurations are in the metadata.
• Metadata browser from the SDK provides a method of viewing schema. Including in CRM SDK, we can see 1 solution for viewing Medata from CRM user interface.
• CRM Databases may be moved to different drives as well as different SQL Servers.
• Primary steps will require a backup and restore of the databases, modify the registry to change the SQL server, and launch the Deployment Manager to the edit organization.

Reporting Services databases

ReportServer and ReportServerTempDB will be the default report databases. Microsoft Dynamics uses SQL Server Reporting Services which must be installed in native mode.

Hope it is useful.