At 10:14 AM 3/30/2001 +1000, Geoff Worboys wrote:

> > You have to be very careful of the order in which you restore
> > data, triggers, & constraints. Easier, of course, if you know
> > the database.
>
>Is there any problem with just restoring the domains and table
>structures (and perhaps primary keys) then restore the data and then
>restoring everything else? Obviously there is still some order issues
>with procedures but these are fairly easy to avoid.

I think the order is something like:

Domain definitions
Table definitions excluding computed columns & views

Commit

Store table data

commit

Generators

Commit

Procedures
Computed columns & views
Constraints
Triggers

Commit

Indexes

Commit

Within a single commit, InterBase will order things correctly.
What you need to do is avoid having triggers and constraints
active when the data is stored.



Regards,

Ann
www.ibphoenix.com
We have answers.