30.4 Moving the Data from an External OEM Sybase Database to an Embedded Sybase Database

ZENworks 11 allows you move the data from an OEM Sybase database (external Sybase database) to a Embedded OEM Sybase SQL Anywhere database (embedded Sybase database) that is installed on the ZENworks Server.

30.4.1 Preparing to Move the Data

Before moving the data from an external Sybase database to an embedded Sybase database, do the following:

Make sure that ZENworks 11 is configured to an external OEM Sybase database. The database can be installed on a Windows or Linux device.
Install the Embedded OEM Sybase database on the ZENworks Server.

For more information on how to install the database, see Installing an External ZENworks Database in the ZENworks 11 Server Installation Guide.

During the installation of the embedded Sybase database, you must consider the following points while the Sybase Access Configuration page:
- The database name can be same as that of the external Sybase database or can be a unique name.
- Make sure that the username and password are same as that of the external Sybase database.
- Make sure that the database server name is unique.

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

Stop all the ZENworks Services on the all the ZENworks Servers in the Management Zone.
- On Windows: Do the following
  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: Do the following:
  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.
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.
On the device that has the external Sybase database installed, stop the Novell ZENworks Embedded Datastore service.
- On Windows: Do 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 on the toolbar.
- On Linux: At the console prompt, enter /etc/init.d/sybase-asa stop.
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.
On the ZENworks Server that has the embedded Sybase database installed, open zenworks_database.conf and make sure that it contains the correct path of the database file.
On the ZENworks Server that has the embedded Sybase database installed, edit zdm.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).
- Make sure 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.
Start all the ZENworks Services on the all the ZENworks Servers in the Management Zone.
- On Windows: Do the following
  1. Execute the following command at the server prompt:
    
    novell-zenworks-configure -c Start
  2. Enter the number next to the Start action.
- On Linux: Do the following:
  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 Start action.

The ZENworks Server now points to new database.