Sindunata wrote:

>
> Just create the table first in IB/FB without the constraints (check,
> foreign key, primary key), etc, and then transfer your FoxPro data to this
> table, and after that, create the table constraint. The only caveat is, you
> won't be able to edit the data that violates the constraint.
>

You might find that restore from backup will be a problem, too.

I would say that part of the migration process will have to involve a clean up
of the data if you want to use the built-in integrity constraints. Sindunata's
explanation misses one thing - during the data import use 'before insert'
triggers to tidy up the rogue or missing values.

Paul
--

Paul Reeves
http://www.ibphoenix.com
taking InterBase further