Sqlcipher for Windows runtime. update sqlite DB from version 1 to version 2


#1

Hi,

i’am using Sqlcipher for Windows runtime and have to update the database from version 1 to 2. How can i do that? Is there a method that works like the SQLiteDatabase.upgradeDatabaseFormatFromVersion1To2 in the Android version?

best regards
Yimei


#2

Hello @waxwings

As long as you haven’t customized any of the default settings (i.e., kdf_iter, cipher, etc) you can simply key the database and then immediately perform a PRAGMA cipher_migrate. This command is only intended it run a single time, however it will upgrade the database in place to the latest 3.x format. If you have made any customizations, you will need to perform a sqlcipher_export.