update npvr database UNC paths

[artmetz]

My QNAP NAS finally failed, but fortunately I knew it was going to happen.
I have a new Terramaster NAS setup and have been using robocopy to keep it in synch with the old NAS until I had time to remap my clients.
Unfortunately, I'm forced to do that now.
This isn't an easy topic to search the forums on, or I'm using the wrong search terms without luck.
I've been using UNC paths for NPVR instead of drive letters, so it's not a simple matter of mapping the same letter to the new drive.
Question is, what's a good way to update the NPVR database and change my UNC from "NAS315" to "NAS0324"? (I'll backup the db first).

It's not clear to me if and of the NextTool commands will accomplish this.
I'm capable of using SQL to update the database.
Art

[mvallevand]

Why not just change the hostname of the new NAS?

Martin

[artmetz]

Was hoping to keep both running and swap the roles.

[mvallevand]

Change the name on the old broken one first.

If you want to do this with sqlite3 it would be something like

Code:

update scheduled recording
set  filename = replace(filename,'NAS315','NAS0324')
where filename like '%NAS315%';

Make sure you have the config.xml settings to not remove files or trees that aren't found and backup first.

Martin

[artmetz]

Thanks. You confirmed the SQL that I was just about to post.
should be scheduled_recording (is missing the underbar)
Thanks,
Art