20.1 Preparing to Move the Data

Before migrating the data from the Sybase database to the MS SQL database, do the following:

  • Ensure that the license state of ZENworks is Active. The product must be installed and running either in the licensed version or the evaluation version.

  • Ensure that the Primary Server to which the Sybase database is configured has been upgraded to ZENworks.

  • Ensure that the MS SQL database is installed on a device that does not have ZENworks installed.

  • (Conditional) If you want to create a new database on MS SQL 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 the data to an existing database that resides on the MS SQL 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.

    • On Windows:

      1. Execute the following command at the server prompt:

        novell-zenworks-configure -c Start

      2. Enter the number next to the Stop action.

    • On Linux:

      1. Execute the following command at the server prompt:

        /opt/novell/zenworks/bin/novell-zenworks-configure -c Start

      2. Enter the number next to the Stop action.

  • Ensure that the Novell ZENworks Embedded Datastore service on the Primary Server is running.

    • On Windows:

      1. From the Windows desktop Start menu, click Settings > Control Panel.

      2. Double-click Administrative Tools > Services.

      3. Ensure that the status of the Novell ZENworks Embedded Datastore service is Started.

    • On Linux: At the console prompt, enter

      • /etc/init.d/sybase-asa status on SLES 11.

      • systemctl status sybase-asa.service on SLES 12.

  • Ensure that the Novell ZENworks Embedded Datastore for auditing service on the Primary Server is running.

    • On Windows:

      1. From the Windows desktop Start menu, click Settings > Control Panel.

      2. Double-click Administrative Tools > Services.

      3. Ensure that the status of the Novell ZENworks Embedded Datastore For Auditing service is Started.

    • On Linux: At the console prompt, enter

      • /etc/init.d/sybase-audit-asa status on SLES 11.

      • systemctl status sybase-audit-asa.service on SLES 12.

  • (Optional) The status of database migration is logged into the novell-zenworks-configure.log file. By default, only the messages of the type Info and Severe are logged. If you want other message types (such as Finer, Finest, and Warning) to also be logged into the file, do the following in the novell-zenworks-configure.properties file:

    1. 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

    2. 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.