For our purpose, which is to edit the volume_table, we don't need much knowledge of sql queries, just to edit the right fields of the right volume_table records.
I assume we are in the right conditions:
- the media files folder tree registered in the catalog has been moved to a new empty drive (no files of the destination drive already present in the catalog before the move). - - The old drive reference in Windows will disappear completely and be replaced by the new references (drive letter and serial).
- There will not be different items in the volume_table referring to the same letter drive or same serial number.
- You have used the Windows commands to find the serials and to translate them from hexadecimal to decimal.
If you look at the media_table, you'll see that all your media refer to the volume_id, the one assigned by the database given when the first item has been recorded in the database. Now, all the media in the old drive are no longer pointing to that volume, but to a new one. The reconnect function works first to find the new location, and when found, it replaces the old volume_id with the new one. In our case, the first thought for a sql language user is to issue a query to replace all serial and letter old references with the new references. That can be a replacement of hundred of thousands of edited records.
As a matter of fact, the intelligent database structure with the volume_table makes it much easier and faster. We are cheating by keeping the old assigned volume_id and we change its Windows references, serial and letter (also the description and type, but that's not so crucial).
In practice, once you have opened your catalog, you select the volume_table on the left, and on the right of the volume_table line, you click on the 2nd icon to 'edit...'
There you can edit directly the record of the old volume_id for the description, serial and letter drive.
Thank you for your help. Finally last night I did a search for missing files in Organizer and got zero:-)
One problem I did find was that using older software and an only adequate pc caused a problem in transferring images from one drive to another; I knew it would be an overnight run so I left it running. (My wife wondered what the glow was, coming from our study; she informed when she came to bed that there is a screen message that says something bad has happened!) Fortunately I had a backup that held the data to correct the situation.