I am working on upgrading a SharePoint Farm from MOSS 2007 to SP2010 enterprise edition. The existing 2007 farm has a webserver running all services, and a db server. The upgraded farm will have the same setup, though on newer hardware (Both are virtual machines.
I have performed the upgrade and worked though all the issues I encountered. My plan is to now schedule a time when I will put the old farm into read only, take a fresh copy of the database and upgrade using the database attach method. After wards I will clone both servers and have identical production/test environments
My question is: If I apply service pack 1, then upgrade my content db using database attach, will it upgrade it to the correct version? Or do I have to start with a plain install, upgrade the content db, then apply SP1? Similiarily, if I tried to add an RTM contentdb to a sharepoint farm running SP1 would it be updated?