Introduction

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.

SQL Database

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).

Archived Documents

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.

Configuration Data

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).

SpindlePro 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.

Moving Servers

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.

Installing SDM

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\.

Opening Ports

In order for the client workstations to interact with SDM server once re-pointed (see below). Please ensure that exceptions in the firewall are present for TCP ports 34251-34257, inbound and outbound.

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.

Sage 200

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.

Document Search

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.

Error Messages

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