Use an existing configuration database

This topic provides instructions for using an existing configuration database.

To use an existing configuration database

1. In the SharePoint 2013 environment, do the following.

   1. Stop the Windows SharePoint Services Timer service.

      1. Open the Services Microsoft Management Console (MMC) snap-in.

         Note: For instructions on accessing the Services Microsoft Management Console (MMC) snap-in, see the Microsoft TechNet Library at http://technet.microsoft.com/en-us/library/cc772408.aspx.

      2. Right-click the Windows SharePoint Services Timer service and select Stop.

   2. Backup the database using Microsoft SQL Server Management Studio.

   3. Start the Windows SharePoint Services Timer service.

      1. Open the Services Microsoft Management Console (MMC) snap-in.

         Note: For instructions on accessing the Services Microsoft Management Console (MMC) snap-in, see the Microsoft TechNet Library at http://technet.microsoft.com/en-us/library/cc772408.aspx.

      2. Right-click the Windows SharePoint Services Timer service and select Start.

   4. Restore the backed up database to the SharePoint 2013 location using Microsoft SQL Server Management Studio.

   5. Execute the “_PrepareForNewEnvironment” stored procedure to delete existing references to content databases and Nintex Live service requests.

      These references are re-added as needed when existing content databases are reattached.

      1. In Microsoft SQL Server Management Studio, in Object Explorer, expand Databases.

      2. Expand the database, expand Programmability, and then expand Stored Procedures.

      3. Right-click stored procedure “_PrepareForNewEnvironment” and select Execute Stored Procedure.

      4. In the Execute Procedure dialog box, click OK.

         Note: For more information about executing stored procedures in Microsoft SQL Server Management Studio, see the following Microsoft article: Execute a Stored Procedure.

2. In the SharePoint 2016 environment, do the following.

   1. Migrate (or backup and restore) the prepared database to the SharePoint 2016 SQL instance.

      Note: This step is not necessary if your SharePoint 2016 and SharePoint 2013 environments share the same SQL instance.

   2. Configure Nintex Workflow to use the prepared database as its configuration database.

      1. On the Central Administration Home page, click Nintex Administration.

      2. Under Licensing and setup, click Database management.

      3. Under Nintex Workflow, under Configuration database, click Create.

      4. On the Create configuration database page, enter the name of your database server and existing configuration database name.

      5. Select the check box Connect to an existing database.

      6. Click OK.