The ZfD3 Database Migration tool migrates the existing inventory information from a ZfD2 database to a ZfD3 database.
IMPORTANT: ZfD2 application reports are not migrated to ZfD3. The data and formatting required for ZfD3 application reports has changed completely.
To configure the inventory data migration:
Open the DBMIGRATE.NCF file in the NetWare server's SYS:\SYSTEM directory or the DBMIGRATE.BAT file in the Windows NT/2000 PUBLIC\ZENWORKS\WMINV\BIN directory. The following text shows the contents of the file:
# *****************************************************************************# Running the DBMigrate Utility# # To run the DBMigrate Utility do the following :# 1. Check if the environment variable JDBC_DRIVER points to the# path where JDBCDRV.ZIP and CLASSES111.ZIP is present.## 2. Check if the environment variable WORKING_PATH points to # the path where ZENINVSERVER.JAR, STATUSLOG.JAR and # DESKTOPCOMMONUTILITY.JAR are present.## 3. Enter the IP address of ZENworks 5 Inventory # database server after the switch '-dbloc'.# For example,# .... $CLASSPATH -dbloc 164.99.156.134 .....## 4. Enter the IP address of ZENworks 2 Inventory database# server after the switch '-zen2dbloc'.# For example,# .... $CLASSPATH -dbloc 164.99.156.134 -zen2dbloc 164.99.156.135 ....## *****************************************************************************# FOR ORACLE# If the Zenworks for Desktops 3 inventory database is running on Oracle, then # uncomment the below line and comment the sybase line.# Also give the correct Oracle database SID for -sid switch.#java -ns com.novell.zenworks.desktop.inventory.migration.database.Loader -classpath $classpath;$tmppath -nds -dbloc 164.99.149.246 -zen2dbloc 164.99.145.53 -oracle -sid orcl -Logfilename sys:\etc\dbmigrate.log# FOR SYBASE# If the Zenworks for Desktops 3 inventory database is running on Sybase, then uncomment the below line and comment out the above oracle linejava -ns com.novell.zenworks.desktop.inventory.migration.database.Loader -classpath $classpath;$tmppath -nds -dbloc 164.99.149.196 -zen2dbloc 164.99.145.53 -Logfilename sys:\etc\dbmigrate.logFollow the instructions in the file header and edit the file with the correct IP addresses of the ZfD2 server you are migrating from and of the ZfD3 server you are migrating to.
Be sure to use the command line that matches with the type of database you are running for ZfD3.
Run the appropriate file (whether DBMIGRATE.BAT or DBMIGRATE.NCF) from the server console.
After you migrate the database, you can use the inventory policies to choose when you want to rescan the workstations. For more details on how to migrate the ZfD2 inventory data to ZfD3, see Migrating the Inventory Information from the ZENworks 2 Database in Understanding Workstation Inventory in Administration. This documentation also provides several scenarios that may help you in the migration process.