Sqlite Online Backup Using System.Data.Sqlite

Question

How can a sqlite database be backed up in native C# code while the database is still online? All of the online backup api examples are in C code.

Elias · Accepted Answer · 2015-05-08 17:27:03Z

48

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.

answered May 8, 2015 at 17:27

Elias

1,4271 gold badge12 silver badges25 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Lorenzo Isidori Over a year ago

Your example is right, but I just want to remark that the transactions of both databases must be closed, otherwise you'll get a "unknown error" by sqLite!

Frawsty Over a year ago

I believe the "using" keyword takes care of closing the connections automatically.

Collectives™ on Stack Overflow

Sqlite Online Backup Using System.Data.Sqlite

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related