How to take Sqlite database backup using C# or Sqlite query

Question

Memory Stream as DB

I have used code on this link which gave me errormessage that

BackupDatabase() does not exists in System.Data.Sqlite.SqliteConnection

Is there any Sqlite query to backup or export Sqlite database. And then restore it again

I want to export database on one system and then import it in another system for same windows application installed on both systems. I want to implement this activities on button click.

Answer 1

backup database link in Sqlite link try this function

public void backup(string strDestination)
{
      using (var location = new SQLiteConnection(@"Data Source=C:\activeDb.db; Version=3;"))
      using (var destination = new SQLiteConnection(string.Format(@"Data Source={0}:\backupDb.db; Version=3;", strDestination)))
      {
          location.Open();
          destination.Open();
          location.BackupDatabase(destination, "main", "main", -1, null, 0);
      }
}