Change attachment path

Hi,

One of our customers installed a new SBO server and also changed the name

On the old server we had a lot of attachments

Ofcourse we can copy the attachments directory to the new server but wat is the best way to alter the SAP tables ?

In OCLG we find a lot of entrys like
oldserver\attachments\fil.pdf

I know that it can be done by a SQL update but how should we do this the correct way ?

Please advise

Thanks,

Paul