Firebird backup/restore (gbak/nbackup)

[Marius2]

Hello,

We recently purchased UniDac and we need to provide a backup/restore option for (at least) Firebird but I cannot find any backup/resore components in UniDac. We did notice the TIBCBackupService for gbak/nbackup in IB-DAC component. I suppose we need to purchase IbDac for this (which is kind of BS as we expected that to be available in UniDac as well), but voila, what is the recommended implementation here? Can we for instance mix UniDac/IbDac sources and connections?

Please advise, regards,
Marius

[pmoegenb]

Hello,

Example of object Pascal:

BackUp
ShellExecute(0, 'open',
PChar('\gbak.exe'),
PChar('-v -t -user SYSDBA -password masterkey '+'Source.fdb'
+' '+'Target.fbk'),
nil, SW_SHOW)

Restore
ShellExecute(0, 'open',
PChar('\gbak.exe'),
PChar('-rep -v -user SYSDBA -password masterkey '+'Source.fbk'
+' '+'Target.fdb'),
nil, SW_SHOW)

[Marius2]

Thanks,

But that is not our intention as we need to validate that the backup has run correctly, zip and secure the backup as well (or move it through the network to make it available for offline backup). We have integrated email as well so if things go wrong (disk space, zip errors, password errors etc). Currently we have special windows services to create backups and other firebird specific stuff like recalculating index statistics.

The TIbcBackupService + restore is exactly what we need, but does it play well with UniDac?

[Marius2]

Solved, working nicely in a seperate windows service (integrated with our app).

[ViktorV]

Glad to see that the issue was resolved.
UniDAC and IBDAC are different sets of components, so you can't mix UniDAC/IBDC sources and connections.
UniDAC is a universal set of components that provides a transparent server-independent interface for working with different databases. Some of the IBDAC properties and methods that use specific functionality of the DBMS (in this case, database backup/restore) are not implemented in UniDAC.

[Marius2]

Hello Viktor,

The only three components we need/use are the TADIBBackup, TADIBRestore and TADPhysIBDriverLin. (its kind of a waste of the money on the rest of IB-DAC components as we are never going to use them).

[ViktorV]

IBDAC is a single set of components, that are not distributed separately.
Feel free to contact us if you have any further questions about IBDAC.