Migrating to new SQLite version
(1) By tscha70 on 2021-10-28 15:04:09 [source]
Our existing database is password protected and encrypted with RC4.
The newer versions of SQLite do not support RC4 and ChangePassword was also removed.
If I update my software-project with the latest version of SQLite, how would I be able to open an existing database with RC4 encryption?
A) not at all
B) by removing the encryption through a magic spell
C) by running two SQLite versions in parallel, one removing the password
D) ...
Can anybody help me?
(2) By Simon Slavin (slavin) on 2021-10-28 23:05:09 in reply to 1 [link] [source]
I recommend that right now, not even waiting for a date for updating to a newer SQLite, you use your existing version of SQLite to open the encrypted database and dump it as the set of SQLite commands needed to reconstruct the database. This is easiest done using the .dump command in the SQLite command line shell.
You will probably use that file to get your data into the newer version of SQLite.
Since you felt it worth encrypting the original database you might want to encrypt the dump file, perhaps as an encrypted .zip file.