Can anyone tell me how I can mimic the Salesforce Upsert process? I can import data into MSCRM just fine but now I will need a good way to do an update of already existing records. I'm quite SQL savy and I wondered if that was not a bad idea to do via SQL. For example, lets say I want to update EmailAddress1:
Update
dbo.ContactBase
Set
EmailAddress1 = b.email
From
dbo.ContactBase a
inner join custom_db.dbo.MyTableOfeMail b
on a.ContactId = b.ContactId
Where MyTableofemail is the table I prepared with the correct ContactID and the column 'email' is the email I want to update to. I have been told it's not a good idea to update MSCRM via SQL but I would think this is safe enough. Does anyone out there do this sort of thing?
Thanks,
Joe
*This post is locked for comments
I have the same question (0)
