Good topic and suggestions, Jill. As a user of SQLite, I would undertake these steps in RM7 on a copy of my database before importing it into RM8.
-
Run my RMGC_Properties – Query which is much more comprehensive than the RM Database Properties display.
-
Run my Delete Phantoms script #3 which is much more comprehensive than the RM Clean Phantom Records tool.
Earlier versions of both of the above are built into my Bundled Utilities – RMtrix application for Windows for ‘easier’ use. None of the above have been updated for TreeShare nor for RM8.
I would use these repeatedly along with other SQLite queries and RM7 operations to find and fix reported problems to the point that I would be comfortable migrating to RM8 but that is not going to happen until RM8 has fulfilled shortcomings and stabilised.