Share via

Prepare the new SharePoint Server 2010 environment for a database attach upgrade


Applies to: SharePoint Server 2010

When you upgrade from Microsoft Office SharePoint Server 2007 to Microsoft SharePoint Server 2010 by using the database attach approach, you upgrade only the content for your environment and not the configuration settings. Using a database attach upgrade is useful when you are changing hardware or want to reconfigure your server farm topology as part of the upgrade process. For more information about how to choose an upgrade approach, see Determine upgrade approach (SharePoint Server 2010).

Before you can upgrade the data, you must configure a new server or server farm by using SharePoint Server 2010. This article explains the elements you need to configure to create that new environment. For more information about the general process of upgrading by using the database attach upgrade approach, see Upgrade process overview (SharePoint Server 2010).


To perform the steps in this article, you must have administrator rights on the local server computer. For more information, see Initial deployment administrative and service accounts (SharePoint Server 2010).

In this article:

  • Before you begin

  • Create and configure the new environment

  • Verify the new environment

  • Perform the upgrade

Before you begin

Before you begin to create the new environment for a database attach upgrade, review the following information about permissions, hardware requirements, and software requirements.

Create and configure the new environment

The process of creating and configuring the new environment contains several steps, which must be performed in the correct sequence. These steps are:

  1. Install SharePoint Server 2010 on the server or servers.

  2. Configure service applications.

  3. Configure general farm settings.

  4. Create and configure Web applications.

  5. Reapply customizations.

The remainder of this section describes these steps and provides links to other articles that contain step-by-step instructions for performing them. After you have performed these steps, you can verify the environment and then perform the upgrade.


The first step in creating your new environment is to install SharePoint Server 2010 and configure your new server or server farm. You must do the following:

  1. Run the Microsoft SharePoint Products Preparation Tool to install all required software.

  2. Run Setup to install the product.

  3. Install any language packs that you need in your environment.

  4. Run the SharePoint Products Configuration Wizard to configure your server or servers.

The following articles provide step-by-step instructions for performing these tasks.

Configure service applications

You must create the services settings on your new farm before you upgrade the data in a database attach upgrade. The steps included in the deployment scenarios articles listed above describe how to use the Initial Farm Configuration Wizard to enable all services. After running the wizard, you must transfer any custom settings from your original environment to your new environment and configure any additional services and settings you need.

Use the Initial Farm Configuration Wizard to enable the following service applications:

  • Business Data Connectivity service

    Data from the Business Data Catalog service is not upgraded to the Business Data Connectivity service when you perform a database attach upgrade. If you want to continue to use the external data that is accessed through one or more application definitions, you must complete the following tasks:

    • In your original environment, export any application definitions (models) that are required by your solution from the Office SharePoint Server 2007 Business Data Catalog. For more information, see Export application definition.

    • Update the solution to use the object model and features of the Microsoft Business Connectivity Services. This includes updating the application definition file to be compatible with Microsoft Business Connectivity Services. For information about the Business Data Connectivity service object model, see Microsoft SharePoint 2010 Software Development Kit (

    • In your new environment, configure the Business Data Connectivity service application.

    • After upgrade, import the updated model into the Business Data Connectivity service. For more information, see Manage BDC models (SharePoint Server 2010).

  • Excel Services Application

    You must reconfigure this service application when you perform a database attach upgrade. Make sure that you re-create any trusted data connections. For more information, see Excel Services administration (SharePoint Server 2010).

  • Managed Metadata service

    This is a new service in SharePoint Server 2010. Before you can upgrade user profile data in a database attach upgrade, you must enable and configure this service application. For more information, see Create, update, publish, or delete a managed metadata service application (SharePoint Server 2010).

  • Search service application

    Search settings are not preserved during a database attach upgrade. You must manually reconfigure Search before you upgrade. For more information about how to configure Search, see Configure enterprise search (SharePoint Server 2010).

  • Secure Store service

    You need to enable and configure this service application so that you can upgrade Excel Services Application and Business Data Catalog data. For more information, see Create and configure the Secure Store service application and migrate SSO data to the Secure Store service in the article Perform post-upgrade steps for a database attach upgrade (SharePoint Server 2010).


Do not enable and configure the User Profile service application by using the Initial Farm Configuration Wizard. Although you must have configured this service application and the User Profile Synchronization service before you upgrade the SSP database, specific steps are required to configure these services. The steps required to configure these services and upgrade the SSP database are included in the Upgrade the shared services database section of the article "Attach databases and upgrade to SharePoint Server 2010."

You must also enable and configure the following service:

Configure general farm settings

The next step in creating the new environment is to apply general farm settings. You must manually reapply configuration settings from your previous version farm, including the following:

  • Incoming and outgoing e-mail settings

  • Any farm–level security and permission settings, such as adding user or group accounts to the Farm Administrators group.

  • Blocked file types

  • Quota templates

And you must configure any new farm-level settings that you want to use, such as the following:

  • Usage and health data collection

  • Diagnostic logging

  • Mobile accounts

For more information about how to configure these settings, see Configure farm settings (SharePoint Server 2010).


If you had disabled the Workflow Auto Cleanup timer job in your Office SharePoint Server 2007 environment, make sure that you disable this timer job in your new environment also. If this timer job is enabled in the new environment and disabled in the previous version environment, you might lose workflow associations when you upgrade. For more information about this timer job, see Disable preservation of workflow history (SharePoint Server 2010).

Create and configure Web applications

Create a Web application for each Web application that existed in the original environment. For each Web application, do the following:

  • Use the same URL and configure any alternate-access mapping settings.


    If you use a different URL, Microsoft Office applications might not be redirected correctly to the new URLs and any bookmarks to the old URLs will not work.

  • Use the same authentication method.


    If you were using forms-based authentication, you will need to configure claims-based authentication instead. You must also create a Web application policy to grant Full Control to the user account that will be performing the database attach upgrade.
    For more information, see Configure forms-based authentication for a claims-based Web application (SharePoint Server 2010).

  • Re-create included paths (such as /Sites).

  • Enable self-service site creation for any Web application that used it in the previous environment.

For more information about how to configure Web applications and authentication, see the following articles:

Reapply customizations

One frequent cause of failures during upgrade is that the environment is missing customized features, solutions, or other elements. Make sure that any custom elements you have to have are installed on your front-end Web servers before you begin the upgrade process. You can use the pre-upgrade checker to compile a list of server-side customizations in your environment. For more information, see Identify and install customizations in the article "Use a trial upgrade to find potential issues."

In this step, you manually transfer all customizations into your new farm. Make sure to install any components that your sites depend on to work correctly, including the following:

For more information about how to update customizations for use in SharePoint Server 2010, see: Redeploying Customizations and Solutions in SharePoint Foundation 2010 and SharePoint Server 2010. For more information about how to deploy customizations to your environment, see Deploy customizations - overview (SharePoint Server 2010).

Verify the new environment

After you have set up the new environment, you can perform tests to make sure it contains all the components you need before you upgrade your data. To test your new environment, you can use the following methods:

  • Create a new Web application and then use the Windows PowerShell Test-SPContentDatabase cmdlet to verify that all the server-side customizations that are needed for that content database are present in the new environment. Do not attach or upgrade the database. For more information, see Test-SPContentDatabase.


    You can also run this command on the original content database, but the database should not be in active use at the time.

  • Use the enumallwebs Stsadm operation in your Office SharePoint Server 2007 environment to see which template each site is associated with and then verify whether the template is installed in your SharePoint Server 2010 environment. The October Cumulative Update includes improvements to the enumallwebs operation that can help you find customizations in use. For more information about this operation, see Enumallwebs: Stsadm operation (Office SharePoint Server).

Perform the upgrade

After you finish preparing the new environment, you can attach and upgrade the databases.

Follow the steps in Attach databases and upgrade to SharePoint Server 2010 to attach and upgrade the databases from the Office SharePoint Server 2007 server or server farm to the new SharePoint Server 2010 server or server farm.

See Also

Other Resources

Downloadable book: Upgrading to SharePoint Server 2010
Resource Center: Upgrade and Migration for SharePoint Server 2010