Overview
You may want to sync the user's ID between Social and Sharepoint using the UPA migrator. This article shows the steps to do it.
Information
NOTE: This process requires SharePoint Server 2010 and above and access to MS SQL Server as an Administrator, or DBA owner access to the NewsGator Social Services, NewsGator Reporting, and SharePoint User Profile (Profile DB) databases.
NOTE: Before running the steps, it's always a good idea to backup the DataBase
To run the UPA migrator against a batch of users (used to correct multiple instances of mismatched RecordID's), follow the instructions below:
- Copy the SQL_UPAMigratorAll.zip file to your SQL server that hosts the Sitrion and SharePoint databases.
- Right-click on the file and then select Properties > click Unblock (if applicable) > Extract the .zip file.
- Navigate to the folder where you unzipped the SQL_UPAMigratorBatch.zip file, open the SQL_UpaMigrator_Procs folder and connect to the SQL instance using SQL Server Management Studio.
- Open the SQL_UpaMigrator_Services_Procs.sql file in SQL Server Management Studio and execute the file against the NewsGator_SocialServices database.
- Open the SQL_UpaMigrator_Reporting_Procs.sql file and execute the file against the NewsGator_Reporting database.
- Navigate one level up to the folder where you unzipped the SQL_UPAMigratorAll.zip file and open the UPA_Indexes.sql file in SQL Server Management Studio.
- Edit the USE statement in line one so that it has the correct name for your NewsGator_SocialServices database.
- Edit the USE statement in line 42 so that it has the correct name for your NewsGator_Reporting database.
- Execute the query.
- Navigate to the SQL_UPAMigrator folder and open the SQL_UpaMigratorBatch.sql file in SQL Server Management Studio.
- Edit the SQL_UpaMigratorAll.sql file and update
@SPUserProfileDB
with the name of the SharePoint Profile database. - Edit the SQL_UpaMigratorAll.sql and update
@NGServicesDB
with the name of the NewsGator_SocialServices database. - Edit SQL_UpaMigratorAll.sql and update
@NGReportingDB
with the name of the NewsGator_Reporting database. - Execute the query.
NOTE: Please be patient; this query takes a while to run. As a benchmark, it can run through around 6500 users in 30 minutes.
- Edit the SQL_UpaMigratorAll.sql file and update
- Navigate one level up to the folder where you unzipped the SQL_UPAMigratorAll.zip file and open the UPA_DROP_Indexes.sql file.
- Edit the USE statement in line one so that it has the correct name for your NewsGator_SocialServices database.
- Execute the query.