Splitting Nintex Database after Migration

To split a Nintex content database to enable one-to-one content for each, please follow below steps

1. Create a new Nintex Workflow content database.

• Access the Database management page: On the Central Administration Home page, click Nintex Administration and then click Database management under Licensing and setup.
  
  
• Click Add and then specify the details.
  
  

     2. Log in to the SQL Server and ensure that all necessary service accounts are added to the newly created Nintex database. To add a service account:

• Open SQL Server Management Studio.
• Expand the new Nintex content database.
• Expand the Security folder.
• Right-click the Users folder and select New user.
• Enter a display name for the user then the login name.
• From the Role Member section select “WSS_Content_Application_Pool”.
• Save the changes and perform an IISRESET.
  
  

     3. Stop the web application that contains the content database being split by stopping the IIS site mapped to the web application.

       

     4. Stop all instances of the SharePoint Timer Service wherever they exist for the entire farm.

        

     5. To move SharePoint content from an existing content database to another database, use Windows PowerShell Move-SPSite.

Command --

                      NWAdmin.exe -o movedata - URL "<SharePoint 2013 Application URL>"

       

     6. Run nwadmin -o movedata, the detail for which is below.

     

     7. Restart the web application, the IIS site, and all instances of the SharePoint Timer Service in the farm.

_{Steps for testing the DB after Splitting.}

1.  Open SQL Server Management Studio
2.  Expand the new Nintex Content Database
3. Expand the Tables menu
4. Right click on the dbo.Workflows table and click on 'Select Top 1000 Rows'
   
5. As a result, we will be seeing some data against the query