It seems that there is not a way to do a complete backup of Firebird
via SQL statements... I love Firebird but I do miss that feature of
Postgres.

Hmm.. I think I smell a project for me.. ;)

> cowmix3 wrote:
> > Is there any way to get FBEXPORT to export an entire database?
>
> You could call it on a table-by-table basis.
>
> I guess you need to move data to some other site and upload there? You
> could do a backup, take it to the other site, restore and then use
> FBCopy to pump into destination database.
>
> >>>Practically I have to extract data from customer db and insert into
> >>>new db,if it is so, can anyone give some idea how to do data extract
> >>>in a better way.
>
> For this: send empty metadata-only backup to customer, restore it
> there and use FBCopy to pump customer's data in new database. I do
> this often (it's one of the reasons why FBCopy is created).
>
> To create metadata-only backup, you can use gbak with -m option.
>
> HTH
> --
> Milan Babuskov
> http://fbexport.sourceforge.net
> http://www.flamerobin.org