How does one rename files that are moved across storages?

I’ve just used external (file management tools) to move 435 music files from one storage to another. When I went to re-sync in DBManager I realised that the neat renaming feature is only available for moves within a single storage.

Is there another way to “relocate” the files (i.e. change the storage and path to the files) in the database? I’d rather not lose their play history and other metadata.

Thanks in advance.


Problem solved. We created a tool that uses psql and bash.