[yunqa.de] Re: Syntax to dump db (schema and / or data) via DISQLite?
- From: Delphi Inspiration <delphi@xxxxxxxx>
- To: yunqa@xxxxxxxxxxxxx
- Date: Fri, 30 Nov 2012 19:31:40 +0100
On 30.11.2012 17:24, H M wrote:
> As part of an automatic application upgrade system via the web I may
> need to upgrade the user's SQLite database as well by changing views or
> adding/modifying tables and I'd like to back up the database first and
> restore their data afterwards.
Use the Online Backup API, described here:
DISQLite3.chm -> SQLite3 Documentation -> Online Backup
An example project is available here:
DISQLite3_Install\Demos\DISQLite3_Backup
> I know the sql to do the modification of tables but how do I issue a
> dump command (and a restore command) via DISqlite?
>
> Indeed, how do I use any other of the useful commands in the sqlite API
> when I'm using DISQLite specifically so I don't need to bother with
> distributing or messing around with the api.
The Online Backup API is the API of choice.
Ralf
_______________________________________________
Delphi Inspiration mailing list
yunqa@xxxxxxxxxxxxx
//www.freelists.org/list/yunqa
Other related posts:
