|Subject||RE: [firebird-support] Disable / Enable Triggers|
> Dear all,why is this necessary? what's wrong with backup and restore after running an
> 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.
update script on your metadata and data?