Menu
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?
272
As a Dynamics 365 user, your data will be stored at one of Microsoft's large data centers. These centers are located around the world. Microsoft allows you to determine exactly where your data will be stored based on information about which services you are using and where your business is located.
The Microsoft Dynamics AX database is a relational database. Microsoft Dynamics AX supports Microsoft SQL Server and Oracle databases. In addition to standard relational database functionality, you can do the following: View historical data by using cubes.
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.
143
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
