How to export database structure from Firebird? I'm doing replication and I need to export db structure from one Firebird db (dialect 3) into another. I've seen a couple tools like IBPump and FBExport, however all I can find is how to export all the data and not the structure. Any advice?
There are several ways to do this:


A metadata-only backup using gbak:

gbak -backup -meta_data employee employee.meta.fbk


And then restore that backup.
A metadata-only restore using gbak:

gbak -create employee.fbk mytest.fdb -meta_data


This can be useful if you already have a backup with data.
Exporting the DDL of a database with ISQL (or another tool)

isql -ex -o ddldump.sql /path/to/your/database.fdb


And then use that script to populate a new database.


For options 1 &amp; 2 see gbak: Backup &amp; Restore Recipes: Meta Data Only
For option 3 see ISQL: Command Line Switches.