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
