UPA Migrator production run

These instructions take you through the UPA migrator process to correct for miss-matched user RecordId’s between SharePoint and Aurea Social.

To perform a production run of the UPA migrator against all users:

1. Perform a SQL backup of the NewsGator Social Platform database and reporting database. The names of these databases can be found in SharePoint Central Administration> Application Management > Manage Service Applications. Click into the NewsGator Social Platform Services. At the bottom of the page, examine the connection string to find the database names.



The NewsGator Social DB is outlined in red, and the reporting in indigo

2. Perform a SQL backup of the SharePoint Profile database. The name of the SharePoint Profile DB can be found in SharePoint Central Administration > Application Management > Manage Service Applications. Click next to the User Profile Service application to bring up the ribbon controls, then click Properties in the ribbon.



The name of the Profile Database is outlined in red.

3. Prepare the UPA Migrator scripts:
1. Copy SQL_UPAMigratorall.zip to your SQL server or desktop. Right-click, choose properties, and click unblock, if applicable. Extract the .zip.
2. Navigate to the folder to which you unzipped SQL_UPAMigratorall.zip. Open the SQL_UpaMigator_Procs folder. Connect to the SQL instance using SQL Server Management Studio.
   1. Open in SQL Server Management Studio SQL_UpaMigrator_Services_Procs.sql. Execute it against the copy of the NewsGator Social DB you restored in step 3 above.
   2. Open in SQL Server Management Studio SQL_UpaMigrator_Reporting_Procs.sql. Execute it against the NewsGator_Reporting database you restored in step 3 above.
3. Navigate up one level to the folder which you unzipped SQLUPAMigratorAll.zip. Open in SQL Server Management Studio UPA_Indexes.sql. Edit the USE statement on line one so that it has the correct name for your restored NewsGator_SocialServices database. Edit the USE statement on line 42 so that it has the correct name for your restored NewsGator_Reporting database. Execute the query.
4. d. Navigate to the SQL_UPAMigrator folder. Open in SQL Server Management Studio SQL_UpaMigratorALL.sql.
   1. Edit SQL_UpaMigratorAll.sql and update @SPUSerProfileDB with the name of the SharePoint Profile DB you recorded in step 2 above.
   2. Edit SQL_UpaMigratorAll.sql and update @NGServicesDB with the name of the NewsGator_SocialServices database you recorded in step 1 above.
   3. Edit SQL_UpaMigratorAll.sql and update @NGReportingDB with the name of the NewsGator_Reporting database you recorded in step 1 above.
   4. Save changes to SQL_UpaMigratorALL.sql.
4. Prepare the NewsGator Social platform Services for data correction:

   In a web browser, navigate to SharePoint Central Administration > Application Management > Manage Service Applications. Click next to (but not on) the NewsGator Social Platform Services, which will provide access to the ribbon controls.

   1. Click on Administrators in the ribbon. Record all administrator users and their exact permissions.
   2. Click on Permissions in the ribbon. Record all users and their exact permissions.
5. Delete the NewsGator Social Platform Services service application. This will prevent data access while the UPA migrator performs ID correction.

   To delete the NewsGator Social Platform Services,

   1. Navigate to SharePoint Central Administration > Application Management > Manage Service Applications.
   2. Click next to (but not on) the NewsGator Social Platform Services, which provides access to the ribbon controls.
   3. Click Delete in the ribbon. When prompted to delete the associated data, DO NOT.
6. Execute the UPA Migrator.
1. Open in SQL Server Management studio SQL_UpaMigratorALL.sql, which was edited in step 3 d. above.
   1. Execute the Query. Please be patient, this query takes a while to run. As a benchmark, it can run through around 6500 users in 30 minutes. The test run executed earlier will also provide an estimate.
   2. Record any errors and share them with your Skyvera contact.
2. Navigate one level up to the folder which you unzipped SQL_UPAMigratorAll.zip.
   1. Open in SQL Server Management Studio UPA_DROP_Indexes.sql.
   2. Edit the USE statement on line one so that it has the correct name for your NewsGator_SocialServices database.
   3. Execute the query.
7. Re-create the Newsgator Social Platform Services service app. To do so,
   1. Navigate to SharePoint Central Administration > Application Management > Manage Service Applications.
   2. Click New in the ribbon and select the NewsGator Social Platform Services.
   3. Provide the correct application pool and supply the database names that you recorded in step 1 above.