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 similar database schemas. The only difference between the organizations' databases would be the specific customizations on the entities and fields.
Microsoft Dynamics CRM 2011 uses the concept of entities to name, which in a database language would be like a table. An entity is usually a noun such as a person or house. Dynamics CRM comes with lot of entities already created in the system, such as Account
, Contact
, and Invoice
.
As in any table, the entities contain fields. Each field...