Question
Gbak vs nBackup: Which minimizes downtime for a small Firebird app migration?
Rahul Sage
0 reputation · 23 Jan 2023, 05:45 UTC
59.8K views0
Goal
To move a lightweight Firebird application to a new server while keeping the database online for as long as possible.
Constraints
- Final cut‑over must be brief enough that users experience no service interruption.
- Backup method should preserve all schema and data without requiring extensive post‑restore processing.
- Version compatibility between source and target Firebird installations must be maintained.
Unresolved Decision
Should the migration use the logical Gbak tool, which offers portability but requires a full restore, or the physical nBackup tool, which restores faster but may be affected by OS differences and incremental windows?
Specific Questions
- What is the typical downtime window when restoring a 10‑GB database with
GbakversusnBackupon the same Firebird version? - Can
nBackupincremental backups effectively reduce the final cut‑over period for a small database, and if so, by how much? - What ODS or version mismatches should be anticipated when restoring an
nBackupimage from a 3.0 source to a 4.0 target, and how do they impact downtime?