We moved a site collection to a new web application in the same farm and performed a version upgrade from sp2013 to sp2019. The site collection url has been changed

Technically we dismounted the content db, then mounted it into the new web application and updated the site.

But the comments in the note board webpart, so called “social comments“, are stored in the user profile service database.

If you take a closer look at the table “dbo.socialcomments”, you will notice that there’s the url id column.

enter image description here

In order to get the comments back I could replace the old url id with the new one but I don’t know how to do

I followed this link but doesn't work because Microsoft blocked all commands PowerShell of Tag & Note unfortunately.

If you know any solution based on SQL I'll be grateful.

1 Answer 1


Modifying the Content DB from SQL is not supported in SharePoint. You can do it, but Microsoft won't support it.

  • Thank you for your reply Jan 20, 2022 at 10:31

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.