unordained wrote:

>> I'd like to keep track of schema version. Is it possible to detect
>> schema changes, for example with triggers?

>
> Yes, you can; at the very least it worked for me for tracking changes to
> procedures and triggers in fb 2.1. However, as I discovered when I did this,
> triggers on system tables get dropped, silently, and you'll sometime later
> discover that you're no longer tracking changes. Oops! (I think we decided it was
> gbak backup/restore doing it, not nbackup backups?)

Right. nbackup is a physical backup - just the bytes, ma'am - and
gbak is a logical backup that deals in table definitions and records.
Gbak has a built-in model of the system tables - not necessary, but
convenient when it was written. That model ignores changes made to
the system tables and recreates them in their original state.

Cheers,

Ann