Before migrating data to the new MS SQL database, ensure that its version matches the source database.
Stop the ZENworks services on all the ZENworks Primary Servers in the Management Zone.
On the Primary Server:
Execute the following command at the server prompt:
microfocus-zenworks-configure -c Start
Enter the number next to the Stop action.
Ensure that MSDB2 is installed with the same database credentials as the MSDB1, assuming that the device that currently host the MS MQL database is called MSDB1 and the new MS SQL database device is called MSDB2.
Move the data from MSDB1 to MSDB2. For more information about moving the data, see the MS SQL database documentation.
Once the data migration is completed, perform the following actions on all the Primary Servers in the Management Zone in order to configure the ZENworks Primary Server to point to the new MS SQL database (MSDB2).
Take back up, and edit the zdm.xml and edit zenaudit.xml files (located in /etc/opt/microfocus/zenworks/datamodel), and amedatasource.properties (located in /etc/opt/microfocus/zenworks/antimalware.
Edit the datamodel configuration files to point to the MSDB2
Update the value for key 'Jdbc_Url' with the JDBC URL pointing to MSDB2 in zdm.xml and zenaudit.xml for ZENworks and audit databases respectively.
(Conditional) If you have antimalware enabled, update the value for the key 'database.jdbc.url' with the JDBC URL pointing to MSDB2 in the amedatasource.properties file for antimalware database.
Execute the following configure actions:
microfocus-zenworks-configure -c GenerateOSPProperties
microfocus-zenworks-configure -c GenerateContentDatasourceConfigureAction
Start the ZENworks services on all the Primary Servers in the Management Zone.
On the Primary Server:
Execute the following command at the server prompt:
microfocus-zenworks-configure -c Start
Enter the number next to the Start action.
ZENworks Primary Servers should now point to the new database.