Migration – My SharePoint Adventures

Administration

Undeclare / Declare all / some records in a list

Andrew Toh

Requirement Undeclare all records in a SharePoint list. Declare all records in a SharePoint list. Declare only specific records in a SharePoint list. Solution Use the following PowerShell script. $SPAssignment = Start-SPAssignment $web = Get-SPWeb <a href="http://your-site">http://your-site</a> -AssignmentCollection $spAssignment $list = $web.lists["your-list"].items foreach ($item in $list) { $IsRecord = [Microsoft.Office.RecordsManagement.RecordsRepository.Records]::IsRecord($Item) if ($IsRecord -eq $true){ Write-Host […]

Administration

Migrated data contains old workflow columns/fields

Andrew Toh

Problem When migrating items from a list with associated workflows, the migrated items retain the metadata fields associated with the list. This includes all workflow columns which you most likely would not need. Solution Deassociate the workflows from the original list prior to moving the list items. Go to List Settings -> Workflow Settings -> […]

Administration

Migrate sites using database attach method

Andrew Toh

Requirement Recently had to reinstall SharePoint for our developer. He had a content database with a bunch of site collections in it and he wanted to keep it after the farm was reinstalled. Solution After reinstalling SharePoint: Re-attach the database in SQL Management Studio. Mount the content database in powershell and attach it to the […]