15.2 Moving the Data from the External Sybase to the Embedded Sybase

  1. Stop the ZENworks services on the 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.

  2. On the ZENworks Server that has the embedded Sybase database installed, delete the contents of the database directory.

    The database directory is located in ZENworks_installation_path on Windows and in the /opt/novell/zenworks/ directory on Linux.

  3. On the device that has the external Sybase database installed, stop the Novell ZENworks Embedded Datastore service.

    • On Windows: Perform the following:

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

      2. Double-click Administrative Tools > Services.

      3. Right-click the Novell ZENworks Embedded Datastore service, then click Stop, or select the Novell ZENworks Embedded Datastore service, then click Stop icon on the toolbar.

    • On Linux: At the console prompt, enter

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

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

  4. From the device that has the external Sybase database installed, copy all files within the database directory to the appropriate directories on the ZENworks Server that has the embedded Sybase database.

    The database directory is located in ZENworks_installation_path on Windows and in the /opt/novell/zenworks/ directory on Linux.

  5. On the ZENworks Server that has the embedded Sybase database installed, open zenworks_database.conf and ensure that it contains the correct path of the database file.

  6. On the ZENworks Server that has the embedded Sybase database installed, edit zdm.xml and zenaudit.xml (located in ZENworks_installation_path\conf\datamodel on Windows and in /etc/opt/novell/zenworks/datamodel on Linux):

    • Add the following entry:

      <entry key="Embedded">true</entry>

    • Set the value of the Server entry key to 127.0.0.1 (the IP address of the ZENworks Server that has the embedded Sybase database installed).

    • Ensure that the value of the Port entry key is the port number on which the embedded Sybase database is running.

    • Set the value of the Engine entry key to the database server name specified during the installation of the embedded Sybase database.

    • (Optional) If you’ve specified a unique database name during the installation of the embedded Sybase database, set the value of the Database entry key to the unique database name.

  7. Start the ZENworks services on the ZENworks Servers in the Management Zone. For more information, see Step 2.c in the Backing Up the Embedded Sybase SQL Anywhere Database on a Windows or Linux Server.

The ZENworks Server now points to new database.