FireDAC.Phys.ASA.TFDASABackup
Delphi
TFDASABackup = class (TFDASAService)
C++
class PASCALIMPLEMENTATION TFDASABackup : public TFDASAService
Contents
Properties
| Type | Visibility | Source | Unit | Parent |
|---|---|---|---|---|
| class | public | FireDAC.Phys.ASA.pas FireDAC.Phys.ASA.hpp |
FireDAC.Phys.ASA | FireDAC.Phys.ASA |
Description
Adds database backup capability to an application.
Use the TFDASABackup component to add backup database capability to an application. This is a programmatic method to invoke the dbbackup tool as a thread in the DB server process.
To produce a DB backup, an application should do the following:
- Specify DriverLink.
- Specify ConnectParams.
- Specify OutputDir.
- Call the Backup method.
Other properties and methods are optional.
Using the TFDASABackup component on a running database is equivalent to copying the database files when the database is not running. You can use the Backup utility to back up the database while other applications or users are using it.
To communicate with a user or an application, the SQL Anywhere DB tool is using the OnProgress event. To ask for confirmation, the event will be fired with AKind = tmConfirm. The OnProgress event can also be used to produce a DB backup log.
Example
FDASABackup1.DriverLink := FDPhysASADriverLink1;
FDASABackup1.ConnectParams := 'ENG=addemo_asa11;DBN=addemo_asa11;UID=DBA;PWD=sql';
FDASABackup1.OutputDir := 'c:\temp\db';
FDASABackup1.Flags := [bfBackupDB, bfBackupLog];
FDASABackup1.OnProgress := FDASABackup1Progress;
FDASABackup1.Backup;