SQLite in-memory database backup in .NET

c# .net sqlite system.data.sqlite
Omkar picture Omkar · Feb 3, 2011 · Viewed 19.6k times · Source

How to get the SQLite in-memory data base backed up? I create the database in my Windows application. I want to take a database backup when I will close the application.

Answer

Corbin March picture Corbin March · Feb 3, 2011

You want the SQLite Online Backup API.

As far as I know, System.Data.SQLite does not support it yet, so you'll need to write some code. The System.Data.SQLite Forum contains an example: http://sqlite.phxsoftware.com/forums/t/2403.aspx. As noted, when you patch System.Data.SQLite and call SQLite directly you do so at your own risk.

Related questions

What 'additional configuration' is necessary to reference a .NET 2.0 mixed mode assembly in a .NET 4.0 project?

I have a project in which I'd like to use some of the .NET 4.0 features but a core requirement is that I can use the System.Data.SQLite framework which is compiled against 2.X. I see mention of this being …

Read More
SQLite Database Locked exception

I am getting Database is locked exception from SQLite for some queries only. Below is my code: When I execute any select statement it works fine. When I am executing any write statement on Jobs Table it also works fine. …

Read More
How to Close Sqlite Connection without explicitly calling Close Method using .NET

I am creating desktop application in winform that will use Sqlite Database. So I created Sqlite Helper class that uses System.Data.SQLite and each method of that Helper class opens and closes connection. But now I also added ability …

Read More