Microsoft Dynamics CRM 2011: Updating a lookup field using SQL -

Microsoft Dynamics CRM 2011: Updating a lookup field using SQL -

i have thousands of incidents in crm either resolved or cancelled. have added new lookup field incident's form of course of study incidents closed not have value in it. essential populate lookup field incidents.

i tried create console application have updated closed incidents apparently can't update incident unless activate first.

reopening (and closing again) incident @ point pretty much not wanted solution.

so wondering updating lookup field writing simple sql statement. know highly unsupported question possible go wrong? tried update 1 incident using sql , seems work before update of them want know why should no this? plenty update 1 lookup field in database table (to set relevant guid it) or there else should update too?

or if have other solutions how populate field without reopening incident i'd happy hear it.

as found sdk need reactivate incident first.

by sql unsupported , preferable avoid direct updates.

you can face issues sql way, illustration workflows not triggered sql updates, in case not face issues updating closed incidents (probably need lookup filled reporting requirements).

as far know if want go sql need update single attribute.

up final decision.

dynamics-crm-2011 dynamics-crm