247
I have a requirement to extract Dynamics CRM Entities and its attributes using SQL Script from SQL Server Database. Is there any way to do this using SQL Script with SQL Server Database.
Thanks
AR
Hello,
You can extract these details with the help of XrmToolBox plugin Metadata Browser.
For SQL Script ->
Go to your organisation_mscrm database->tables->Metadataschema.entity (you will find this at the last)
In this table u will get all the list of entities. Similar Metadataschema.Attribute table for the list of attributes.
Hello,
Not sure why you want to do that but you can do that similar to other SQL table depending on which version you are using for example based on the tag it seems you are using CRM 2011, in CRM 2011 there used be two tables for entities,
1. Your entity for example Account
2. Entity+extentionbase for example Accountextentionbase
so depending on your entity name you can look for CRM SQL db and queries these entity to get attributes details.
You can refer : softchief.com/.../
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,269
Super User 2024 Season 2
#2
Martin Dráb
230,198
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (