DB Extract for InterBase/Firebird is a software tool designed to create backups of InterBase and Firebird databases in the form of SQL scripts. It allows users to extract both the metadata of all database objects and the data from tables, generating scripts that can be used for database restoration or migration. The tool offers a graphical wizard for step-by-step extraction as well as a command-line utility for automated or scheduled backups. Extraction can be customized to include specific objects, tables, and data, with options for constraints, character sets, and script compression. The solution supports Unicode data, SSH tunneling, and saving extraction configurations for reuse, making it suitable for both manual and automated backup workflows.

Key Features

User-friendly wizard interface Guides users through the extraction process with clear steps.

• Step-by-step graphical interface
• Visual selection of databases, objects, and options

Flexible object and data selection Customize what to extract from databases.

• Select specific database objects and tables
• Define constraints for extracted table data

Script generation and ordering Ensures correct restoration order and compatibility.

• Generates SQL scripts with INSERT statements for data
• Orders object extraction based on dependencies

Command-line utility Enables automation and integration with scripts.

• Run extraction via command line using configuration files
• Supports scheduled and unattended backups

Advanced extraction options Control output format and storage.

• Compress result scripts and split into volumes
• Choose output charset and encoding

Configuration management Reuse and share extraction settings.

• Save and load extraction parameters as configuration files

SSH tunneling support Securely connect to remote databases.

• Access databases through SSH tunnels for secure extraction

Benefits

Reliable database backups Protects data integrity and simplifies restoration.

• Full metadata and data extraction for complete backups
• Scripts can be used for migration or disaster recovery

Automation and efficiency Reduces manual effort and risk of errors.

• Command-line tool for scheduled or automated backups
• Reusable configuration files for consistent processes

Customizable extraction Fits various backup and migration needs.

• Extract only the needed objects/tables
• Supports constraints and table clearing before data insertion