Hi Daan,
As, since the newsgroups have been canceled, you are the only senior expert, who answers questions to dummies, I need to bother you :(.
We (
www.bschnell.de) are long time rather happy professional users of TP 7 (on a multi-user license).
I fear that in a time frame of some months, our main *.tp4 "Access" database file will reach the 2 GB limit.
My plan has been, to first migrate to the newest TP release and after that migrate to a Postgres database engine (as same has been recommended over MySQL).
I already successfully installed and tested (not with TP) Postgres on my (Linux-) server to prepare the migration.
But of course I first need to thoroughly test TP 9 on our data in the daily work (managing photos in a thousand directories and some hundred hierarchical "galleries", using keywords and annotations, heavily making use of the complex search functionality, ...) , and creating web galleries for our customers - see the website mentioned above). Unfortunately the "tp4 conversion" function of TP 9 does not work for me. So I am stuck. (In fact I am rather eager to use the Python scripting ability of TP9 to create some rather complex automatic jobs, once TP9 really works for us.)
Do you think it would make sense to first migrate the database to Postgres and stick with TP4 ? As I never really used server based databases, I am a bit reluctant with this step (e. g I need to make sure that the automatic backup - using dirvish - )works perfectly).
Please come back here o by mil to mschnell @ (the domain mentioned above).
Thanks a lot,
-Michael