in

System.Data.SQLite

An open source ADO.NET provider for the SQLite database engine
All Tags » backup (RSS)

Browse by Tags

  • Using the Backup API

    If you're here, you've realized that System.Data.SQLite does not support the SQLite Online Backup API . If you absolutely can't wait until it is supported, I've found a solution. If you want to copy a .db3 file to another .db3 file, you should either use the copy file API of your operating...
    Posted to How To (Forum) by abrakjamson on 06-10-2010
  • Deployment and Backup Questions

    I have searched through the forums and have not found how to do these two things. That is a reflection on me not the forums. 1. I currently have the connection string hard-coded. This is a Windows app and not a web app. I want to be able to do something like |DataDirectory| in ASP in that I would like...
    Posted to How To (Forum) by rkulp on 10-27-2008
  • Re: Question: How to backup large (>500MB) SQLite databases?

    [quote user="liron"]the entire discussion here was around the problem of holding such a lock for the time it takes to copy large SQLite database files[/quote] Shadow copies take just a few seconds (10 to 15 seconds) to complete. Shadow copies are not real copies, they just expose a point in...
    Posted to How To (Forum) by SqlRanger on 09-23-2008
  • Re: Question: How to backup large (>500MB) SQLite databases?

    Recently, I have been playing with Volume Shadow Copy Service and now I wonder whether VSS could be used to perform online backups of SQLite databases. I have found the following blog post: http://blogs.msdn.com/adioltean/archive/2005/01/05/346793.aspx Which shows you how to copy an opened file using...
    Posted to How To (Forum) by SqlRanger on 09-22-2008
Page 1 of 1 (4 items)
Powered by Community Server (Commercial Edition), by Telligent Systems