Subject Re: How to deactivate check constraint?
Author Adam
--- In firebird-support@yahoogroups.com, "vincent_kwinsey"
<vincent_kwinsey@...> wrote:
>
> This can be necessary when someone wants to move raw data from one
> gdb file (call it source) to another gdb file (source) and it can be
> done much easier when check constraints (together with indexes etc.)
> are deactivated on target (one can find workarounds, indeed, as
> specity the sequence how data from each table are moved, but it can
> be time consuming). Such data move can be necessary when source gdb
> gets corrupted but data are still available from it...

In that case, it is usually fastest to drop and recreate. I use
IBDataPump to do this sort of task, and it does all that for you.

Adam