Backup SQLite database with VB.Net

Question

I don't find documentation for VB.NET

Trying to adapt the code of the answer on Sqlite Online Backup Using System.Data.Sqlite

The code from @Elias is:

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);
}

and my code looks like:

Dim conn = New SQLiteConnection("Data Source=MyBase.sqlite;Version=3;Password=myPassword;foreign keys=true")

Dim connbackup = New SQLiteConnection("Data Source=MyBaseBackup.sqlite; Version=3;Password=myPassword;foreign keys=true")

    Try
        Using (conn)

            conn.Open()
            connbackup.Open()

            conn.BackupDatabase(connbackup, "main", "main", -1, null, 0)

        End Using

    Catch ex As Exception
        MsgBox(ex.ToString())
    End Try

Visual Studio marks on red "Null" is not declared and I don´t have any clue about how to solve the error. I think is the "callback" what is wrong

In VB null is Nothing. Also, connections are one of those things that should be disposed of when you are done with it. That is why the c# version has both wrapped in Using / using blocks — Ňɏssa Pøngjǣrdenlarp
– Ňɏssa Pøngjǣrdenlarp, Commented Sep 20, 2016 at 23:09
@Plutonix thanks, I posted the working solution with double Try - Using blocks — fedeteka
– fedeteka, Commented Sep 21, 2016 at 10:20

Ňɏssa Pøngjǣrdenlarp · Accepted Answer · 2016-09-21 12:40:17Z

1

Here is the direct translation of that C# code:

Using source As New SQLiteConnection("Data Source=ActiveDb.db; Version=3;"),
      destination As New SQLiteConnection("Data Source=BackupDb.db; Version=3;")
    source.Open()
    destination.Open()
    source.BackupDatabase(destination, "main", "main", -1, Nothing, 0)
End Using

edited Sep 21, 2016 at 12:40

Ňɏssa Pøngjǣrdenlarp

39k12 gold badges65 silver badges193 bronze badges

answered Sep 21, 2016 at 1:30

jmcilhinney

54.9k5 gold badges30 silver badges52 bronze badges

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

4 Comments

fedeteka Over a year ago

thanks but didn't work. Something wrong with the sintaxis. I will post the solution.

Ňɏssa Pøngjǣrdenlarp Over a year ago

@fedeteka the only thing wrong is an extra trailing parens (edit: was wrong)

fedeteka Over a year ago

@Plutonix. Right, thanks. Also I think Version=3;" works the same as Version=3" without the last semicolon

Ňɏssa Pøngjǣrdenlarp Over a year ago

there are a number of other cool things you can add to the connection string, so it can be a good idea to leave the trailing delimiter

Collectives™ on Stack Overflow

Backup SQLite database with VB.Net

1 Answer 1

4 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related