How to properly update content via DB

Questions
1

Hi, I want to update some content via DB, what is correct procedure after applying changes in database? So far from testing I got mixed results. I updated textValue in [umbracoPropertyData] table for one of the properties then I tried to rebuild database cache via backoffice and delete umbraco/Data/TEMP/NuCache and restart the site, trying these things didn’t always result on content being updated for the property. What is “correct“ way of doing this?

2

I doubt there is a correct way of doing it, lol! But I think it would help if you tell us why you want to do this.

3

I wanted to send CSV created by SQL query with a lot of properties that need to be translated to external team. This way I could easily import them back via SQL using same CSV but with translated properties.

4

So far I have found that this seem to give same result everytime:

  1. Update DB
    update [umbracoPropertyData]
    set textValue = ‘…’
    where id = 2666026
  2. Cold restart of site
  3. Force republish for the nodes:
    IContent? content = _contentService.GetById(...);
    _contentService.SaveAndPublishBranch(content, PublishBranchFilter.All)

Could this be ok or should I find different approach?