> At 04:05 PM 18/04/2004 +0000, you wrote:
> >--- In firebird-support@yahoogroups.com, "kfkong" <kfkong@y...> wrote:
> > > 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?
> >
> >ALTER TRIGGER xxx INACTIVE
> >
> >But it would be more practical to build a new blank database, and pump
> >the data from the old one. That way you can monitor what is going on.
>
> But active Before/After Insert triggers would still fire during a pump...
>
> /heLen

Clever Components datapump provides for deactivating triggers for the pump
Alan