Upgrade content databases from SharePoint 2010 to SharePoint 2013

Artikel
03/21/2018

**Gilt für:**SharePoint 2013, SharePoint Foundation 2013, SharePoint Server 2013

**Letztes Änderungsdatum des Themas:**2018-02-20

Summary: Learn how to upgrade content databases from SharePoint 2010 Products to SharePoint 2013.

When you upgrade from SharePoint 2010-Produkte to SharePoint 2013, you must use a database attach upgrade, which means that you upgrade only the content for your environment and not the configuration settings. After you have configured the SharePoint 2013 environment, copied the content and service application databases, and upgraded the service applications, you can attach and upgrade the content databases to SharePoint 2013. This article explains the steps you take to attach and upgrade the content databases to SharePoint 2013.

This article does not provide steps for how to upgrade a site collection. The process to upgrade site collections is separate from the process for upgrading the databases. For steps to upgrade a site collection, see Upgrade a site collection to SharePoint 2013.

Phase 4 of the upgrade process: Upgrade content databases

This is the fourth phase in the process to upgrade SharePoint 2010-Produkte data and sites to SharePoint 2013. The process includes the following phases that must be completed in order:

For an overview of the whole process, see Overview of the upgrade process from SharePoint 2010 to SharePoint 2013 and the Upgrade Process model Download the upgrade process model| .

Wichtig

This article applies to both SharePoint Foundation 2013 and SharePoint 2013.

Watch the SharePoint 2013 Upgrade: Phase 4 video

Before you begin

Before you attach and upgrade the content databases, review the following information and take any recommended actions.

Make sure that the account that you use to attach the databases is a member of the db_owner fixed database role for the content databases that you want to upgrade.
Make sure that the account that you use to create web applications is a member of the Farm administrators group in Zentraladministration.

Create web applications

Create a web application for each web application that existed in the SharePoint 2010-Produkte environment. For each web application, do the following:

Use the same URL (including name, port, and host header) and configure alternate-access mapping settings.

If you use a different URL, Office applications might not be redirected correctly to the new URLs and all bookmarks to the old URLs will not work.
Use the same authentication method.

For example, if you use Windows Classic authentication in your old environment, and you want to continue to use it, then you must create a web application that uses Windows Classic authentication. Because claims-based authentication is now the default option for SharePoint 2013, you must use PowerShell to create a web application that uses Windows Classic authentication.

Alternatively, you can migrate to claims authentication. For more information, see Migrieren von der klassischen Authentifizierung zur anspruchsbasierten Authentifizierung in SharePoint 2013.
Recreate included paths.
Recreate quota templates.
Configure email settings for the web application.

For more information, see Configure email integration for a SharePoint Server farm.
Enable self-service site creation for any web application that used it in the previous environment. Recreate any self-service site creation settings.
Create the managed path for the Meine Websites (/personal) on the web application that hosts Meine Websites. Meine Websites are available in SharePoint Server only.
Recreate any web application policies or other web application settings that you had configured in the previous environment.

Reapply customizations

One frequent cause of failures during upgrade is that the new environment does not have customized features, solutions, or other elements. Make sure that all custom elements from the SharePoint 2010-Produkte environment are installed on your front-end web servers before you upgrade any content databases.

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

Custom site definitions
Custom style sheets, such as cascading style sheets, and images
Custom Web Parts
Custom Web services
Custom features and solutions
Custom assemblies
Web.config changes (such as security)

Ensure that you transfer all 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. InfoPath is available in SharePoint Server 2010 only.
Any other components or files on which your sites depend.

SharePoint 2013 can host sites in both SharePoint 2010-Produkte and SharePoint 2013 modes. The installation for SharePoint 2013 contains both SharePoint 2010-Produkte and SharePoint 2013 versions of many elements. The directories on the file system are duplicated in both the 14 and 15 paths, for example:

Web Server Extensions/14/TEMPLATE/Features
Web Server Extensions/15/TEMPLATE/Features

There are also two versions of the IIS support directories: _Layouts, _Layouts/15 and _ControlTemplates, _ControlTemplates/15.

Be sure to install customizations to the correct location in your new farm. For example, additional style sheets for SharePoint 2010-Produkte should be installed in the /14 path, not the new /15 path so that site collections that you haven’t upgraded can use them. If you want a solution to be available to both paths, install it two times, and the second time use the CompatibilityLevel parameter when you install it, and it will be installed to the /15 path. For more information, see Install-SPSolution.

For more information about how to update customizations for use in SharePoint 2013, 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 Installieren und Verwalten von Lösungen für SharePoint 2013.

Verify custom components

To make sure that you have identified all custom components for your environment, use the Stsadm -o enumallwebs operation in the SharePoint 2010-Produkte environment and use the includefeatures and includewebparts parameters. This operation can report the templates, features, Web Parts, and other custom elements that are used for each site. For more information about how to use the enumallwebs operation, see Enumallwebs: Stsadm operation (Office SharePoint Server) and Bereinigen einer Umgebung vor dem Upgrade auf SharePoint 2013.

You can also use the Get-SPWeb Microsoft PowerShell cmdlet in your SharePoint 2010-Produkte environment to see template that are associated with each site and then verify that the template is installed in your SharePoint 2013 environment. For more information about this operation, see Get-SPWeb.

Before you attach the content databases to the web applications, use the Test-SPContentDatabase Microsoft PowerShell cmdlet to verify that you have all the custom components that you must have for that database.

To verify custom components are available by using PowerShell

Verify that you have the following memberships:
- securityadmin fixed server role on the SQL Server instance.
- db_owner fixed database role on all databases that are to be updated.
- Administrators group on the server on which you are running the PowerShell cmdlets.
An administrator can use the Add-SPShellAdmin cmdlet to grant permissions to use SharePoint 2013 cmdlets.

Hinweis

If you do not have permissions, contact your Setup administrator or SQL Server administrator to request permissions. For additional information about PowerShell permissions, see Add-SPShellAdmin.
Start the SharePoint Management Shell.
At the PowerShell command prompt, type the following command:
```
Test-SPContentDatabase -Name DatabaseName -WebApplication URL
```
Where:
- DatabaseName is the name of the database that you want to test.
- URL is the URL for the web application that will host the sites.

For more information, see Test-SPContentDatabase.

Attach a content database to a web application and upgrade the database

When you attach a content database, you upgrade the database and add the site collections in that database to the web application that you specify. However, for SharePoint 2013, the process does not upgrade the site collections.

When you attach a content database, for a web application that spans multiple content databases, make sure that you attach the content database that contains the root site collection first. When you attach a content database, include the root site for the web application in the first content database that you attach. In other words, before you continue, examine the root of the web application in the SharePoint 2010-Produkte server farm to determine the first site collection. After you attach the database that contains the root site, attach the other content databases for the web application in any order. You do not have to create any site collections to store the content before you attach the database. This process attaches the content databases and the site collections inside that database. Make sure that you do not add new site collections until you have restored all the content databases.

Tipp

Each site collection in a content database has a GUID that is registered in the configuration database and associated with the site collection. Therefore, you cannot add the same site collection two times to the farm, even in separate web applications. Although you can successfully attach the database in this situation, you will be unable to browse to the site collection.
If you must have a copy of a site collection in the same farm, first attach the database that contains the site collection to a separate farm, and then use the Backup-SPSite and Restore-SPSite PowerShell cmdlets to copy the site collection to the other farm. The backup and restore process creates a new GUID for the site collection. For more information about these cmdlets, see Backup-SPSite and Restore-SPSite.

For Meine Websites, attach the content database that contains the Meine Website host before attaching databases that contain the Meine Websites.

By default, when you created the web applications in the new SharePoint 2013 environment, a content database was created for each web application. You can ignore these default databases until after you have attached your SharePoint 2010-Produkte databases, and then you can delete the default databases.

Wichtig

If you are moving the content databases across domains or forests or to another environment that has different service accounts, make sure that the permissions for the service accounts are still correct before you attach the databases.

You must use the Mount-SPContentDatabase cmdlet to attach a content database to a web application. Using the SharePoint Central Administration pages to attach a content database is not supported for upgrading.

Ensure that the account that you use to attach the databases is a member of the db_owner fixed database role for the content databases that you want to upgrade.

Hinweis

One frequent cause of failures during upgrade is that the environment is missing customized features, solutions, or other elements. Be sure that all custom elements from the SharePoint 2010-Produkte environment are installed on your front-end web servers in the SharePoint 2013 environment before you start the upgrade process. Use the test-spcontentdatabase Microsoft PowerShell cmdlet to identify custom elements that your sites might be missing.

To attach a content database to a web application by using PowerShell

Verify that you have the following memberships:
- securityadmin fixed server role on the SQL Server instance.
- db_owner fixed database role on all databases that are to be updated.
- Administrators group on the server on which you are running the PowerShell cmdlets.
An administrator can use the Add-SPShellAdmin cmdlet to grant permissions to use SharePoint 2013 cmdlets.

Hinweis

If you do not have permissions, contact your Setup administrator or SQL Server administrator to request permissions. For additional information about PowerShell permissions, see Add-SPShellAdmin.
Start the SharePoint Management Shell.
At the PowerShell command prompt, type the following command and then press ENTER:
```
Mount-SPContentDatabase -Name DatabaseName -DatabaseServer ServerName -WebApplication URL
```
Where:
- DatabaseName is the name of the database that you want to upgrade.
- ServerName is server on which the database is stored.
- URL is the URL for the web application that will host the sites.

For more information, see Mount-SPContentDatabase.

Tipp

To upgrade from SharePoint Foundation 2010 to SharePoint 2013, attach the SharePoint Foundation 2010 content databases directly to the SharePoint 2013 environment. Just follow the same steps in this article, but use the SharePoint Foundation 2010 databases and a SharePoint 2013 farm. The upgrade process will upgrade the version and the product at the same time.

Verification: Verify upgrade for the first database

After you attach a database, you can use the Upgrade Status page in Central Administration to check the status of upgrade on your databases. After the upgrade process is complete, you can review the upgrade log file to see whether upgrade produced issues. You can use a PowerShell cmdlet to check the upgrade status for all the content databases. For more information about verifying and troubleshooting upgrade, see Überprüfen der Datenbankupgrades in SharePoint 2013 and Tests und Problembehandlung bei einem Upgrade auf SharePoint 2013.

To view the Upgrade Status page

Verify that the user account that is performing this procedure is a member of the db_owner fixed database role for the databases.
In Zentraladministration, click Upgrade and Migration, and then click Check upgrade status.

To view the upgrade log file

The upgrade error log file and the upgrade log file are located at %COMMONPROGRAMFILES%\Microsoft Shared\web server extensions\15\LOGS. The upgrade log file contains more detailed information than the upgrade error log. Be sure to check the summary at the bottom of the log files for information about the overall status and a count of the warnings and errors in the file.

The logs are text files named in the following format:
- Upgrade-YYYYMMDD-HHMMSS-SSS-error.log
- Upgrade-YYYYMMDD-HHMMSS-SSS.log
Where
- YYYYMMDD is the date
- HHMMSS-SSS is the time (hours in 24-hour clock format, minutes, seconds, and milliseconds)
An example for an upgrade error log is Upgrade-20120105-132126-374-error.log, and an example for an upgrade log is Upgrade-20120105-132126-374.log.

Hinweis

The format of the upgrade log for SharePoint 2013 is based on the same structure as ULS.
The upgrade log file includes the name of the content database being upgraded.

To view upgrade status for all databases by using PowerShell

Verify that you have the following memberships:
- securityadmin fixed server role on the SQL Server instance.
- db_owner fixed database role on all databases that are to be updated.
- Administrators group on the server on which you are running the PowerShell cmdlets.
An administrator can use the Add-SPShellAdmin cmdlet to grant permissions to use SharePoint 2013 cmdlets.

Hinweis

If you do not have permissions, contact your Setup administrator or SQL Server administrator to request permissions. For additional information about PowerShell permissions, see Add-SPShellAdmin.
Start the SharePoint Management Shell.

At the PowerShell command prompt, type the following command:

Get-SPContentDatabase | ft Name, NeedsUpgradeIncludeChildren

This cmdlet returns a table-style list of databases in your farm and indicates whether the database needs an upgrade to SharePoint2013.

Attach the remaining databases

After you restore the first content database and verify success, you can continue to restore and upgrade other databases. You can perform parallel database attach upgrades to upgrade more than one database at a time. Use separate Command Prompt windows to run multiple upgrades. It is recommended that you separate the start time for each new database upgrade session by several minutes to prevent issues with temporary locks set for the web application during attachment. Otherwise you might receive an error on the upgrade session. The wait time to clear temporary locks varies depending on the number of site collections, or the speed of the database server hardware.

Verification: Verify upgrade for additional databases

After you upgrade all additional databases, view the Upgrade Status page to monitor progress and verify that the upgrade process is complete. Review the log file to identify any other issues.

Next steps

After you upgrade the databases, you might want to perform additional steps to make sure that your farm is ready for use. For example:

Verify that site collections are working as expecting in 2010 mode.

Visually review site collections. You can use a similar review list as the one provided for upgraded sites in Checklists for reviewing upgraded sites.
Migrate user accounts to claims authentication, if it is necessary.

By default, new web applications in SharePoint 2013 use claims authentication. If you were using classic authentication in the previous environment, you must migrate the users to claims authentication. For more information, see Migrieren von der klassischen Authentifizierung zur anspruchsbasierten Authentifizierung in SharePoint 2013.
Update links that are used in any upgraded InfoPath form templates.

For a database-attach upgrade, you exported and imported all InfoPath form templates in your environment when you created the new environment. After upgrade, you can now update the links that are used in those upgraded form templates to point to the correct URLs by using a Microsoft PowerShell cmdlet.

For more information, see Configure InfoPath Forms Services (SharePoint Server 2010).

InfoPath is available in SharePoint Server only.
Configure your Search topology

The architecture for the Search service has changed for SharePoint 2013. Plan and configure your Search topology to suit your environment and the new architecture. For more information, see Skalieren der Suchfunktion für Internetsites in SharePoint Server and Verwalten der Suchtopologie in SharePoint Server.
Perform a full crawl

For more information, see Start, pause, resume, or stop a crawl in SharePoint Server.
Back up your farm

For more information, see Sichern von Farmen in SharePoint Server.

Although SharePoint Foundation 2013 includes search functionality, it is not the same Search service application that is in SharePoint 2013. These steps apply only to SharePoint 2013.

After your farm is ready, you can enable access to users, and then start to upgrade site collections. For information about how to upgrade site collections, see Upgrade a site collection to SharePoint 2013.

This is the fourth phase in the process to upgrade SharePoint 2010-Produkte data and sites to SharePoint 2013.

Next phase: Upgrade a site collection to SharePoint 2013

For an overview of the whole process, see Overview of the upgrade process from SharePoint 2010 to SharePoint 2013.

Freigeben über