SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

From SharePoint 2007 to SharePoint 2010, I have partially migrated some of our sites. However, since due to the immediateness of the requirement, sites which has issues was left behind the old SharePoint.

Now I am faced migrating a site which has 'People' fields. My problem is whenever I do Export/Import-SPWeb, the 'People' loses value - this is due to the fact that the UserInfo table is incomplete, not all users have logged in to the new site collection.

Is it possible to prepopulate the UserInfo table with what is in the User Profile? Please advise.

share|improve this question

in SharePoint 2010, once user profile is setup run the Full Syncronization which should automatically try pushing updates to User Information lists across sites.

It is possible to use still the old stsadm -sync command to refresh old content databases. Gary Lapointe shared a script ( which should help you force a sync (for this user across all site collections), see below

function Sync-SPUser([string]$userName) {
  Get-SPSite -Limit All | foreach {
    $web = $_.RootWeb
    if ($_.WebApplication.UseClaimsAuthentication) {
      $claim = New-SPClaimsPrincipal $userName -IdentityType WindowsSamAccountName
      $user = $web | Get-SPUser -Identity $claim -ErrorAction SilentlyContinue
    } else {
      $user = $web | Get-SPUser -Identity $userName -ErrorAction SilentlyContinue
    if ($user -ne $null) {
      $web | Set-SPUser -Identity $user -SyncFromAD
share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.