Subject Re: [firebird-support] OT: IBPump
Author Alexandre Benson Smith
Jason Dodson wrote:

>Hey all,
>
>I know this is off topic, but I know this will get some feedback from those who
>matter. I am trying to use IB DataPump to move data from our current production
>database, to a rebuilt, empty database with sane permissions set.
>
>The issue I have run into is, IBPump wrongly orders the tables, so when trying
>to pump data over to the destination database, oodles of foreign Key violations
>occur. Is there some way to reorder the order that the tables are pumped? Is
>there possibly another solution?
>
>Thanks,
>Jason
>
>
Jason,

Strange, I had used it a lot and had never be in trouble with FK order,
do you have self-reference tables ?

One thing that I always do is to mark an option to disable the FK's.

HTH

See you !

--
Alexandre Benson Smith
Development
THOR Software e Comercial Ltda
Santo Andre - Sao Paulo - Brazil
www.thorsoftware.com.br