Originally Posted by hdawg
I'd do the upgrade first on the win2k server and then cut over to 4.1 SP4 on the new server ... but either will work.
Yeah either will work. Mostly that order can depend on if the old hardware you are moving from is capable of handling the new version. This was really only an issue for very small shops or people making jumps from 3.6 to 4.1.
Don't forget to use the CreateDB utility to create a new blank database of the same name on the SQL server, then do the backup and restore. If you upgrade first, use the CreateDB from 4.1, if you move then upgrade, use CreateDB from 4.0.