Are the SQL Views Updateable i.e. FilteredContact

• 10-28-2008 10:39 AM

  Robert Mackey Joined on 08-07-2008 Posts 1

  Are the SQL Views Updateable i.e. FilteredContact Reply Contact 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…

  Tags: Data Migration Manager, workflow, CRM setup, Microsoft Dynamics CRM Data Migration Manager, Export, Import, CRM 4, Microsoft CRM 4, synchronization, Relationship migration

• 11-03-2008 11:53 PM

  In reply to

  Frank Hermes Joined on 07-01-2008 Posts 163

  Re: Are the SQL Views Updateable i.e. FilteredContact Reply Contact Robert Mackey: Are these the views used by the “Bulk Update”  No.   Robert Mackey: If they don’t can I create a view that does? 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 :)