Ensure that all the tasks listed in Preparing to Move the Data are completed.
Run the database migration utility.
On the Windows Primary Server: At the command prompt, go to %ZENworks_home%\bin\, then enter the novell-zenworks-configure.bat -c DBMigrateConfigureAction command.
On the Linux Primary Server: At the console prompt, go to /opt/novell/zenworks/bin, then enter the novell-zenworks-configure -c DBMigrateConfigureAction command
Select the target database type as postgresql.
(Optional) Choose the purging option for data before database migration.
Specify the IP address of the PostgreSQL database server.
Specify the port used by the PostgreSQL database server.
(Optional) Specify the named instance for the PostgreSQL Server engine.
Choose to create a new database or use an existing database that resides on the PostgreSQL server.
If you choose to create a new database, continue with Step 9.
If you choose to use an existing database, skip to Step 10.
(Conditional) If you choose to create a new database in Step 8, perform the following tasks:
Specify the ZENworks database server administrator user name.
Specify the ZENworks database server administrator password.
Specify the database user name.
Specify the database user password.
Specify the name of the database that resides on the PostgreSQL server to which you want to migrate the data. If you choose to create a new database in Step 8, the database is created on the PostgreSQL server with the name that you specify in this step.
(Conditional) If you choose to create a new database in Step 8, specify the complete path where you want the database to be created.
Perform the steps from Step 5 to Step 11 for the ZENworks Audit database. The database migration starts.
When the database migration is complete, you can verify the novell-zenworks-configure.log file to see if the migration was successful. The log file is located in %ZENWORKS_HOME%\log\ on the Windows Primary Server and in /var/opt/novell/log/zenworks/ on the Linux Primary Server.
After the database is successfully migrated:
Perform post-migration tasks. See Post-Migration Tasks.
Re-configure the ZENworks Reporting Server to point to the PostgreSQL database, because it will still be pointing to the Sybase database.
If the migration of the database is stopped for some reason, the ZENworks migration utility allows you to resume the migration if the dbmigration.xml file has been created. This file is located in the %ZENWOKS_HOME%\bin directory on the Windows Primary Server, and in the /opt/ novell/zenworks/bin directory on the Linux Primary Server.
Run the database migration utility. For more information, see Step 2 in the Section 23.0, Migrating the Data from an External Sybase Database to an External PostgreSQL Database.
Specify the target database type as sql database server.
Specify the IP address of the PostgreSQL database server.
You must specify the IP address of the PostgreSQL database server used while migrating the database. For example, if you had specified the IP address of the database server while migrating the database, you should not specify the host name of the database server.
(Optional) Specify the named instance of the PostgreSQL Server engine.
Choose to use an existing database.
Specify the credentials of the database user depending on the authentication mode selected.
Specify the database name.
Resume the database migration.
After the database is successfully migrated, continue with Post-Migration Tasks.