C# - How to copy SQLite db from one path and paste it to another path?

Question

Using below code, how can I set the code in SQLiteConnetion object ?

public SQLiteConnection dbConnection = new SQLiteConnection();

string fileName = "test.s3db";
        string sourcePath = @"E:\File\DMS\DAL\Model";
        string targetPath = @"C:\ProgramData\CompanyName\appName";
        string sourceFile = System.IO.Path.Combine(sourcePath, fileName);
        string destFile = System.IO.Path.Combine(targetPath, fileName);
        if (!System.IO.Directory.Exists(targetPath))
        {
            System.IO.Directory.CreateDirectory(targetPath);

        }
        System.IO.File.Copy(sourceFile, destFile, true);
        if (System.IO.Directory.Exists(sourcePath))
        {
            string[] files = System.IO.Directory.GetFiles(sourcePath);
        }

I want to automatically create a DB path if the path does not exist.

dbConnection = ??

Could you clarify what do you mean by "how can I set the code in SQLiteConnetion object"? Your code seems to be correct. Could you provide a code snippet on what is not working? — Botond Botos
– Botond Botos, Commented Nov 19, 2016 at 10:14
@botond.botos hi Actually I am facing the problem is, please look this url : stackoverflow.com/questions/40689467/… . Then I thought create a default path when install my application on any local computer while creating setup file in wpf c# — lashja
– lashja, Commented Nov 19, 2016 at 10:20
There's a different approach described at stackoverflow.com/questions/15292880/…. Instead of copying a database file it creates it on the fly. — Botond Botos
– Botond Botos, Commented Nov 19, 2016 at 10:38

Paviel Kraskoŭski · Accepted Answer · 2016-11-19 09:56:26Z

2

I have this method to copy database:

public static void BackupDatabase(string sourceFile, string destFile)
{
    using (SQLiteConnection source = new SQLiteConnection(String.Format("Data Source = {0}", sourceFile)))
    using (SQLiteConnection destination = new SQLiteConnection(String.Format("Data Source = {0}", destFile)))
    {
        source.Open();
        destination.Open();
        source.BackupDatabase(destination, "main", "main", -1, null, -1);
    }
}

edited Nov 19, 2016 at 9:56

answered Nov 19, 2016 at 9:28

Paviel Kraskoŭski

1,4299 silver badges16 bronze badges

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

11 Comments

Paviel Kraskoŭski Over a year ago

@AbhilashJA So you should replace YourDatabase.db with test.s3db.

Botond Botos Over a year ago

What are the benefits of using SQLiteConnection.BackupDatabase(...) over simple file copy?

Paviel Kraskoŭski Over a year ago

@botond.botos Maybe that you don't have to write file copy code?

Botond Botos Over a year ago

@PaviełKraskoŭski, I was asking because copying a file doesn't take more lines of code than creating a backup with SQLiteConnection API.

Paviel Kraskoŭski Over a year ago

@botond.botos Maybe backup file has some additional information and somehow differs from a simple copy?

|

Collectives™ on Stack Overflow

C# - How to copy SQLite db from one path and paste it to another path?

1 Answer 1

11 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

11 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related