rjschappe wrote:

> During testing we have been (every night) deleting all the records off
> of most of the new FB tables/database and then pumping over around 1.3
> million records...

You would be better off with metadata-only backup&restore. In such
case you only need to watch out for generators. In Firebird 1.x they
get backed-up and restored with DDL, so make sure you set them to
proper values after (or before) the pumping.

> I am not sure... but like reseting the last active trans, oldest
> trans, updating the statistics, etc....???? (there is some worry that
> our home-built data-pump may not be cleaning up after it's own
> transactions very well...)

Where does it pump from? If it is another Firebird database, you might
consider FBCopy which has so far show to be very robust and stable.

--
Milan Babuskov
http://fbexport.sourceforge.net
http://www.flamerobin.org