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

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

Restore them to new databases with new names (for example, you could use _TEST appended to the restored DB’s names).

DO NOT overwrite your in-use DB’s with these backups. Record the names of the new DB’s with the restored data.

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. avigate 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 restored in step 3 above.
   2. Edit SQL_UpaMigratorAll.sql and update @NGServicesDB with the name of the NewsGator_SocialServices database you restored in step 3 above.
   3. Edit SQL_UpaMigratorAll.sql and update @NGReportingDB with the name of the NewsGator_Reporting database. you restored in step 3 above.
   4. 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.
   5. Once the query is complete, record the time it took to execute. This provides a benchmark for how long it takes to run against the in-use databases.
   6. Record any errors and share them with your Skyvera contact.
5. Navigate one level up to the folder which you unzipped SQL_UPAMigratorAll.zip. Open in SQL Server Management Studio UPA_DROP_Indexes.sql.

   Edit the USE statement on line one so that it has the correct name for your restored NewsGator_SocialServices database. Execute the query.