Subject Re: [firebird-support] Confusion on sequence for importing data
Author Martijn Tonies
Hi Terry,

> As a relative newcomer here, I could really do with some help:
> I am required to create a database, then import the data from several
> Access (spit!) tables, and create indexes, triggers/generators and FK
> constraints.
> The problem I have is with the sequence in which these should be done.
> The structure of all the FB tables (and their indexes/constraints etc) has
> been decided, and saved as an .sql
> I modified the .sql script to only create the database and tables, then
> pumped over the data (using dbWB), then attempted to add the indexes/FKs
> and triggers/generators. This doesn't appear to work as I had hoped.

Any error messages?

> In these circumstances, is there an 'accepted' sequence to follow?

Well, if all the Fk data is fine, the order you have described should
work just fine.

With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Upscene Productions