Skip to main content
Search Again

We think these articles could help you:

    See More
    Nintex Knowledge Base

    Moving Nintex Workflow Data Into New Database

    Summary
    How to move or split workflow information to a new content database.

    Solution
    1. Sign into one of the SharePoint servers with a farm account (account that has full access to each workflow database). If needed create the new database where workflow data will be moved.
    2. Backup databases involved in data move.
    3. Collect the full connection strings for both the "source database" and the "target database". For example: Data Source=MyDatabaseServerName;Initial Catalog=MyDatabaseName;Integrated Security=True
    4. Navigate to Nintex Workflow Management > Database Setup > Manage database mappings.
    5. Update the database mapping so that it reflects the new database configuration.
    6. Navigate to the site collection where workflow data is being moved.
    7. De-activate/re-activate the Nintex Workflow Site Collection features to update the database mapping.
    8. Stop the Workflow Timer Service within the SharePoint farm.
    9. Stop the IIS Site where workflow data is being moved.
    10. Open a SharePoint Management Shell and run the following command:
      NWAdmin.exe -o MoveData -Url <siteCollectionUrl> -SourceDatabase <connection string> -TargetDatabase <connection string>
    For example: NWAdmin.exe -o MoveData -Url http://workflow2013testing.nintexsupport.com -SourceDatabase "Data Source=WorkflowDatabaseServer;Initial Catalog=NintexConfigurationDatabase;Integrated Security=True" -TargetDatabase "Data Source=WorkflowDatabaseServer;Initial Catalog=NintexContentDatabase2;Integrated Security=True" 
    1. Start the IIS site and Workflow Timer Service again.
    Note: After the data is moved, the source content database must remain in place until the redirects added by the MoveData operation have been cleaned up. To clean up redirects, use the CleanTaskDirects operation.

    For more information on using NWAdmin, see the Nintex NWAdmin Operations Guide.
    • Was this article helpful?