Please take this to another thread!
> On 16 May 2016, at 23:16, Objective C <developpeurcsharp at gmail.com> wrote:
>
> Thank you for your answer,
> here is the code i used to backup my SQLite database :
>
> var source = new SQLiteConnection("Data Source = MyDB.db ; Version = 3;");
> var destination = new SQLiteConnection("Data Source = NewDBBackup.db;
> Version = 3;");
>
> source.Open();
> destination.Open();
>
> source.BackupDatabase(destination , "main", "main" , -1 , null , 0 );
> source.Close();
>
> 2016-05-16 22:05 GMT+00:00 Kees Nuyt <k.nuyt at zonnet.nl>:
>
>> On Mon, 16 May 2016 19:14:01 +0000, Objective C
>> <developpeurcsharp at gmail.com> wrote:
>>
>>> Hi sir,
>>> In fact, i have an issue with SQLite database Restore using c#
>>
>> That's not what this discussion thread is about, it would have
>> been better if you sterted a new thread, but anyway.
>>
>>> i'm coding a button which can restore an existing
>>> SQLite database with '*.db*' extension.
>>
>>> i wonder if you can guide me please,
>>
>> Can you describe what you already tried, what happened, and what
>> made you think you didn't succeed?
>>
>> There are (at least) two methods:
>> 1- use the SQLite backup API
>> See: www.sqlite.org/c3ref/backup_finish.html
>>
>> 2- copy the backup database over the database
>> using file system operations
>>
>> In the latter case you'll have to make sure
>> - the backup database is consistent and does not
>> have a 'hot' journal
>> - the database you are going to overwrite is not
>> used by any databse connection
>> - the journal of the database you are overwriting
>> (if any) is removed.
>>
>>> i'll ber very grateful
>>> Sincerely yours
>>> Hashim
>>
>> --
>> Regards,
>>
>> Kees Nuyt
>>
>> _______________________________________________
>> sqlite-users mailing list
>> sqlite-users at mailinglists.sqlite.org
>> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
>>
> _______________________________________________
> sqlite-users mailing list
> sqlite-users at mailinglists.sqlite.org
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
