Novell Doc: ZENworks 11 SP2 Database Management Reference - Preparing to Move the Data

7.1 Preparing to Move the Data

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

Make sure that the license state of ZENworks 11is Active. The product must be installed and running either in the licensed version or the evaluation version.
Save all the reports, rights.xml, and ownership.xml by using the zman report-save (rpsv) (destination folder)command. The XML files contain rights and ownership details of all the reports.
Make sure that the Primary Server to which the Sybase database is configured has been upgraded to ZENworks 11.
Make sure that the ZENworks Primary Server has an internal Sybase database installed.
Make sure that the MS SQL database is installed on a device that does not have ZENworks 11 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 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 Stop
  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 Stop
  2. Enter the number next to the Stop action.
Make sure that the Novell ZENworks Embedded Datastore service on the Primary Server is running.
- On Windows: Do the following:
  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.
(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.