Sqlite Online Backup Using System.Data.Sqlite Sqlite Online Backup Using System.Data.Sqlite sqlite sqlite

Sqlite Online Backup Using System.Data.Sqlite


The online backup API was added to System.Data.Sqlite in version 1.0.80.0 - April 1, 2012. You can create a database backup while there are other external connections like so

using(var source = new SQLiteConnection("Data Source=ActiveDb.db; Version=3;"))using(var destination = new SQLiteConnection("Data Source=BackupDb.db; Version=3;")){    source.Open();    destination.Open();    source.BackupDatabase(destination, "main", "main", -1, null, 0);}

Also, BackupDb.db will be created if it doesn't already exist.