Review: Quest Migration Manager for Sharepoint

Many organizations that are running SharePoint 2003 or SharePoint 2007 are thinking about moving to SharePoint 2010 to take advantage of its new socialfeatures, business intelligence capabilities, and search improvements. However, migrating SharePoint 2010 is not an easy task, asthere is no direct migration path from SharePoint 2003 to SharePoint 2010. That's where Quest Migration Manager for SharePoint comes into play. Thistool enables organizations to transfer content from SharePoint 2003 or 2007 to SharePoint 2010 or to reorganize and consolidate content withinSharePoint 2007 or SharePoint 2010 environments.

Installation and Setup

Migration Manager for SharePoint works on these SharePoint versions:

SharePoint 2003

SharePoint 2007

SharePoint 2010 Server

The tool must be installed on each SharePoint server that will be used as a source. Installation is a breeze, with an easy-to-use wizard interface.Installing the tool took about 15 minutes per source SharePoint server.

You must also install an extension web service component on the target SharePoint servers, to preserve certain metadata information (e.g., createddate, created by). Installing the extension web services component was pretty straightforward and took just 5 minutes.

During the installation process, a repository database is created, so the user account should have the DB owner role on the SQL Server database.Several other permission combinations might be required, depending on the migration scenario. The tool's online Help comes in handy when determiningwhich prerequisites and permissions apply to your situation.

Using the Migration Manager for SharePoint

Migration Manager for SharePoint provides a web interface for creating, scheduling, and tracking migration jobs, as Figure 1 shows. Because the tool isweb based, you can track migration jobs remotely, without needing to log on to the source server. When you create a migration job, additional optionsare available to manage exclusions, filtering, and scheduling. For example, I could choose from these filtering options:

Figure 1: Migration Manager web interface

I could also choose to exclude particular sites, documents, libraries, or lists.

Migration

I was able to execute several migration tasks with different combinations of sites, servers, exclusions, and filters, without any major hassles. Alldocument libraries, list content, artifacts such as metadata, and permissions were moved intact from source to target SharePoint sites. MetadataInformation, such as created date, was migrated correctly to the target servers on which I'd installed the extension service. Custom workflows that I'dcreated by using SharePoint designer were also moved correctly, but the tool lacks support for migrating out-of-the-box SharePoint workflows-definitelya feature I'd want.

The speed of migration was a bit on the slower side. It took about 45 minutes to migrate sites with 50MB of content from SharePoint 2007 to SharePoint2010. Although the majority of the content migrated successfully, I did run into a few issues:

Scheduling

Scheduling options allow you to run a migration job on specific days and during specific hours. This capability lets you schedule migration duringoff-peak hours. The tool began the migration job only during the hours and day that I specified, and accurately restarted from where it had stopped onthe next scheduled day. However, an option to select a start date for the migration job would have made the scheduler even better.

Consolidation

Migration Manager for SharePoint also enables consolidation of content, by facilitating moving specific sites, libraries, or lists within a SharePoint2007 or 2010 site or site collection. The tool doesn't have the facility to move only specific sets of users or groups, which would have helped duringpermission restructuring.

Tracking

The monitoring section of Migration Manager for SharePoint helps to track the progress of migration jobs. This section provides status reporting oncontents moved, remaining time (as Figure 2 shows), and so on. However, when checking the migration status, we noticed that the displayed timeremaining was inaccurate and showed a huge time variance on a different visit to the monitoring page.

Figure 2: Status reporting on remaining time

An important feature that is missing is a notification mechanism to alert administrators when a job is completed or an issue is logged. Without thiscapability, I needed to constantly check the monitoring page for status updates.

The Bottom Line

Overall, Quest Migration Manager for SharePoint performs a decent job migrating content from SharePoint 2003 or 2007 to SharePoint 2010. Features suchas post-migration synchronization of content and flexible scheduling options make this a worthy tool. Adding missing pieces, such as notificationfunctionality and select permission move, would make the tool better. On a final note, Quest plans to release a new version of Migration Manager thatwill support migration to Microsoft Office 365, an option that will benefit organizations that want to move to SharePoint Online.