Microsoft Dynamics CRM在SQL Server的何处存储OptionSet值？ [英] Where does Microsoft Dynamics CRM store OptionSet values in SQL Server?

问题描述

我正在向Microsoft Dynamics CRM 2011进行数据迁移，因此需要对源进行协调，以确保所有内容均成功加载。

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.

为此，我我直接在SQL Server中查询SQL，但是我似乎找不到OptionSet数据的存储位置。有人知道它存储在哪个表中吗？

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?

推荐答案

这些都存储在StringMapBase表中。您将通过实体的对象类型代码，属性名称，选项集值和语言进行查询，这将为您提供该属性的显示值。

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.

这篇关于Microsoft Dynamics CRM在SQL Server的何处存储OptionSet值？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！