Before you perform the upgrade from ZENworks 11 SP4 to ZENworks 2017 later, consider the following guidelines:
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.
(Recommended) Select the type of database based on the number of devices in the environment:
For environments with up to 3,000 devices, use Embedded Sybase or Remote Sybase.
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 Sybase database, the ZENworks Upgrade installer will upgrade and rebuild the database.
NOTE:On a server that hosts an embedded Sybase 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 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 Center.
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'