I use linux and OSX, on both I have the command line utility for sqlite3
, I’m sure windows probably has something. I created a bash
script that allows me to pass in numerous manager databases and it pulls out the schema version.
The command line is simply:
sqlite3 "$file" "select hex(Content) from Objects Where Key = 'a9a71e47-82b3-49db-8aec-898adb460a80'"
where $file
is the filename you want to inspect. If you have special characters in the name (like spaces and or parenthesis) make sure to enclose it in double quotes to avoid errors.
I am not sure if the UUID is the same for everyone, I assume it is, but it it’s not, it’s not too hard to find.
The query will result in 6 hex characters on the display, it appears to me as 08F201
. You will find the middle byte (F2
) is the schema version (0xF2 = 242
) which is the current version I am running on in 20951