SharePoint migration 2007 to 2010 to 2013 Notes database attach

  • Convert the MOSS 2007 site to 2010 and then to 2013.
  • (2) Take the backup of the existing content database to be migrated using SQL server backup utility.
  • Restore the content database to the destination SQL server.
  • Provision dbo access to the restored database for the user-id used to mount.
  • Create the new web application and corresponding site collection at other than root (include sites in URL).
  •   Attach the restored content database using power shell mount cmdlet:

Mount-SPContentDatabase -Name WSS_Content_8588 -DatabaseServer dbservername -WebApplication http://acb:8588/ -Updateuserexperience

  • (7) Make the default content database offline and then remove it and keep only the restored one.
  • Now that we have converted from MOSS 2007 to 2010 let us changes its authentication type to Claims since Classic has been deprecated in 2013. Run the powershell script:

$WebAppName = “http://acb:8588/”###
$wa = get-SPWebApplication $WebAppName

$wa.UseClaimsAuthentication = $true

$wa.Update()

$account = “ADMIN\SPAdmin”

$account = (New-SPClaimsPrincipal -identity $account -identitytype 1).ToEncodedString()

$wa = get-SPWebApplication $WebAppName

$zp = $wa.ZonePolicies(“Default”)

$p = $zp.Add($account,”PSPolicy”)

$fc=$wa.PolicyRoles.GetSpecialRole(“FullControl”)

$p.PolicyRoleBindings.Add($fc)

$wa.Update()

$wa.MigrateUsers($true)

$wa.ProvisionGlobally()

  • Then follow the same above steps from (2) to (7) and convert from MOSS 2010 to 2013.
  • Now navigate to the root site and click on setting. On Site Settings => Site Collection Administration sub group, click on Site Collection Upgrade. This will take some time.
  • Provisioned db_owner access to user ‘ADMIN\app_pool_account’ for the attached content database (say WSS_Content_1) on SQL Server side.
  • Now navigate to the root site and click on setting. On Site Settings => Site Collection Administration sub group, click on Site Collection Features.
  • Activate the any additional your environment specific features such as Report Server Integration Feature.
  • The site is ready to use.
Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

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