forum

Home / DeveloperSection / Forums / Sqlite Database Backup

Sqlite Database Backup

Ajay Kembale 2116 12-Jan-2016
I want to take backup of sqlite database in windows application(Visual Studio 2012).I am able to do it using Sqlite in mozila firefox addon manually.
But I want to implement it on a button click in windows form.I was trying following  code which errormessage 'BackupDatabase() does not exists in System.Data.SQLite.SQLiteConnection

I was looking for query in Sqlite but I couldnt find anything

public void takebackup()
        {
            da = new SQLiteDataAdapter();
            //con.Open();
            try
            {
                SQLiteConnection cnnIn = new SQLiteConnection('Data Source=test.db;foreign keys=True');
                SQLiteConnection cnnOut = new SQLiteConnection('Data Source=backup.db;foreign keys=True');
                cnnIn.Open();
                cnnOut.Open();
                cnnIn.BackupDatabase(cnnOut, 'main', 'main', -1, null, -1);
                cnnIn.Close();
                cnnOut.Close();
            }
            catch (Exception er)
            {
            }
            finally
            {
                //con.Close();
            }
        }

Updated on 13-Jan-2016

Can you answer this question?


Answer

1 Answers

Liked By