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.
Ensure that you have met all hardware and software requirements. You must have a 64-bit version of Windows Server 2008 or Windows Server 2008 R2. For server farms, you must also have a 64-bit version of SQL Server 2005 or SQL Server 2008. For more information about these requirements (such as specific updates that you must install), see Determine hardware and software requirements (SharePoint Server 2010).
Ensure that you are prepared to set up the required accounts by using appropriate permissions. For detailed information, see Administrative and service accounts required for initial deployment (SharePoint Server 2010).
Run the pre-upgrade checker on your original environment. The pre-upgrade checker identifies potential upgrade issues in your environment so that you can address them before you upgrade. It can also help you identify settings that you need in your new environment. For more information, see Run the pre-upgrade checker (SharePoint Server 2010).
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:
Install SharePoint Server 2010 on the server or servers.
Configure service applications.
Configure general farm settings.
Create and configure Web applications.
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:
Run the Microsoft SharePoint Products Preparation Tool to install all required software.
Run Setup to install the product.
Install any language packs that you need in your environment.
Run the SharePoint Products Configuration Wizard to configure your server or servers.
The following articles provide step-by-step instructions for performing these tasks.
Install and configure the product
Follow the steps in one of the following articles to install and configure SharePoint Server 2010 on a single server or server farm:
For more deployment scenarios (such as installing in a stand-alone environment with SQL Express), see Deployment scenarios (SharePoint Server 2010).
Install and configure language packs
Follow the steps in Deploy language packs (SharePoint Server 2010) to install and configure any language packs that are needed for the sites in your environment.
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 (https://go.microsoft.com/fwlink/p/?LinkId=166117).
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:
InfoPath Forms Service
Configure InfoPath Forms Services by using the Configure InfoPath Forms Services link on the General Application Settings page in SharePoint Central Administration. Export any administrator-deployed form templates (.xsn files) and data connection files (.udcx files) from your Office SharePoint Server 2007 environment, and then import them to your new SharePoint Server 2010 environment. For more information, see Configure InfoPath Forms Services (SharePoint Server 2010)and Plan to upgrade form templates during an upgrade to SharePoint Server 2010.
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
And you must configure any new farm-level settings that you want to use, such as the following:
Usage and health data collection
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:
For classic authentication: Create a Web application (SharePoint Server 2010)
For claims-based authentication: Create claims-based web applications in SharePoint 2010 and Configure forms-based authentication for a claims-based Web application (SharePoint Server 2010)
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:
Custom site definitions
If the site definition was created in Office SharePoint Server 2007, you can copy it over to the new environment as-is. If, however, it was created in Microsoft Office SharePoint Portal Server 2003, you might have to create an upgrade definition file to map the site definition to the new features in Office SharePoint Server 2007. For more information, see Develop new custom site definitions and create upgrade definition files (Office SharePoint Server) and Deploy upgrade definition files and new site definitions (Office SharePoint Server).
Custom style sheets, including cascading style sheets, and images
Custom Web Parts
Custom Web services
Custom features and solutions
Web.config changes (such as security)
Ensure that you transfer any unique settings from the Web.config files for each Web application to the new servers.
Administrator-approved form templates (.xsn files) and data connection files (.udcx files) for InfoPath
You must export form templates and data connection files from the original environment and then import them to the new environment. For more information, see Plan to upgrade form templates during an upgrade to SharePoint Server 2010 and Perform post-upgrade steps for a database attach upgrade (SharePoint Server 2010).
Any other components or files on which your sites depend.
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.