Before migrating the data from the Sybase database to the PostgreSQL database:
Ensure that the license state of ZENworks is Active. The product must be installed and running either in the licensed mode or the evaluation mode.
Ensure that the Primary Server has been upgraded.
Ensure that the PostgreSQL database is installed on a device on which ZENworks is not installed.
(Conditional) If you want to create a new database on the PostgreSQL server, and migrate the Sybase data into the new database, you must be aware of the database administrator credentials.
(Conditional) If you want to migrate data to an existing database that resides on the PostgreSQL server in your network, the newly created user must be assigned the db_owner database role and you must procure the database credentials of the newly created user from the database administrator.
Manually stop the ZENworks services running on all other ZENworks Servers in the Management Zone. For more information, see Step 2.a in the Backing Up the Embedded Sybase SQL Anywhere Database on a Windows or Linux Server.
Ensure that the external Sybase service is running.
(Optional) The status of database migration is logged in the novell-zenworks-configure.log file. By default, only the Info and Severe type messages are logged. If you want other message types (such as Finer, Finest, and Warning) to be logged in the file, do the following in the novell-zenworks-configure.properties file:
Set the value of Logger.logLevel to the appropriate message type.
For example, if you want messages of the type Finest to be logged:
#Logger.logLevel = FINEST
Uncomment the line by removing the “#” as follows:
Logger.logLevel = FINEST
The novell-zenworks-configure.properties file is located in %ZENWORKS_HOME%\conf\ on Windows and in /etc/opt/novell/zenworks/ on Linux.