After a long holdoff, waiting for confirmation that TP10 with SQLite 3 works decently fast, several Months, ago I did a Python program that performed the upgrade rather perfectly. It has some specific features that I needed but it easily could be modified to work in a more general way.
Here is the procedure:
- Scan the files with TP10
- Have the Python program copy the information stored inm the TP7 database to the TP1ß database
The program works something like this:
- attach to both databases
- Identify the files between the two databases
- move over information like keywords, galleries, Annotation etc partly including certain conversion for differences between TP7 and TP10-
- the program features a simple GUI that shows states, problems, etc
- it can be started multiple times with different tasks to be done.
We work daily with TP10 and the upgraded database with no problems at all.
If anybody is interested please send me a note to mschnell at bschnell dot de.
-Michael