Subject Disable / Enable Triggers
Author t.s.
Dear all,

The following list contains the steps necessary when upgrading a
production database:
1. backup old database.
2. export old generator values.
3. export old data (as INSERT statements).
4. create new empty database (with triggers, views, sp, etc).
(or provide a fresh, empty copy of the new FDB)
5. import old generator values.
6. import old data.
7. finished.

In a database with larger data and complex trigger processing, step#6 is
taking a lot of time since the triggers are already active at that point.

Is there a way to disable all triggers before doing step#6 ?
(and of course, re-enabling them afterwards).

Thanks in advance,

PS: Or, if anyone has a simpler/better/faster idea on how to 'upgrade a
production database', i'm all ears. Thanks.