In VDJ they have a built in backup and restore tool so you can transfer to a new machine (PC or Mac) with the minimal of effort.
No hacking SQL databases required.
The proper method would not just match file names, but things like file sizes, metadata, etc. =) Just some ideas i had floating around when pontificating a fully-fleshed out version of auto-relocate.
You could just store a CRC checksum and use that to match files. However this is slow, and change one letter in an ID3 tag and it doesn’t work anymore… But you are dang sure no files where mixed up 
But it is a waste of processing power if a simple search and replace suffices. Only, suppose a user has audio files in 2-3 locations in their harddrive, that search and replace becomes complex… you still really have to know what you are doing.
Best advise to any user is to put your files in a universal location that won’t easily get changed over time.
1 Like
A CRC is a great approach too. I was thinking within the confines of the current schema 