At 02:10 PM 23/02/2005 +0000, you wrote:

>We have been migrating and testing moving 10 systems from MS SQL to FB
>and we are about ready to pull the plug on our old server!!!
>
>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...
>
>I do a backup with -g and then a restore... however is there anything
>else that I should do prior to releasing this for real???

Yup. Do the backup *without* the -g switch, so that you clean out your
garbage. I know this switch is confusing, but -g means "no garbage
collection". All that deleting will have accumulated a mountain. Allow
plenty of time - it will take hours.

>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...)
>
>Basically I am looking for anything to help to prepare this new
>Firebird database ready for prime-time...

Are you pushing it straight out to production without an end-user
test-cycle? From long experience I can promise you that users are much
better at finding the real bottlenecks and gotchas than any test group with
test cases. :-)

>I really want this to go smoothly as some people would love to see
>this Firebird conversion fall on its face (M$ SQL lovers...)

..especially if your end-user test group has M$SQL lovers in it. Offer them
a prize for finding a way to kill it the system :-))

And good luck!

cheers,
./hb