7.3 Converting to Microsoft SQL Server
If you configured the ZENworks Handheld Management Server to use the internal ODBC-compatible database, you can upgrade to a Microsoft* SQL Server database if you have Microsoft SQL Server installed.
To convert the internal ODBC-compatible database to Microsoft SQL Server:
-
The ZENworks Handheld Management Server machine must be able to access the Microsoft SQL Server machine on the network.
-
The person logged in when running the SQL conversion tool must have a server role of System Administrator to convert the database.
After the database is successfully upgraded, the System Administrator permission can be removed. The ZENworks Handheld Management Server user and the user running the ZENworks Handheld Management console just need database access of db_datareader and db_datawriter.
To convert the database to Microsoft SQL Server:
-
Use either Windows Explorer or the command prompt on the ZENworks Handheld Management installation machine to access the ZENworks Handheld Management Server installation directory.
-
From the installation directory, run sqlconv.exe (by default, in program files\novell\zfh) to open the SQL Server Converter wizard.
-
Click .
-
Type the name of the machine where Microsoft SQL Server is installed, then click .
-
Type the name you want to assign to the ZENworks Handheld Management database when it is created in SQL, then click .
This page shows the name of the SQL Server machine and the name you are assigning to the database.
-
Click to convert your current ZENworks Handheld Management database to an SQL Server database.
The time it takes for the database conversion depends on the size of the database and number of records to process.