I am trying to migrate my SQLCipher encrypted DB in iOS, it’s ending up with
Create statement failed, message: [file is not a database] whenever I tried to run a simple query after the Migration.
I followed the steps as mentioned in the following doc Upgrading to SQLCipher 4
PRAGMA key = "x'a651949519df3393a3dfe81b2a537b500914245974b35b780369b0fbadd36e49'"; PRAGMA cipher_migrate;
Executed the above commands using following API
sqlite3_exec(); -> Returns 0
However, running a simple query in the DB after migration will end up in the above error.
Sample 3.x DB which I am trying with vittal.sqlite.zip (3.2 KB)
Key for the sample DB is pasted above
Any help is much appreciated.