Migrate a content database from SharePoint 2007 to 2010


Migrate a content database from SharePoint 2007 to 2010

BACK UP YOUR 2007 CONTENT DATABASE

Back up your 2007 content database from SQL Management Studio on the SharePoint 2007 server, and put the backup file somewhere it is accessible from the new SharePoint 2010 Server instance.

Backup SharePoint Content Database from SQL Server

RESTORE THE 2007 CONTENT DATABASE TO THE SHAREPOINT 2010 DATABASE INSTANCE

Connect to the SQL Server Instance hosting your SharePoint 2010 installation’s databases.  Restore the wss_content database from the backup file created in the step above.

DETATCH ANY CONTENT DATABASES FROM THE TARGET WEB APPLICATION

In Central Administration –> Application Management, select “Manage Content Databases” under the Database heading.

Select the target web application in the “Web Application” drop-down box at the top left, if it is not already ­­­

Ensure there are no content databases for the target web application.  If the list contains any content databases, click on each content database name.  On the “Manage Content Database Settings” screen, select the “remove content database” checkbox and click OK.

Remove Content Database from SharePoint Site

RUN THE POWERSHELL TEST-SPCONTENTDATABASE CMDLET

Launch the SharePoint 2010 Management Shell available under Start->Programs –> Microsoft SharePoint 2010 Products. 

Run the Test-SPContentDatabase command from the SharePoint 2010 Management Shell PowerShell window with the following syntax:

Test-SPContentDatabase –Name your_content_db –WebApplication http://YourSiteName

RESTORE THE CONTENT DATABASE USING STSADM.EXE

Using the stsadm.exe tool, run the addcontentdb command using the syntax below:

stsadm -o addcontentdb -url http://YourSiteURL -databasename your_content_db -databaseServer YourDatabaseServer

PowerShell Command

Mount-SPContentDatabase "<ContentDb>" -DatabaseServer "<DbServer>" -WebApplication http://SiteName
 

Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s