Where does Microsoft Dynamics CRM store OptionSet values in SQL Server?

sql-server dynamics-crm-2011
Commander92 picture Commander92 · Sep 7, 2011 · Viewed 37.8k times · Source

I'm doing a data migration in to Microsoft Dynamics CRM 2011 and need to perform reconciliations against the source to ensure that everything loaded successfully.

To do this I am querying the SQL directly in SQL Server, but I can't seem to find where the OptionSet data is stored. Does anyone know what table(s) it's stored in?

Answer

Matt picture Matt · Sep 7, 2011

These are all stored in the StringMapBase table. You'll query via object type code of the entity, attribute name, option set value and language and that'll give you the display value of the attribute.

Related questions

Error" ...The OLE DB Source.Outputs[OLE DB Source Output].Columns[XXXXXXXX] on the non-error output has no corresponding output

Ive spent hours trying to fix this issue. For the column that's giving me the problem i am using a scalar-function in sql server to grab the name. The function is correct and works fine. I then use a stored …

Read More
How to Inner join with query expression crm

I'm trying to do a simple inner join with Query Expression. I'm trying to covert this query with QE but I got always the same error. I'm doing this QE: Entity Role = new Entity(); Role.LogicalName = "role"; Entity SystemUserRoles = new …

Read More
In which table MS CRM system views are stored?

I am looking for the table that holds the criteria records for MS Dynamics CRM system views or saved Advanced Find views. Every saved view (system view or custom view) has some criteria that are used to filter the results. …

Read More