Views:
Important Note:
Moving a DocuWare Internal Database can be a complex process that can be even more difficult in the case of different constellations, schema of databases, and operating systems. This process requires a deep technical understanding of DocuWare. If you are in need of assistance from DocuWare Support, we can offer this on a time and material basis only. In this case, we recommend that you contact our Professional Services department in advance of such a project by sending an email to professional.services.emea@docuware.com  or professional.services.americas@docuware.com

Question:
How can I move only the internal database for my DocuWare system to another server?
 
Solution:
Please refer to the following steps to move your internal database to another server.
***Note: It is vital to create a backup of your current internal database. Take a backup of all DocuWare databases before beginning this process.***
 
1. Install the same version of DocuWare on the new server by running the DocuWare Server Setup. All installation files for DocuWare versions 7 or higher can be found here: DocuWare Setups, Updates & Hotfixes.

2. Once completed, stop the DocuWare services except for the Internal Database.
 
3. In MySQL Workbench, drop the new databases and restore the old databases from the backup taken before beginning this process.

4. In the database, Run the following command to select all from the DWServer table, and take note of the DocuWare Server GUIDs listed there:

SELECT * FROM [dwsystem].[dbo].[DWServer]


5. Open a text editing program as an administrator and then open each DocuWare Server's settings file from the C:\Program Files (x86)\DocuWare and change the ServerGuid to match the corresponding GUID from the last step.
The following settings files would need to be adjusted;
Note: Notification Server has been discontinued in DocuWare version 7.4 or higher. Changes will only need to be made to the Authentication and Workflow Servers.

DWAuthenicationServer.exe.settings
DWWorkflowServer.exe.settings
DWNotificationServer.exe.settings (applicable to DocuWare versions 7.3 and below)

 
6. Modify the dwserver table and the database connections in dwsystemsettings. You can do that with the following script:
***Note: Alter the 'NewMachineName' and 'OldMachineName' accordingly, as well as 'NewDomainName' and 'OldDomainName'.***

set @NewMachineName =  'NewMachineName';
set @OldMachineName = 'OldMachineName';
set @NewDomainName =  'NewDomainName';
set @OldDomainName = 'OldDomainName';
 
#update the server name in the database connections
UPDATE dwsystem.dwsystemsettings
SET settings = replace(settings, @OldMachineName, @NewMachineName)
WHERE type LIKE '%databaseconnection%'
AND (
    settings LIKE '%<Database>dwsystem</Database>%'
    OR settings LIKE '%<Database>dwdata</Database>%'
    OR settings LIKE '%<Database>dwnotification</Database>%'
    OR settings LIKE '%<Database>dwlogging</Database>%'
    OR settings LIKE '%<Database>dwloggingbackup</Database>%'
    OR settings LIKE '%<Database>dwworkflowengine</Database>%'
    OR settings LIKE '%<Database>dwthumbnail</Database>%'
);

#update the machine name in the 'settings' column in the dwserver table
UPDATE dwsystem.dwserver
SET settings = REPLACE(settings, @OldMachineName, @NewMachineName);

#update the machine name in the 'name' column in the dwserver table
UPDATE dwsystem.dwserver
SET name = REPLACE(name, @OldMachineName, @NewMachineName);

#update the machine name in the 'connection' column in the dwserver table
UPDATE dwsystem.dwserver
SET connection = REPLACE(connection, @OldMachineName, @NewMachineName);

#update the machine name in the 'machine_name' column in the dwserver table
UPDATE dwsystem.dwserver
SET machine_name = REPLACE(machine_name, @OldMachineName, @NewMachineName);

#update the domain in the 'domain' column in the dwserver table
UPDATE dwsystem.dwserver
SET domain = REPLACE(domain, @OldDomainName, @NewDomainName);

 
7. Lastly, recreate the DocuWare System User using the steps listed in KBA-36277 and restart your DocuWare Services.
 
KBA is applicable for On-premise Organizations ONLY.
This article is valid for DocuWare versions: All DocuWare Versions | Migration