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) / Are the SQL Views Upda...
Microsoft Dynamics CRM (Archived)

Are the SQL Views Updateable i.e. FilteredContact

(0) ShareShare
ReportReport
Posted on by Robert Mackey 85
I am reading up on using the SDK and it’s not pretty compared to the Scribe or SSIS. I reviewed some of the views of the CRM database in SQL Server Management Studio such as the [MSCRM.dbo.FilteredContact]. The csv file bulk update method in CRM for the Contact table left me with more questions about the views such as:            Are these the views used by the “Bulk Update”            If they are then does the update use the GUID's to update the connecting tables?            If they don’t can I create a view that does?If we have the ability to read the view and compare it against an external Contact table and then update it then we could add it as a nightly service.  But only if the views are update-able…

*This post is locked for comments

I have the same question (0)
  • Frank Hermes Profile Picture
    Frank Hermes on at

    [quote user="Robert Mackey"]Are these the views used by the “Bulk Update” [/quote]

    No.

     [quote user="Robert Mackey"]If they don’t can I create a view that does?[/quote]

    Yes you can, but generally speaking you should not because updating via sql is not supported. Why not using the webservices? If you are absolutely certain that you want to update via sql statements, you can, but you should have deeper understanding of the db structure, the tables and their relations. To be honest: i did some mass updates via sql, but don't tell Microsoft :)

  • hassan chandoklow Profile Picture
    hassan chandoklow 175 on at

    you can use ssis to insert and update data build ssis custome destination an ssis custom connection

     in your custome destination usin create and update service

     

    see this link how to programm custome destination

    http://technet.microsoft.com/en-us/library/ms135899(SQL.90).aspx

     

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