Hi @techge,
Quite old question, but I have to move my collection recently. It seems OriNOVet missed some data and tables to edit (may be new in last strawberry versions).

So, using only SQL request , you can use :

UPDATE
    table
SET
    mycolumn = REPLACE(mycolumn,'oldpath_substring','newpath_substring')
WHERE
    mycolumn like '%oldpath_substring%';

I hope this is a complete data update :

UPDATE songs SET url           = REPLACE(url,          'oldpath_substring','newpath_substring') WHERE url           like '%oldpath_substring%';                                       
UPDATE songs SET art_automatic = REPLACE(art_automatic,'oldpath_substring','newpath_substring') WHERE art_automatic like '%oldpath_substring%';
UPDATE songs SET art_manual    = REPLACE(art_manual,   'oldpath_substring','newpath_substring') WHERE art_manual    like '%oldpath_substring%';
UPDATE songs SET cue_path      = REPLACE(cue_path,     'oldpath_substring','newpath_substring') WHERE cue_path      like '%oldpath_substring%';

UPDATE subdirectories SET path = REPLACE(path,'oldpath_substring','newpath_substring') WHERE path like '%oldpath_substring%' ;
UPDATE directories    SET path = REPLACE(path,'oldpath_substring','newpath_substring') WHERE path like '%oldpath_substring%' ;

Edit :
Before editing the database, may be disable "auto update library at startup" and "monitor library modification" in paramaters menu.

visitor