U++ forum: Welcome to the forum

How to make a copy not crypted of a Sqlite db [message #60166]

Wed, 20 September 2023 10:14

forlano
Messages: 1205
Registered: March 2006
Location: Italy

Senior Contributor

Hello,

it seems I was able to create and read a crypted db. The trick was just the line

sqliteVT.Open( dbname, password, Upp::Sqlite3Session::CIPHER_CHAHA2020_DEFAULT ))
{...}

Now I would like, once it was opened, to create a copy not crypted for a possible future debug.
I read that this can be done with the VACUUM INTO command.
I tried

  Sql sql(sqliteVT); 
  sql.Execute("VACUUM INTO");

But nothing happen. What am I missing?
Is there a way to get a copy not crypted?

Thanks,
Luigi

[Updated on: Wed, 20 September 2023 10:15]

Report message to a moderator