15.3 Post-Migration Tasks

If there is only one server in the Management Zone, all ZENworks services are automatically started after the data is successfully migrated to an MS SQL Server database.

If there are multiple servers in the Management Zone:

  1. On the device where you ran the migration utility, copy the following files to the appropriate directory on all the servers:

    • zdm.xml
    • dmaccounts.properties
    • dmmappings.properties

    The files are located in the %ZENWORKS_HOME%\conf\datamodel directory on Windows and in the /etc/opt/novell/zenworks/datamodel directory on Linux.

  2. Start all the ZENworks Services 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 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 the new database.

NOTE:Ensure not to delete the ZENworks Sybase database files if you want to revert to using ZENworks Sybase database at a later time.

15.3.1 Configuring a migrated MS SQL database on a device that has ZENworks Reporting Server installed

  1. Open the jdbc.sbo file from the following location:

    • On Windows: <zenworks_home>\share\boe\BusinessObjects Enterprise 12.0\win32_x86\dataAccess\connectionServer\jdbc

    • On Linux: /opt/novell/zenworks/share/boe/bobje/enterprise120/linux_x86/dataAccess/RDBMS/connectionServer/jdbc

  2. Locate the MS SQL Server 2008 database tag and add the following content below the JDBCDriver tag:

    • On Windows: 

      <ClassPath>
<Path>[zenworks_home]\share\boe-publish\drivers\jdbc\mssql\sqljdbc.jar</Path>
</ClassPath>

    • On Linux: 

      <ClassPath>
<Path>/opt/novell/zenworks/share/boe-publish/drivers/jdbc/mssql/sqljdbc.jar</Path> 
</ClassPath>

  3. After you modify the jdbc.sbo file, restart the BusinessObjects Enterprise services.

  4. After the BusinessObjects Enterprise services have been restarted, run the following command:

    novell-zenworks-configure -c UpdateBOE

  5. Update BusinessObjects Enterprise from the <Zenworks_home>\bin folder.