web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics CRM (Archived) / Updating CRM using SQL
Microsoft Dynamics CRM (Archived)

Updating CRM using SQL

(0) ShareShare
ReportReport
Posted on by Joe Spitler 1,290

I have a couple of custom entities in our Dynamics CRM DB.  Certain fields will change nightly.  It's so easy to do it with SQL and to schedule a nightly stored procedure that I really want to do that.  I keep hearing that that is discouraged.  Can someone please tell me why? 

Thanks.

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    jlattimer Profile Picture
    jlattimer 24,562 on at

    Using the API to make changes "protects" the data to ensure the application will work correctly at all times. An accidental delete or an inappropriate update could cause something to stop working when it comes time for the data to load in the UI. From a supportability standpoint, Microsoft can't fully predicate what SQL a person could come up with and execute but they can control what can be done with the API.

  • Gus Gonzalez Profile Picture
    Gus Gonzalez 27,113 on at

    Because direct changes to the Database are not supported by Microsoft.

  • Joe Spitler Profile Picture
    Joe Spitler 1,290 on at

    Well, I guess I don't know what all that means.  I'm a SQL guy and SQL is easy.  What do I need to learn to do this?

  • jlattimer Profile Picture
    jlattimer 24,562 on at

    It means basically you can do anything you want, but if you make changes with direct SQL or make changes to the database schema, you can't be assured that Microsoft will support you if a problem develops as a result. Updates and upgrades could also potentially be an issue.

    That's not saying a person isn't capable of making changes directly - it just isn't the preferred method. More than likely resources to guide you will be few and far between if at all.

  • Joe Spitler Profile Picture
    Joe Spitler 1,290 on at

    Tkanks. Okay, that's fine.  I've downloaded the MS CRM 2011 SDK and the developer training kit.  I've done further searches and can't seem to find any turorials.  Where might I look?

  • jlattimer Profile Picture
    jlattimer 24,562 on at

    The developer training kit has some videos and hands on labs included. The SDK has tons of samples to reference. Beyond that there are many blogs out there that have examples that you can use. Most all of your custom code will be either  be a plugin, a workflow/process, or JavaScript in nature to including those in your search might narrow down the results.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

#1
SA-08121319-0 Profile Picture

SA-08121319-0 4

#1
Calum MacFarlane Profile Picture

Calum MacFarlane 4

#3
Alex Fun Wei Jie Profile Picture

Alex Fun Wei Jie 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans