> I wish i could backup a database so that some tables (precomputed
> data) get backed up empty to save disk space.
>
> Only way I can do it now is
> 1) backup database
> 2) restore the backup to a temporary database
> 3) connect to temp database and delete the computed info
> 4) backup again
>
> Can anyone suggest a faster/simpler procedure?

with ibexpert you can create a metadata extract config file
that also includes the data from your database, but you must
not select all table for data.

The resulting Script File can be used to create a new
database with all the selected tables data (also possible
for blobs).

this configuration can be stored as a metadata extract
config file and used with the command line tool
ibeextract. the resulting script file can be executed
with command line tool ibescript.exe to create a new
database.

with this configuration you can replace your current
backup/restore process with a subset of your data
as you need.

Best Regards

Holger Klemt

IBExpert Power Workshop in Oldenburg, 199 Euro p.P. 07.-08. April 2005

The most Expert for InterBase and Firebird --- www.ibexpert.com
HK Software - Gerhard Stalling Str 47a - 26135 Oldenburg - Germany
Phone/Fax +49 700 IBEXPERT (42397378) www.h-k.de
Training and Support for Delphi, InterBase, Firebird, AS/400