There are three steps involved when moving Spindle Document Management (SDM) from one server to another. The first step is backing up current data. The second step is moving the data. The final step is testing the application and ensuring it functions as expected.
Backing up components
There are four components to backup in SDM:
- SQL Database
- Archived Documents
- Configuration Data
- SpindlePro Folder
Ensure no SDM user is using the application before commencing with the back ups.
The SQL database is named Draycir.SDC. This database holds the metadata of the documents and displays it when searching for documents and capturing files from the Pending Tray/Document Portal. This database also holds the required data for Spindle Professional and Spindle Document Capture to integrate with each other. Back this database up using the SQL task (right-click > Back-up).
There are two locations where the archived documents are held. The path to the respective directories can be found in the Server Administration GUI which is typically installed on the server. Open up Server Administration > System Configuration > Archive Locations. This will display two paths for you to copy and paste into file explorer. Stop the SDC services. Once they've successfully been stopped, send both folders to individual compressed zip files. By default these folders are named Server Store and Protected Server Store. You'd then right-click Server Store > Send to > Compressed zip file and repeat this action with the Protected Server Store folder.
This folder holds the data for user roles, archive locations, SQL database information, client and server addresses and other data for SDC to remain configured as desired. To back this folder up, log on to the server and check 'show hidden files' within file explorer. Browse to the ProgramData folder (C:\ProgramData) > Draycir > Spindle Document Capture and repeat the above action (Send to compressed zip folder).
This folder holds the configuration for Spindle Document Distribution. To back this folder up, save the folder as a compressed zip file. Extract the contents of the folder in the new file location.
In order to simplify this guide, I'll name the two servers in play as box 1 and box 2. Check the version of SDM installed on box 1, both client and server versions. Note down the full version number, this is one of the very few times all digits matter. Differing build numbers for client and server applications have resulted in detrimental consequences.
Restoring the SQL database and data
Restore the database you just backed up in step on box 2. Thereafter, copy the compressed zip file which holds the Configuration data from box 1 to box 2. Unzip the file in the same directory (C:\ProgramData\Draycir\). Finally, unzip the files which hold the archive documents in their respective directories.
After restoring the data from box 1 to box 2, install the same version of SDM Server on box 2. Only install the SDM server, no client workstations are involved at this point. Once installed, open up the Server Administration application and click on Database Details. Ensure that the correct SQL server path is input and add the SQL. Test the connection.
Once that's working successfully, click on System Configuration and change the path to the path where the archived documents are held. As end sites and implementation consultants change this, this path can't be specified. By default: C:\ProgramData\Draycir\Spindle Document Capture\Data\Server Store\.
Re-point the client workstations
Jump on to each client workstation and using the server name or server IP address, point them to the new server. To do this, open up Client Administration (the application is found in the Draycir folder in the start menu) and click on Service Address. Enter the new server name/IP address and Set Service Address. Test the connection. Once it's successful, restart the machine.
To point users to the new SpindlePro folder path, open Spindle Document Distribution Tools and navigate to User Settings > Options and change the path in the 'Server / Configuration' text box and click Apply.
Testing the server move
The final step is to test that the application works as intended.
Open up Sage 200 and browse to any window that has the SDC buttons. Test the different functions such as capturing a file, printing a barcode and viewing linked documents.
Open up Document Search on the client machine and search for a document that you know exists in the system.
Pending Tray/Document Portal
Open up Pending Tray/Document Portal and scan a document in if possible. See if it picks up the barcode printer if there is one. An alternative would be to capture a file that resides virtually on the machine.
You may run into the following error messages during this process:
- Failed to find linked documents
- Failed to deserialize...
- Error 1920 during installation of SDC
- There was a problem validating your licence. Please see KBA-05-03-017 - There was a problem validating your licence for details.
- Login failures: Please ensure that the Windows User listed under Server Administration>Database Details matches the SQL Server Login and that it has dbOwner or dbDataRead and dbDataWrite roles assigned to it for the Draycir.sdc database.
Knowledge Base Article Details
|Related Product||Spindle Document Management|
|Original Author||Matthew Perry|
|Update Author||Matthew Perry|
|Keywords||Spindle Document Management, Server Move, Migration, Configuration|