RecordPoint Database Migration to New SharePoint Farm

This topic covers how to backup an existing RecordPoint environment and restore it onto a new farm which does not have RecordPoint installed. To restore it onto a different farm already using RecordPoint instead, click here.

Steps for the Existing RecordPoint Environment:

Identify and Backup Content Databases

  1. Navigate to Central Admin

  2. Application Management

  3. Manage content databases. Identify which content databases need to be backed up for both RecordPoint and your active site(s):

    1. Active Site Databases - select the web application(s) for the active site(s). Each listed database will need to be backed up.

    2. RecordPoint Databases - select the web application for RecordPoint. Each listed database will need to be backed up (there will be a minimum of three databases here).

The only supported method to backup and restore databases of a RecordPoint environment is through SQL Server Management Studio. Follow the steps under "Use SQL Server Tools..." from this article and backup your databases. These backup files will then need to be copied somewhere accessible by the SQL Server Management Studio of the Target Farm.

Identify Ports and URLs

  1. Navigate to Central Admin

  2. Application Management

  3. Manage web applications.

Make a note of the ports and URLs used in your RecordPoint and Active site web applications. These will be needed when creating the web applications in the new farm. 

Export the Term Set

Use the script found here to export the RecordPoint Term Set in your Managed Metadata Service. This file will need to be copied into the new farm.

Export RecordPoint Rules

  1. Navigate to your RecordPoint Site

  2. Management

  3. Rule Settings

  4. Click Export Rules. This file will need to be copied into the new farm.

Steps for the New Farm:

Restore Databases on the New Farm

Follow the steps under "Use SQL Server Tools..." from this article and restore each of your databases from step 1. When specifying the Source, select "Device" and choose a backup file. Give the Destination Database a new name only if a database with the backup source's name already exists - otherwise, keep the default value.

Setup Installation Prerequisites

If you are using SharePoint 2013, click here to view the prerequisites. For SharePoint 2016, click here.

SharePoint Setup

Follow the steps outlined here to setup SharePoint.

  • When creating the web applications for RecordPoint and the Active Sites, use the same ports and URLs noted in step 2. Keep the default database. 

  • In this scenario, do not create a site collection for the Active web application.

Import the Term Set

  1. Navigate to the new Managed Metadata Service.

  2. Create a new Term Group titled "RecordPoint" then import the Term Set CSV file generated in step 3 into this group.

RecordPoint Installation

Follow the steps up to and including "Local Deployment" listed here (but skip "License RecordPoint..." since a new license will not be needed). Do NOT perform "Content Deployment."

Remove and Attach Databases

  1. Navigate to Central Admin > Application Management > Manage content databases. 

    1. Active Site Databases - select the web application(s) for the active site(s) and remove each existing database. Add the Active Site databases that were restored in step 5.

    2. RecordPoint Databases - select the web application for RecordPoint and remove each existing database. Add the RecordPoint databases that were restored in step 5.

  2. Perform an IIS reset and restart the SharePoint Timer Job Service on all servers.

Add Timer Jobs to RecordPoint and Active Sites

  1. Navigate to Central Admin

  2. Application Management

  3. RecordPoint Deployment and Configuration

  4. Configuration. The timer jobs will be added by disabling then re-enabling certain features here.

  5. Select the RecordPoint web application and site, check "Show Administrative Components" and click OK.

  6. Uncheck the following features then click Update:

    1. Connectors

    2. RecordPoint Daily Tasks Infrastructure

    3. RecordPoint Disposal Infrastructure

    4. RecordPoint Generic Tasks Infrastructure

    5. RecordPoint Queueing Infrastructure

    6. RecordPoint System Monitor

  7. After the results show that the above features have been disabled, recheck these features and click Update again. When they have been enabled, click Next.

  8. Select the Active web application and site, check "Show Administrative Components" and click OK. Uncheck the following features then click Update:

    1. RecordPoint Active Daily Tasks Infrastructure

    2. RecordPoint Active System Monitor

    3. RecordPoint Queueing Infrastructure Active Site

  9. After the results show that the above features have been disabled, recheck these features and click Update again. When they have been enabled, repeat this process for each Active site collection as needed. Click Finish when done.

Steps for the RecordPoint Site:

Using a farm account, navigate to your RecordPoint site and perform the following:

Update Term Store Selections

Navigate to Management > Pack Settings.

  • Under "Select the Transfer Standard...", there may be fields that reflect the VERS standard despite it not being selected. If this is the case, in the dropdown you can click "VERS" and then click "Select .." again to make the fields disappear. 

  • Select the proper Term Store/Group/Set and click Update.

Import RecordPoint Rules

  1. Navigate to Management

  2. Rule Settings

  3. Browse for the rules file exported in step 4 and click Import Rules.

  4. Keep "Delete all rules prior to import" checked. This is needed to repopulate the outcomes with the proper classifications.

The account being used for this step must be an administrator with full control over the search and managed metadata services. 

  1. Navigate to Management

  2. Search Settings.

  3. Choose the proper Search Application and click Update.

  4. Click Initialise. If you had to update the Search Application above, then you may need to refresh the page in order to click this. Note that this will run two full crawls.

 Once all steps have been completed successfully, RecordPoint will be ready for use in your new environment.