Subject | Getting ready for moving to production? |
---|---|
Author | rjschappe |
Post date | 2005-02-23T14:10:25Z |
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???
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...
I really want this to go smoothly as some people would love to see
this Firebird conversion fall on its face (M$ SQL lovers...)
Many thanks,
--Raymond
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???
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...
I really want this to go smoothly as some people would love to see
this Firebird conversion fall on its face (M$ SQL lovers...)
Many thanks,
--Raymond