Avatar

Correct answer by
Community Advisor

Hi,

Update activity will alter the audit fields, @lastmodified, etc, and may miss data if executing concurrent to a data load.

To do a straight atomic copy, use sql script: update nmsrecipient set smobilephone = sphone;

Make sure to update existing ETL's, etc accordingly.

Changing the address mapping also works, though you'd be stealing phone channel's field, making it awkward if that gets installed in the future.

Thanks,
-Jon

View solution in original post