Subject | Disable / Enable Triggers |
---|---|
Author | t.s. |
Post date | 2006-08-19T21:18:08Z |
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,
t.s.
PS: Or, if anyone has a simpler/better/faster idea on how to 'upgrade a
production database', i'm all ears. Thanks.
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,
t.s.
PS: Or, if anyone has a simpler/better/faster idea on how to 'upgrade a
production database', i'm all ears. Thanks.