Tuesday, October 16, 2012

How to Move or Connect to an existing Nintex database

There are times when we might have to move/connect to the Nintex database

1. when there is  a hardware update or server upgrade - we have to move the Nintex database
2. when we need to reuse a Nintex database - we reconnect to an existing Nintex database

Moving the Nintex Workflow Database

1. Login to the SQL Management studio where the current Nintex dayabase is present.And performa back up of the Nintex database (Right click on your Nintex database ->Tasks->Back Up).Click OK on the next screen.

This saves a backup of the NW2007DB to the default directory of "C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Backup\" under the filename NW2007DB.bak.

2. On the server where I am copying the Nintex Workflow database to,I copied the backup file
 NW2007DB.bak file to the directory "C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Backup\"

 3.From the SQL , right click on Databases and Restore Database

On From device and then specify File -> Add .Browse for the backed up file NW2007DB.bak.
Click OK.Make sure that the To Database name is NW2007DB

The database is now moved to the new server and is ready to be connected to by Nintex Workflow.

Reconnecting to the existing Nintex Workflow database

Step 1 - Connect the new configuration database

1. In Central Administration,under Application Management ->Nintex Workflow Management ->Database Setup

2. Below Configuration Database,click Edit.

3. Enter the new details and choose Connect to existing database.Click OK.

Step 2 - Update the references to the content databases

1. From the database management screen, you will see that the content databases still point to the old server.
2. On the server where you installed the Nintex Workflow 2007 msi, open a command prompt window.
3. Change Directory to the directory in which you installed Nintex Workflow.

By default:
On a 32bit environment - C:\program files\nintex\nintex workflow 2007
On a 64bit environment - C:\program files (x86)\nintex\nintex workflow 2007

4. Restart IIS and the Windows SharePoint timer service .
5. Check the database management page again, the content database references should be up to date.

Note : If for some reason you need to manage the content database servers manually, you can also do so by modifying the database directly. This has the same effect as running the NWAdmin command.
1. Open the configuration database in your database management tool.
2. Open the table called “databases”.
3. You will see the content database details listed. You can update the Server name column as required and submit the change.

Restart IIS and the Windows SharePoint timer service from services.msc and the process should be complete.

1 comment:

  1. Hi,
    does these steps above preserve the nintex woirkflow history on Destination server ? i mean can i still go into destination server and click on the "view workflow history" link and see the WF history of the completed WF on the destination server same as i was seeing in source server ?