Migrating from Legacy SharePoint to SharePoint Server 2010 : Performing a Database Attach Upgrade

1/29/2011 5:52:59 PM
The database attach process is a much more risk-averse migration process and is subsequently more likely to be used for most environments. It has the significant advantage of enabling SharePoint administrators to create new best-practice SharePoint 2010 environments and simply move the databases to a new farm and upgrade them there.

Understanding the Steps to Perform a Database Attach Upgrade

The high-level steps involved with a database attach upgrade are as follows:

Create a new SharePoint 2010 farm to best practices and validate all functionality in the farm. Test functionality with a pilot on sample data and prepare users for the transition.

Back up the original SharePoint 2007 databases.

Set the SharePoint 2007 databases to read-only mode if the migration is expected to take a longer period of time.

Restore a copy of the SharePoint 2007 content databases to the SQL Server for SharePoint 2010. Attach the databases to SQL Server.

From the Manage Content Databases area of the SharePoint Central Admin tool on the SharePoint 2007 server, as shown in Figure 1, select each individual database.

Figure 1. Selecting SharePoint 2007 content databases to be upgraded.

Check the remove content database box, as shown in Figure 2. Note that this will not delete the content database but simply detach it from SharePoint 2007.

Figure 2. Detaching content databases from SharePoint 2007 so they can be upgraded.

Create a new web application in SharePoint 2010, if not already created, such as the one shown in Figure 3. For a seamless migration, this web application should match the name of the SharePoint 2007 web application. This new web application will be used to house the migrated databases.

Figure 3. Creating a new web application for the migrated content databases.

In SharePoint Central Admin, on the new SharePoint 2010 server, be sure that there are no existing content databases in the newly created web application, as shown in Figure 4. Depending on how you create the web application, there may be one created there by default. Simply remove it in advance of the migration.

Figure 4. Verifying that there are no content databases in the new web application.

From PowerShell, run commands to attach the content databases to the web application, as illustrated in Figure 5. You cannot add the databases from the GUI; they must be added either by the deprecated STSADM command-line tool or (preferably) PowerShell. When added, each database starts the upgrade process, also illustrated in Figure 5.11. You can watch the upgrade from the SPCA tool in the “Upgrade and Migration” section of SPCA.

Figure 5. Attaching content databases and monitoring the upgrade process.

The exact syntax to use when upgrading is Mount-SPContentDatabase –Name DBNAME–DatabaseServer DBSERVER –WebApplication http://yourwebapp.companyabc.com (where DBNAME, DBSERVER, and http://yourwebapp.companyabc.com are all names of your databases, servers, and webapps, respectively). Note in Figure 5.11 that one database has already been attached and upgraded, and the second one is in the process of being upgraded. Depending on the size of the database, this may take some time to upgrade. When a database is upgraded, it can immediately be used, though until the Visual Upgrade process is done, it will still have the same look and feel of the old site.

  •  SharePoint 2010 : Performing an In-Place Upgrade of a SharePoint Environment
  •  Sharepoint 2007: Create a New List Item
  •  Sharepoint 2007: Create a New Document
  •  Exchange Server 2007 : Administrate Transport Settings - Manage Connectors (Send and Receive)
  •  Exchange Server 2007 : Administrate Transport Settings - Configure Journaling
  •  Managing Exchange Server 2010 : The Exchange Management Shell (part 3) - Reporting with the Exchange Management Shell
  •  Managing Exchange Server 2010 : The Exchange Management Shell (part 2) - Remote PowerShell
  •  Managing Exchange Server 2010 : The Exchange Management Shell (part 1) - Bulk user creation in the Exchange Management Shell
  •  Migrating from Legacy SharePoint to SharePoint Server 2010 : Planning for an Upgrade to SharePoint 2010
  •  Migrating from Legacy SharePoint to SharePoint Server 2010 : Formulating a Migration Strategy
  •  Sharepoint 2007: Upload a File Using the Explorer View
  •  Sharepoint 2007: Upload a File Using Web Folders
  •  Sharepoint 2007: Upload a File from an Office Application
  •  Sharepoint 2007: Upload a File - Upload a File from the Web Interface
  •  Exchange Server 2007: Manage Recipients - Configure Expansion Servers
  •  Exchange Server 2007: Manage Recipients - Create Distribution Groups and Dynamic Distribution Groups
  •  Exchange Server 2007: Create Mail-Enabled Contacts and Mail-Enabled Users
  •  Advanced SharePoint 2010 Installation and Scalability : Scaling Logical SharePoint Components
  •  Installing SharePoint 2010 Using PowerShell
  •  Installing Exchange Server 2010 into an existing Exchange Server 2007 environment (part 3) - Configure Exchange Web Services
    Top 10
    Windows 7 : Configuring Backups and Recovery - Using Advanced Boot Options
    jQuery 1.3 : Table Manipulation - Sorting and paging (part 1) : Server-side sorting & JavaScript sorting
    Samsung Galaxy Tab 7.0 Plus - Tablet reloaded
    Mobile Application Security : SymbianOS Security - Development and Security Testing
    SQL Server 2008 : Working with DML Queries - Using the UPDATE Statement (part 1)
    Backing Up the Exchange Server 2010 Environment : Supporting Backups with Documentation
    Olympus SH- 21
    Windows Server 2008 R2 Active Directory Domain Services Primer : Outlining the Role of DNS in AD DS
    Microsoft XNA Game Studio 3.0 : Working with Colors
    Programming .NET Security : Programming Digital Signatures (part 1) - Using the Abstract Class
    Most View
    Hacking - The Whole Infrastructure
    Apple Releases OS X Mountain Lion Developer Preview 4
    Introduction to Transport-Level Security in Windows Server 2008 R2
    Windows Mobile Security - Permissions and User Controls
    Recovering from a Disaster in an Exchange Server 2010 Environment : Recovering Exchange Server Application and Exchange Server Data
    Motorola Xoom 2 Media Edition
    Programming with DirectX : Game Math - Bounding Geometry (part 2) - Bounding Spheres & Bounding Hierarchies
    WCF Services : Data Contract - Hierarchy
    Create Your Own E-Books (Part 4) - The EPUB Format & Introducing Sigil
    Programming Microsoft SQL Server 2005 : An Overview of SQL CLR - CLR Triggers
    SQL Programming Language : Ordering, Calculating, and Grouping in Queries
    SQL Server : Exception Handling
    Windows Tips & Tricks (June 2012) – Part 3 - StarOffice - Specialist for old languages
    Extra Network Hardware Round-Up (Part 3)
    Windows Server 2003 : Configuring Forest and Domain Functional Levels
    Silverlight : Put Content into a 3D Perspective
    Architecting a SharePoint 2010 Deployment : Choosing the Right Hardware for SharePoint
    Windows Vista : Make Your Hardware Perform (part 2) - Maximize the Windows Performance Rating
    Transact-SQL in SQL Server 2008 : Spatial Data Types (part 3) - Spatial Data Support in SSMS
    H8-1090D Desktop PC - Elite Class