White Papers

Upgrading OME version
26 Installing Dell EMC OpenManage Essentials
database is installed locally and a supported case-insensitive SQL Server instance is also found on the
local box, the Essentials database will be migrated to a case-insensitive SQL Server instance during the
upgrade.
After upgrading to OME v2.5, the CMC templates and scheduled deployment tasks that were created in
versions prior to OME v2.3 will become unusable after the upgrade. You must recreate the templates and
reschedule the deployment tasks after upgrading to OME v2.5.
During the upgrade, OME v2.5 uses the previously installed OME settings. These options (Custom Path,
Ports, database server settings, and so on) are not displayed during the upgrade. The installation settings and
configuration for OME are displayed on the Ready to install the Program page.
9.1 Data migration during OME version upgrade
During the OME version upgrade:
• If the SQL Server instance selected by v2.5 and the SQL Server instance selected by the previous
version of OME are different, the OME database will be migrated
• If the previous version of OME is installed on the remote database, the database will not be migrated.
For details, see Table 7.
Example: If you have installed v1.3 on local SQL Server Express edition with instance name SQLEXPRESS,
then v2.5 will target the SQLEXPRESSOME instance installed with the SQL Server Express edition version
2012 (installed as part of the prerequisite) for installing the database during the version upgrade. Data from
v1.3 will be copied to the new database “OMEssentials” created on the SQLEXPRESSOME instance, which
will be used by v2.5. The old “OMEssentials” database on the SQLEXPRESS instance will be retained and
will not be deleted.
SQL Version
SQL Edition
Instance used for
installing
v1.0.1\v1.1
Prerequisite
Status
Prerequisite
Message
Data
Migration
Required?
2005 / 2008
Standard /
Enterprise /
Datacenter
Default
Critical
No supported
SQL found
Yes
Custom Name
Critical
No supported
SQL found
Yes
2005 / 2008
Express
Default
Critical
No supported
SQL found
Yes
Custom Name
Critical
No supported
SQL found
Yes
2008 R2 /
2012 / 2014 /
2016
Standard /
Enterprise /
Datacenter
Default/Custom
Name
None
None
No
SQLEXPRESSOME
None
None
No
2008 R2 /
2012 / 2014 /
2016
Express
Default/Custom
Name
Critical
No supported
SQL found
Yes
SQLEXPRESSOME
None
None
No