> I am trying to upgrade my existing Firebird db. However due
> to some tables modification and update statement may fire my
> triggers which will end up disturbing or even corrupting my
> existing data on another table. Is there a way that I can
> switch all triggers off during my FB DB upgrade?

Take a look at: http://www.telesiscomputing.com.au/dbk.htm

The backup process that this uses builds a copy of the database
using DDL and data transfer. Because it allows the process to
be performed in stages it can be used to achieve the sort of
upgrade that you want. (eg: Run initial and final phases from
the upgraded database, run the data transfer stage from the
original database.)

--
Geoff Worboys
Telesis Computing