1.2 Database Considerations

Before you perform the upgrade from ZENworks 2017 to ZENworks 2020, consider the following guidelines:

  • If you are using the Sybase database, then ensure that you migrate the database to the PostgreSQL database.

    For more information, see Database Migration from Sybase to PostgreSQL.

  • If you are using an external database, you need to upgrade or migrate the external database to the supported latest version before upgrading the Primary Server.

    NOTE:If the ZENworks database is configured to the compatibility level of an older version of the Microsoft SQL Server, for example, 2005, then it should be set to the current supported version of the SQL Server.

    For more information about the supported database versions, see Database Requirements, in the ZENworks Server Installation guide.

  • (Recommended) Select the type of database based on the number of devices in the environment:

    • For environments with up to 5,000 devices, use Embedded PostgreSQL

    • For environments with up to 20,000 devices, use Remote PostgreSQL.

    • For environments with up to 40,000 devices, use MS SQL or Oracle.

    • For environments with more than 40,000 devices, use Oracle Enterprise Edition (with partitioning). For information about partitioning, see Oracle Enterprise with Partitioning, in the ZENworks Server Installation guide.

    If the existing database does not meet the recommendation, migrate the existing database after the upgrade is complete.

  • For upgrading database, you can either upgrade the database on the same device where it is running or you can migrate the database using a third-party upgrade installer.

    If you are using an embedded PostgreSQL database, the ZENworks Upgrade installer will upgrade and rebuild the database.

    NOTE:On a server that hosts an embedded PostgreSQL database, ensure that you have the required free space, equal to the size of the database file.

  • You can only upgrade to a higher version of the same database. You cannot migrate from one database to another using the Upgrade installer.

  • For all external databases, stop the ZENworks services on all other Primary Servers before performing the database upgrade.

  • IMPORTANT:If you are using Microsoft SQL server database, before upgrading your zone, ensure that the database tables are available in the default database schema DBO. If the ZENworks database tables are not present under the default database schema DBO, then to avoid any issues, contact Micro Focus Customer Support.

    To find out the database schema, run the following query in the Microsoft SQL database: SELECT distinct(SCHEMA_NAME(schema_id)) as OWNER FROM sys.objects WHERE type='U'