SDC Server Move
There are three steps involved when moving SDC 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 three components to backup in SDC:
- SQL Database
- Archived Documents
- Configuration Data
Ensure no SDC 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. 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).
In order to simplify this guide, I'll name the two servers in play as box 1 and box 2. Check the version of SDC 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 SDC Server on box 2. Only install the SDC server, no client workstations are involved at this point. Once installed, open up the Server Administration application and click on the top most button (Server Configuration). Enter the SQL instance and credentials there. 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.
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.
Open up Pending Tray 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
- 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.
Contact the Draycir Support team and we'll troubleshoot this as best we can.
Knowledge Base Article Details
||Spindle Document Capture
||Spindle Document Capture, Server Move, Migration, Configuration