O'Reilly logo

Microsoft Dynamics CRM 2011 Reporting by Damian Sinay

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 2. Database Basics

Microsoft Dynamics CRM 2011 makes extensive use of the database that we are going to look at through the entire book.

In this chapter we will cover:

  • ERD (Entity Relationships Diagrams) basics
  • SQL basics
  • SQL advanced
  • FetchXML

ERD basics

Microsoft Dynamics CRM 2011 uses SQL Server as its database backend. There are two main databases that are created after the CRM server is initially set up. The MSCRM_CONFIG database, which is the one that holds different organizations' data and general configurations. The other is a database for the organization itself, with a name like <organizationname>_MSCRM. Depending on the number of CRM organizations you have in the system, you will have the same number of databases ending with _MSCRM ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required