PREREQUISITES

1) Administrator rights on Enterprise Manager and SDMS 
2) Administrator rights on SDMS Server (both source and destination servers)
3) Adequate downtime ( so new versions aren't missed ) 
4) SDMS Meta Database details (Click here to determine the SDMS meta database details)
5) Read permissions to the SDMS meta database ( possibly write if the physical storage of documents will differ on the servers)

RESOLUTION

1. Connect to the meta database and execute 'Select * from SDMDOCREVISIONS' and look for the value in Pathname. This indicates the physical location of the encrypted documents on the SDMS application server. If you are unsure of which database SDMS points to, click here. Left to installer defaults, this location is usually : 

     C:\Program Files (x86)\Dell (or Statsoft or Statistica) \SDMS\Data\Documents

2. Copy the contents of the above directory to the new server

3. Start downtime and disable SDMS integration from Enterprise Manager | System Options | SDMS Integration 

4. Install SDMS on the new server and point it to the same meta database. Click here for details on how to determine SDMS meta database.

     Note: If the path revealed in Step 1 was non default, choose Custom installation and change the path to the same path on the new server and skip to step 7. If you are unable to install to the same location as on the old server, continue with the below steps. 

5. After installation, locate the folder SDMS was installed to, and copy documents from Step 2 to the \Data\Documents folder on the new server

6. If the location on the old server and new SDMS server are the same, skip this step. If not, connect to the meta database with write permissions on the database and execute a statement to update SDMDOCREVISIONS to point to the new location of documents on the server. 

For instance: Update SDMDOCREVISIONS set pathname=Replace(PathName,'e:\','c:\')

7. Log back into Enterprise Manager and enable SDMS integration and update the server URL to point to the correct server.  If this is blank, type the URL in the below format replacing the SDMS Server name

       https://SDMSServerName:80/SDMS/SDMSSOAPServer.dll?Handler=Default

8. If fallback authentication is enabled, make sure that the credentials for fallback are typed correctly. Commit this change.  SDMS Server migration is complete.