RootsMagic 7 was released on 25 Nov 2014. It will take some time to answer the following questions:
  1. Which SQLite scripts on this wiki need to be revised? Identifying changes in the database design will trigger areas to investigate.
  2. Which ones can be retired? Requires comparing the functional capabilities of RootsMagic 7 to those of the relevant scripts.
  3. Are there new exploits needed? Depends on user feedback in various forums.
Your help in this process is needed; the size of this wiki is too much to expect one person to handle in a timely fashion.

SQLiteToolsForRootsMagic Blazes Trails

Some of the new features of RootsMagic 7 were conceived and/or pioneered on this wiki. Only the RootsMagician can say what influence it has had on product development. Some examples:
New Feature
Wiki Page
Wiki Date
Compare Files
Comparing Two RM Databases
2011-12
Import Lists
Depopulate but keep Customs, Places, Sources
Database - Copy Master Lists to Shell
2011-12
2014-10
Backup and Restore with Media
Backup Media with Database - RAR
Backup Media with Database - 7Zip
2011-02
2011-03
Quick Groups
Named Group - Mark or Unmark List refresh
2011-11



Okay, a couple of those might be a bit of a stretch...

Database Structure Unchanged from RM6

There have been no changes to the SQLite database structure between RootsMagic 6 and 7. The database version stored in the ConfigTable remains at "6000". Results (or absence thereof) from the following queries (run individually) support these observations. The main database was an empty one created by RootsMagic 6; the attached one was an empty one created by RootsMagic 7.
SELECT * FROM main.sqlite_master OLD
LEFT JOIN EmptyRM7000.sqlite_master NEW USING(name)
WHERE OLD.SQL NOT LIKE NEW.SQL
ORDER BY name;
 
SELECT * FROM main.sqlite_master OLD
LEFT JOIN main.sqlite_master NEW USING(name)
WHERE OLD.SQL NOT LIKE NEW.SQL
ORDER BY name;
 
SELECT CAST(DataRec AS TEXT) FROM EmptyRM7000.ConfigTable
;
That is not to suggest that one can work on the same database with both versions with impunity. There will have been changes in how fields are used, perhaps the meanings of some values, giving rise to possible problems. However, the RootsMagician says in a private email on 26 Nov: "Yes. You should be able to switch back and forth between 6 and 7."