Last night I attended a meeting of the Triangle SharePoint Users Group (aka TriSPUG) here in Raleigh where they had a presentation by Jason Medero of B&R Solutions on “Migrating from SharePoint 2007 to SharePoint 2010 – Tools and Options.” In the presentation, Jason presented four ways to migrate and upgrade your current SharePoint 2007 farm to SharePoint 2010. Those four approaches are:
- In-Place Upgrade – the easiest approach but has the least amount of flexibility in configuration and has the most downtime. Also, depending on your hardware, it updates all the databases simultaneously which slows down the process and can take days or even weeks if this is attempted on a site with large content databases. And there is no ability to pause or rollback the upgrade.
- Database Attach – this is where you detach your content databases, create a new installation of SharePoint 2010, recreate your configuration, and finally reattach the content databases. This method has your site down while you upgrade.
- Hybrid Read-Only Database Attach – This method has you put your current site in read-only mode as you use backups to do the database attach on the new farm. This allows for users to continue using the site as you set up the new one. Once complete, you do a DNS change and point everyone to the new farm.
- Hybrid Detach Database Upgrade – Here you detach your content databases first, do the in-place upgrade, then reattach those content databases. The advantage with this is that the configuration is upgraded without having to reconfigure.
Take a look at the video below to hear Jason discuss all of these options as well as the tools to use before you start any of these methods. WARNING: the audio in the video is very loud so adjust your speakers prior to hitting play.