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?

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.


See you !

Alexandre Benson Smith
THOR Software e Comercial Ltda
Santo Andre - Sao Paulo - Brazil