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, Nov 19 '16 at 10:14
@botond.botos hi Actually I am facing the problem is, please look this url : http://stackoverflow.com/questions/40689467/where-to-store-my-windows-applications-data . Then I thought create a default path when install my application on any local computer while creating setup file in wpf c# — lashja, Nov 19 '16 at 10:20
There's a different approach described at http://stackoverflow.com/questions/15292880/create-sqlite-database-and-table. Instead of copying a database file it creates it on the fly. — Botond Botos, Nov 19 '16 at 10:38

Paviel Kraskoŭski · Accepted Answer · 2016-11-19T09:56:26.560

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 '16 at 09:56

answered Nov 19 '16 at 09:28

Paviel Kraskoŭski

1,429
9
16

Hi. This is my Database-- string fileName = "test.s3db"; – lashja Nov 19 '16 at 09:45
1

@AbhilashJA So you should replace `YourDatabase.db` with `test.s3db`. – Paviel Kraskoŭski Nov 19 '16 at 09:47
How can I locate these two path ? string sourcePath = @"E:\File\DMS\DAL\Model"; string targetPath = @"C:\ProgramData\CompanyName\appName"; By using this code? – lashja Nov 19 '16 at 09:51
1

What are the benefits of using `SQLiteConnection.BackupDatabase(...)` over simple file copy? – Botond Botos Nov 19 '16 at 10:06
1

@botond.botos Maybe that you don't have to write file copy code? – Paviel Kraskoŭski Nov 19 '16 at 10:08
1

@PaviełKraskoŭski, I was asking because copying a file doesn't take more lines of code than creating a backup with `SQLiteConnection` API. – Botond Botos Nov 19 '16 at 10:17
1

@botond.botos Maybe backup file has some additional information and somehow differs from a simple copy? – Paviel Kraskoŭski Nov 19 '16 at 10:22
1

@PaviełKraskoŭski, that's what I was hoping you can explain when I asked about the added benefits. – Botond Botos Nov 19 '16 at 10:24
1

@botond.botos Unfortunately, I can't. – Paviel Kraskoŭski Nov 19 '16 at 10:25
@PaviełKraskoŭski How can I assign this static void to sqliteconnection object? dbConnection = BackupDatabase(); – lashja Nov 19 '16 at 10:42
1

@AbhilashJA This method just makes a copy of a database. You can create new `dbConnection` right after this method: `BackupDatabase(); dbConnection = new SQLiteConnection(String.Format("Data Source = {0}", destFile));` – Paviel Kraskoŭski Nov 19 '16 at 13:15

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

1 Answers1