# split nintex database in sharepoint - Link: https://sharepointtechnicalsupport.com/2020/08/21/split-nintex-database-in-sharepoint/ - Published: 2020-08-21T07:22:19+05:30 - Author: Deviprasad Panda split nintex database and [sharepoint content database](https://atomic-temporary-119393429.wpcomstaging.com/content-database-in-sharepoint/) for one to one mapping of nintex and sharepoint content databases. You must be not clear, what is split database ? When nintex workflow installed in default configuration, there will be one database containing all workflow data. By time workflow content grow high which will impact performance. So as to improve performance of workflow for sharepoint site containing nintex workflow, we can move nintex database from default all in one content database to a dedicated nintex database. Moving nintex database to dedicated content database from common db is called split database. Advertisements Below is the current condition of site collection and nintex database. ### Source/Old Details ```wp-block-code Site Collection : http://win-q2repghf9du/sites/SP2019 Site Collection Content Database (multiple site collections present) : WSS_Content_8888 Nintex Database : Nintex2019 Nintex Database Server : WIN-56R9D2TBFOB ``` Advertisements ### Destination/New Details ```wp-block-code Site Collection : http://win-q2repghf9du/sites/SP2019 Site Collection Content Database (Only 1 site collection) : WSS_Content_9999 Nintex Database : Nintex2019_SP2019 Nintex Database Server : WIN-56R9D2TBFOB ``` Advertisements Complete steps we will follow as below. * Create [New Content Database](https://atomic-temporary-119393429.wpcomstaging.com/create-add-a-content-database-in-sharepoint-2019/) * [Move site collection](https://atomic-temporary-119393429.wpcomstaging.com/move-site-collection-to-dedicate-content-database/) to dedicate content database * Create New Nintex Workflow Content Database * Add service accounts to Nintex Workflow Content Database * Map SharePoint Content Database to Nintex Workflow Content Database * Reacivate Nintex workflow [Site Collection feature](https://atomic-temporary-119393429.wpcomstaging.com/sharepoint-2019-feature-id-feature-using-powershell/) * nwadmin -o movedata Advertisements ## Create New Content Database * Add a content database in sharepoint under Manage Content Database option using central admin or [powershell](https://atomic-temporary-119393429.wpcomstaging.com/category/powershell-script/). ```wp-block-code New-SPContentDatabase "WSS_Content_9999" -DatabaseServer "WIN-56R9D2TBFOB" -WebApplication http://win-q2repghf9du -MaxSiteCount 1 -WarningSiteCount 0 ``` Advertisements follow the below post to get in detail information on creating new content database in SharePoint. [https://atomic-temporary-119393429.wpcomstaging.com/create-add-a-content-database-in-sharepoint-2019/](https://atomic-temporary-119393429.wpcomstaging.com/create-add-a-content-database-in-sharepoint-2019/) ## Map permission between content database Map or clone permission of new content database, same as the old content database(“ WSS_Content_8888” and “WSS_Content_9999”). Advertisements ## Move site collection to dedicate content database * move site collection to another content database using powershell command [Move-SPSite](https://docs.microsoft.com/en-us/powershell/module/sharepoint-server/move-spsite?view=sharepoint-ps). ```wp-block-code Move-SPSite "" -DestinationDatabase "" Move-SPSite "http://win-q2repghf9du/sites/SP2019" -DestinationDatabase "WSS_Content_9999" ``` Advertisements follow the complete process to move site collection to new content database from previous post link mentioned below. [https://atomic-temporary-119393429.wpcomstaging.com/move-site-collection-to-dedicate-content-database/](https://atomic-temporary-119393429.wpcomstaging.com/move-site-collection-to-dedicate-content-database/) Advertisements ## Create New Nintex Workflow Content Database * Navigate to central admin in SharePoint. * Click on “Nintex Workflow Management” from left navigation central admin. * Click on “Database setup” present under “Nintex Workflow Management”. * Click on “Add content database”. * Enter “Database Server”, “Database name”. * Keep the authentication as “Windows authentication”, default recommended option. * For the option “Service account access” under “Grant service account access”, select “Yes”. Advertisements ## Add service accounts to Nintex Workflow Content Database * When you will select option “Service account access” under “Grant service account access”, select “Yes”, nintex service accounts will be added to the newly created content database. * Make sure “App pool Account” has role “WSS_Content_Application_Pools” assigned in “[Database Permissions](https://docs.microsoft.com/en-us/sql/relational-databases/security/permissions-database-engine?view=sql-server-ver15)” for new nintex database “Nintex2019_SP2019”. * You can create ticket with db team for nintex database permissions mapping between old and new nintex databases. Advertisements ## Map SharePoint Content Database to Nintex Workflow Content Database Next step in nintex database mapping, we need to map the newly created content database or dedicated SharePoint site collection [content database](https://atomic-temporary-119393429.wpcomstaging.com/content-database-in-sharepoint/), with nintex workflow database created newly. Follow the steps by step procedure. * Click on “Database Setup” present under “Nintex Workflow Management”. * Click on “Manage database mappings”. * Identify the dedicated site collection content database, we created. you will find drop down option side to content database. Select the nintex workflow content database from drop down option for mapping site collection content db with nintex workflow db. * Click on “OK” to apply changes. * It will create a connection string. Advertisements ## Reacivate Nintex workflow Site Collection feature * Navigate to the site collection where workflow data is being moved. * Deactivate the nintex workflow site collection feature and reactivate. * Save the changes and perform an IISRESET. Advertisements ## nwadmin -o movedata use the command [MoveData ](https://help.nintex.com/en-US/nintex2016/sp2016/NWAdmin/MoveData.htm?TocPath=Administer%20%7CFarm%20administration%7CManage%20your%20farm%7CNWAdmin%20Guide%7COperations%7C_____28) to move nintex database to new database. * Stop App Pool for the web application “[http://win-q2repghf9du”](http://win-q2repghf9du”);. * [Stop SharePoint Administration and SharePoint Timer Service](https://atomic-temporary-119393429.wpcomstaging.com/start-stop-manage-services-windows-server-powershell/) in all servers in the farm. [https://atomic-temporary-119393429.wpcomstaging.com/start-stop-manage-services-windows-server-powershell/](https://atomic-temporary-119393429.wpcomstaging.com/start-stop-manage-services-windows-server-powershell/) Advertisements * Open sharepoint management console and type the below command to move the nintex database to the newly created nintex database. You need to pass powershell parameter GUID of site collection. Follow the post “[Get site collection GUID using powershell](https://atomic-temporary-119393429.wpcomstaging.com/move-site-collection-to-dedicate-content-database/)” to get siteid details. Run [nwadmin -o movedata](https://community.nintex.com/t5/How-To-s/Migrating-a-Site-or-Workflow/ta-p/83499), the details for which is below to [move nintex workflow data Into new database](https://community.nintex.com/t5/How-To-s/Moving-Nintex-Workflow-Data-Into-New-Database/ta-p/85928) ```wp-block-code NWAdmin.exe -o MoveData [-Url ] [-SiteID ] [-SourceDatabase ] [-TargetDatabase ] [-RetainSourceData] NWAdmin.exe -o MoveData [-Url ] [-SiteID ] [-SourceDatabase ] [-TargetDatabase ] [-RetainSourceData] NWAdmin.exe -o MoveData -Url http://win-q2repghf9du/sites/SP2019 -SiteID dhajdhhh-*******-*******-*******-******* -SourceDatabase "Data Source=WIN-56R9D2TBFOB;Initial Catalog=Nintex2019;Integrated Security=True" -TargetDatabase "Data Source=WIN-56R9D2TBFOB;Initial Catalog=Nintex2019_SP2019;Integrated Security=True" ``` Advertisements * After running the command nintex data will be moved to new nintex DB and you will get message in powershell window as below. ```wp-block-code Data will be moved for the site collection http://win-q2repghf9du/sites/SP2019 (site collection GUID). Restart each service to continue workflow operation. ``` * Restart App Pool for the web application “[http://win-q2repghf9du/”](http://win-q2repghf9du/”);. * Start SharePoint Administration and SharePoint Timer Service in all servers in the farm. * Deactivate the nintex workflow site collection feature and reactivate that make split database activity complete . Advertisements ## Similar Articles * [Nintex feature id in SharePoint](https://atomic-temporary-119393429.wpcomstaging.com/nintex-feature-id-in-sharepoint/) * [map crawled property to managed property sharepoint 2019](https://atomic-temporary-119393429.wpcomstaging.com/map-crawled-property-to-managed-property-sharepoint-2019/) * [move site collection to dedicate content database](https://atomic-temporary-119393429.wpcomstaging.com/move-site-collection-to-dedicate-content-database/) * [workflow could not update the item](https://atomic-temporary-119393429.wpcomstaging.com/sharepoint-workflow-could-not-update-the-item/) * [SharePoint 2013 Workflow Manager possible issues and fixes](https://atomic-temporary-119393429.wpcomstaging.com/sharepoint-2013-workflow-manager-possible-issues-and-fixes/) Advertisements Advertisements ### Share this: * [ X ](https://sharepointtechnicalsupport.com/2020/08/21/split-nintex-database-in-sharepoint/?share=twitter) * [ Facebook ](https://sharepointtechnicalsupport.com/2020/08/21/split-nintex-database-in-sharepoint/?share=facebook) * [ WhatsApp ](https://sharepointtechnicalsupport.com/2020/08/21/split-nintex-database-in-sharepoint/?share=jetpack-whatsapp) * [ Email ](https://sharepointtechnicalsupport.com/2020/08/21/split-nintex-database-in-sharepoint/?subject=%5BShared%20Post%5D%20split%20nintex%20database%20in%20sharepoint&body=https%3A%2F%2Fsharepointtechnicalsupport.com%2F2020%2F08%2F21%2Fsplit-nintex-database-in-sharepoint%2F&share=email) * [ Telegram ](https://sharepointtechnicalsupport.com/2020/08/21/split-nintex-database-in-sharepoint/?share=telegram) * [ LinkedIn ](https://sharepointtechnicalsupport.com/2020/08/21/split-nintex-database-in-sharepoint/?share=linkedin) * [ Tumblr ](https://sharepointtechnicalsupport.com/2020/08/21/split-nintex-database-in-sharepoint/?share=tumblr) * [ Pinterest ](https://sharepointtechnicalsupport.com/2020/08/21/split-nintex-database-in-sharepoint/?share=pinterest) ### Like this: Like Loading… ### _Related_