Use an existing configuration database

This topic provides instructions for using an existing configuration database.

To use an existing configuration database

1. In the previous SharePoint 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 Subscription Edition 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 Subscription Edition environment, do the following.

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

      Note: This step is not necessary if your and new and previous SharePoint 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.