Copy User Personalization

Author: Fazle Hasan

May 17, 2022

Run this SQL Script to achieve this requirement:

use [Database]

go

Step #1 DELETE user personalization of the user, who would be assigned personalization from another user 

DELETE from [dbo].[User Metadata]

--select * from [dbo].[User Metadata]

WHERE [User SID] = '{SID of To User}'

go

Step #2 COPY user personalization of another user

INSERT into [dbo].[User Metadata]

([User SID],[Page ID],[Personalization ID],[Date],[Time],[Page Metadata Delta])

  SELECT  '{SID of To User}',

  a.[Page ID],

  a.[Personalization ID],

  a.[Date],

  a.[Time],

  a.[Page Metadata Delta]

  FROM [dbo].[User Metadata] a

  WHERE a.[User SID] = '{SID of From User}'

Reference:

https://community.dynamics.com/members/roberto-stefanetti

https://community.dynamics.com/business/b/arounddynamicsnavworld/posts/how-to-distribute-nav-views-and-user-personalizations