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.
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);
}
}
The VACUUM INTO command introduced in SQLite version 3.27.0 (2019-02-07) can serve as an alternative. In addition to the backup it rebuilds the database file, repacking it into a minimal amount of disk space.
public void backup(string strDestination)
{
using (var location = new SQLiteConnection(@"Data Source=C:\activeDb.db; Version=3;"))
{
SQLiteCommand sqlCmd = location.CreateCommand();
sqlCmd.CommandText = $"VACUUM INTO '{strDestination}'";
sqlCmd.ExecuteNonQuery();
}
}
try this
using (var destination = new System.Data.SQLite.SQLiteConnection(string.Format("Data Source={0}\\DriversTrucksBackup.db; Version=3;", this.txtLocation.Text)))
{
da.cn.Open();
destination.Open();
da.cn.BackupDatabase(destination, "main", "main", -1, null, 0);
da.cn.Close();
}
System.Data.SQLite 1.0.74.0 is quite outdated. For the backup API support, at least version 1.0.80.0 would be required, but you could just as well upgrade to a current version.
