Reply to thread

Message

<blockquote data-quote="longdogs" data-source="post: 1095302" data-attributes="member: 100430">I think I have done it. Copied the database files to work on them, also archived a copy. I used RazorSQL (it has a 30 day trial) and connected to each of the databases in turn. Right click on the table to edit, if you have more than 2500 rows, increase the max rows at the top, click find and replace, set the find and replace strings and click replace all. Wait a long time for the replacements to occur. Once done close the find/replace dialog box and then click SQL tab and then click execute SQL. Wait a long time again. It is now done for this database. Check with SQLiteBrowser that it looks OK still. Repeated for all the databases that needed editing, then copied, with replace, them back into the team media portal database folder. Disconnected my network PC. The NAS is connected of course. Started up MP and it all looks OK... time will tell.Went surprising well even though I didn't know what I was doing most of the time.</blockquote>

[QUOTE="longdogs, post: 1095302, member: 100430"] I think I have done it. Copied the database files to work on them, also archived a copy. I used RazorSQL (it has a 30 day trial) and connected to each of the databases in turn. Right click on the table to edit, if you have more than 2500 rows, increase the max rows at the top, click find and replace, set the find and replace strings and click replace all. Wait a long time for the replacements to occur. Once done close the find/replace dialog box and then click SQL tab and then click execute SQL. Wait a long time again. It is now done for this database. Check with SQLiteBrowser that it looks OK still. Repeated for all the databases that needed editing, then copied, with replace, them back into the team media portal database folder. Disconnected my network PC. The NAS is connected of course. Started up MP and it all looks OK... time will tell. Went surprising well even though I didn't know what I was doing most of the time. [/QUOTE]

Verification