931
General Discussion / moving network database to another server
« on: 2011-05-25 20:42:38 »
> Our question is, what are the steps to take to Install software on new server
> and then access photos where they are currently and then Move Photos to new
> server from within thumbsplus. Then open database in access and change values.
Well, where you install ThumbsPlus doesn't really matter (on the server or separately on clients) - as long as it has access to your database file and to the image files. So, you can just download ThumbsPlus v7 sp2 from [link=http://www.cerious.com/archive.shtml]http://www.cerious.com/archive.shtml[/link] and install it wherever you prefer to have it. Don't forget to enter your registration name and code (TP doesn't support network use in evaluation mode).
The location of your database file (thumbs.td4) is not really important either. If it's a shared database, it should be on the server in a folder that all the users have read/write access to. In ThumbsPlus, you use File | Database | Open Database to select the database file that you want to work with (by default it will open the database that the installer just made, which is not your existing database!). Also, be very sure that you have a backup of your existing database.
Before we go on, you should verify a few settings and change them if necessary:
[*]Options | Preferences | Thumbnails: Automatically Remove Orphans must be Off.
[*]Options | Preferences | Thumbnails: Make Thumbnails Automatically must be Off.[/list]
If nothing has changed yet about the location of the photos, I don't think you will have to do any manual editing of the database. You should just be able to look them up through ThumbsPlus' tree panel (supposedly through My Network Places or a mapped drive letter), and it should show you their existing thumbnails.
If (IF!) that is correct, you can simply lookup the new server in the tree (again through through My Network Places or a mapped drive letter - use the same route that your fellow users will be using) and move the photos there using drag-and-drop or through File | Move.
One thing to keep in mind: If the photo drive in the new server should have the same volume label as the old drive, and you can't change it beforehand, I think you should first turn this setting 'on' to prevent that ThumbsPlus gets these volumes mixed up: Options | Preferences | Disks & Folders | Match network volumes using share names.
Afterwards, when all files have been moved, you may want to perform File | Database | Compact to physically remove the old records of the moved files from the database.
ps: if the old thumbnails do not show when you look up the image files, things get more complicated because something (e.g. share name, volume label, folder structure) must have changed between when it still worked and today. If the cause is not the folder structure, what you can do is to create a new database, lookup the image files and make a thumbnail for just one of the images (by selecting it and pressing F3). Then open that database in MS Access, go to the table named 'Volume' and make a note of all the field values for that volume. Then open your existing database in Access, again go to the Volume table, lookup the volume on which the images used to reside and update its values manually (with those of the new volume, where they are now). After that, when you open the DB in ThumbsPlus, it should recognize the image files again and show the existing thumbnails,so you can move them elsewhere.
Well, I hope this explanation is not too fuzzy.. it's a complicated subject. If you think something is not quite right, please let me know and provide as many details as possible.
> and then access photos where they are currently and then Move Photos to new
> server from within thumbsplus. Then open database in access and change values.
Well, where you install ThumbsPlus doesn't really matter (on the server or separately on clients) - as long as it has access to your database file and to the image files. So, you can just download ThumbsPlus v7 sp2 from [link=http://www.cerious.com/archive.shtml]http://www.cerious.com/archive.shtml[/link] and install it wherever you prefer to have it. Don't forget to enter your registration name and code (TP doesn't support network use in evaluation mode).
The location of your database file (thumbs.td4) is not really important either. If it's a shared database, it should be on the server in a folder that all the users have read/write access to. In ThumbsPlus, you use File | Database | Open Database to select the database file that you want to work with (by default it will open the database that the installer just made, which is not your existing database!). Also, be very sure that you have a backup of your existing database.
Before we go on, you should verify a few settings and change them if necessary:
[*]Options | Preferences | Thumbnails: Automatically Remove Orphans must be Off.
[*]Options | Preferences | Thumbnails: Make Thumbnails Automatically must be Off.[/list]
If nothing has changed yet about the location of the photos, I don't think you will have to do any manual editing of the database. You should just be able to look them up through ThumbsPlus' tree panel (supposedly through My Network Places or a mapped drive letter), and it should show you their existing thumbnails.
If (IF!) that is correct, you can simply lookup the new server in the tree (again through through My Network Places or a mapped drive letter - use the same route that your fellow users will be using) and move the photos there using drag-and-drop or through File | Move.
One thing to keep in mind: If the photo drive in the new server should have the same volume label as the old drive, and you can't change it beforehand, I think you should first turn this setting 'on' to prevent that ThumbsPlus gets these volumes mixed up: Options | Preferences | Disks & Folders | Match network volumes using share names.
Afterwards, when all files have been moved, you may want to perform File | Database | Compact to physically remove the old records of the moved files from the database.
ps: if the old thumbnails do not show when you look up the image files, things get more complicated because something (e.g. share name, volume label, folder structure) must have changed between when it still worked and today. If the cause is not the folder structure, what you can do is to create a new database, lookup the image files and make a thumbnail for just one of the images (by selecting it and pressing F3). Then open that database in MS Access, go to the table named 'Volume' and make a note of all the field values for that volume. Then open your existing database in Access, again go to the Volume table, lookup the volume on which the images used to reside and update its values manually (with those of the new volume, where they are now). After that, when you open the DB in ThumbsPlus, it should recognize the image files again and show the existing thumbnails,so you can move them elsewhere.
Well, I hope this explanation is not too fuzzy.. it's a complicated subject. If you think something is not quite right, please let me know and provide as many details as possible.